I am having some difficulty diagnosing an issue using Progress OpenEdge 10.1b (05.20.0083).
We are the developer of an application that tries to access a Progress Database over ODBC. The sql is automatically generated, so this issue is a little hard to test.
I am receiving a similar error...
Thanks for the quick response.
Yeah reading the docs, I should be able to do the query I tried, but for some reason, I don't seem to have access to all the "tables" in SYSCOLUMNS.
I'm guessing there is a permission issue. or something similar.
Good Day,
I'm having trouble finding a fast and simple way of seeing if a column exists on a Progress Data base.
I can find out if the table exists using:
SELECT DISTINCT tbl FROM sysprogress."SYSTABLES" WHERE UPPER(tbl) = UPPER('TABLE-NAME')
But for some reason I cannot get the query:
SELECT...
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.