Search results

Well, I've managed to resolve the problem; it seems that Progress doesn't like to use functions in the group by clause. So the following SQL does what I want: select count(*), "fnam", '<DLX_END_MARKER>' AS END_QUERY_MARKER from ( select TRANSLATE( UPPER ("fnam" )...

Thanks RealHevyDude, I've been looking at the SQL Language Reference but I can't see anything which should stop my SQL from working.

Hi, I am a total newb working with Progress however thus far I have found the implementation of SQL to be rather nicer than some other databases I have used, however I am having a problem with a particular query and I wonder if somebody could please explain to me why it doesn't work? SELECT...

Hi, Yes I am working with version OpenEdge 10.1A I have managed a bit of a work around; if I create link tables in Access I can interrogate the database catalog from Access. Once I have the meta data I can then switch the odbc connection to point directly at the OpenEdge database and things...

I have found a fix for this, editing the windows registry entry and adding a new entry WorkArounds2=8192 into the ODBC driver properties has enable me to at least create link tables to MS Access. See this link for a better explanation...

Ok, I think I have found something: OpenEdgeTM Data Management: SQL Reference http://www.progress.com/progress/products/documentation/docs/dmsrf/dmsrf.pdf So I think I should be able to do something like this: select tbl , owner , tbltype from sysprogress.SYSTABLES and then for each...

SQLTables is a standard ODBC function that returns the list of table, catalog, or schema names, and table types, stored in a specific data source. http://msdn.microsoft.com/en-us/library/ms711831%28VS.85%29.aspx If necessary I could amend the program to run a specific query instead of making...

As I am a bit stumped so far on this problem I thought I'd try to connect via Access as suggested in this thread: http://www.progresstalk.com/showthread.php?115552-Accessing-system-tables-ODBC Access is able to get a list of the tables but fails with the following error when I try to create a...

Hi, I'm new to Progress so please be gentle with me! I have a customer who has a Progress database and I have been asked to perform some Data Quality evaluation of their data. My company has written a data profiling tool which connects via ODBC, returns the schema and allows us to browse the...