Recent content by smoser16

Unfortunately I don't have any control over the Progress database and cannot add a column. I know that I can't rely on the ROWID over time, but I was hoping that I could use it during "operational hours" when I know the data will not be dump-and-loaded etc.

I have a Progress database that I need to poll on a regular interval to get the new rows in certain tables. Not all of these tables have a date column or other column that can be used in the query to tell which rows are new. Can ROWID be used? Is it sequential? SELECT * FROM pub.MyTable WHERE...

My latest attempt is to use the LEFT function in my SELECT to trim the values myself, but I still get the same error, even in SQL Explorer.

Yes, they've been given table and column names. They are an extremely difficult company to deal with which is why if I could solve it on my end that my life would be so much easier. It is actually quite an old application, I think more than 10 years old.

That's pretty much the conclusion that I've drawn, that WorkArounds2=8192 does not address the issue I'm seeing. I think they've sent me down the wrong path since anytime I ask for more information they just send the same instructions again. Looks like I'm stuck.

Thanks for your reply Casper, but the database is owned by a 3rd party and I have zero control over it. They tell me that they run dbtool once a week, but I get the error constantly.

I'm trying to make calls into Progress using the ODBC Merant 3.60 32-BIT Progress SQL92 v9.1D driver in C#. I've been getting the following error on some records: The Progress database belongs to a 3rd party application and I have no control over it what so ever. The company that provides this...