Recent content by Richard Grimmett

Thanks Cringer, rowid cannot be accessed via openlink drivers (I am using SQL89). But it might not have helped either. I am not that experienced with Progress, am self teaching and come from other database backgrounds. I did not know about sequences, and I have just tried them and they seem...

I need to access a Progress 9.1d table via OpenLink jdbc drivers, and process the rows in the order in which they were created. I do have control over the creation of the rows within the ABL app, but cannot see a way of allocating an auto increment field in 9.1d, and do not particularly want to...

Thanks again to Stefan and Osborn. I now have a working procedure which I can use for any table in my database. For the record, and anyone looking for the same, here is the solution: DEFINE INPUT PARAMETER hnewtab AS HANDLE NO-UNDO. DEFINE INPUT PARAMETER holdtab AS HANDLE NO-UNDO. DEFINE...

Thanks Osborne, but that will only give me whether they are equal or not. I already know they are not equal and I was using BUFFER-COMPARE to extract the differences. Are you suggesting I should compare on a field by field basis? Thanks Richard

Thanks Stefan, that has given me hope. I confess that I am a self taught newbie on Progress, having spent most of my professional life on Oracle, SQL Server and MSSQL. I have made the changes you suggested, and defined variables for the Buffers and then created the buffers. My problem is now...

I know 9.1d is old hat, but we really cannot migrate currently. I am trying to develop a WRITE trigger which I can use across multiple tables. These tables already have some complex triggers and so I simply want to install a run statement into the existing trigger to my new routine. The...