Search results

hi folks, i need your help. i get this exception querying to a progress 9.1d db. === SQL Exception 1 === SQLState=HY000 ErrorCode=-210015 [JDBC Progress Driver]:Failure getting record lock on a record from table PUB.zimmer. need some help. what to do? regards

Hi bros, i m using Progress v9.1D and i wanna get rows from 3 tables. Code looks like this: select a.name, u.preis, ud.date from artikel a, usamtz u, umsatzdatum ud where a.id = u.artikel and u.nr = ud.nr This querry runs in my SQL Explorer. The SQL Explorer just show 100 rows every result...

hello colleagues, maybe i am bit "blem blem" now after coding over hours. but how can i solve this problem? i have a select that returns 100k entries and i wanna select another column from another table, too. but the resultset must not reduce. e.g.: --returns 100k entries select ca from...

hi mates, i need ur help again. it is about altering a table. i would develop it like this: ALTER TABLE table_name ALTER COLUMN column_name SET PRO_SQL_WIDTH x(128) some questions: - is this anyway possible? - if yes, is this possible to a table which is already filled with thousands of...

hi mates, i need ur help. i dont know where the syntax problem comes from in this code: select INTEGER(SUBSTRING(STRING(table.column, "9999999999":U), 10, 1)) columnname from table can u help me plz? regards Daman

hi mates, i need some help navigating through the system catalog. i want to search all columns in my system with a special content. something like this: select col, tbl, coltype, nullflag, width from sysprogress.SYSCOLUMNS where coltype = 'integer' and owner = 'pub' and col -- now comes psydo...

hi bros, i have a syntax problem with additional characters in the following code: select column-name from tablename how to handle this?:confused: regards Daman

Hey bros, I have a little syntax problem. I am already searching for about 2 hours what string and count functions Progress has. But I'vent found enough. So I thought, maybe you can help me. What is the real Progress Syntax of this: SELECT SUBSTRING('12;3', 1, (SELECT CHARINDEX(';'...

hi mates, i have a little problem. i use progress db and the db tool is data dictionary. my problem is as follows: if i make a select on a table when a special column is affected, this compiler message returns: "**FILL-IN column1 paßt nicht in den FRAME im PROGRAM . (4028)" (original german)...