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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.