Recent content by Damanindahaus

Re: === SQL Exception 1 === SQLState=HY000 ErrorCode=-210015 [JDBC Progress Driver]:F select * from pub.zimmer

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...

i waited for about 5 mins. and if i make a select * from table through sql explorer tool, it doesn't even take a second. so i though, that it is not running anymore and i interrupted. the table just has 280k entries.

@realheavydude: i tried to develop 4gl like " for each table: display column. end. " in the sql explorer it doesn't function. in procedure editor it lasts too long, so i interrupted it. where should i run this 4GL? regards daman

thx to all of you. @oetalker: i really was confused. usually i should know, how to handle this ;) this sql works in sql server 2005 but not unfortunately not in progress. but the problem is a column with exceeding value ... i hope this sql helps me after i ve changed the column format...

i tried this: select a.ca, (select b.cb from from table2 b where ...) anothercolumn from table1 a where a.id = b.id but i got a syntax problem. any suggestion? regards

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...

btw, is alter table possible to progress 9.1d? or is this first supported from open edge versions?

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...

thx. unfortunately it doesnt run with my version. i export this to .net and handle this outside of progress.

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 mate, thx a lot

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