DaveBareham
New Member
I'm new to progress, so please bear with me! ALso the terms I use will be SQL terms rather than Progress terms....
For various reasons, I've been asked to write a piece of Microsoft Access code which links to tables in a progress database. I have managed to get this working using the Merant ODBC drivers.
However, sometimes I may wish to return a table which is a subset of the complete table. For example, I may wish to return a table which contains only entries where the country begins with a 'U'.
Lets assume that the table contains 10,000 records and only 100 of these have a country code beginning with 'U'. Obviously, it would be more efficient if the query could be executed on the server side. Is this possible using ODBC? Some databases allow you to pass sql via the odbc connector for execution on the server side.
Many thanks for your patience and your help.
Dave
For various reasons, I've been asked to write a piece of Microsoft Access code which links to tables in a progress database. I have managed to get this working using the Merant ODBC drivers.
However, sometimes I may wish to return a table which is a subset of the complete table. For example, I may wish to return a table which contains only entries where the country begins with a 'U'.
Lets assume that the table contains 10,000 records and only 100 of these have a country code beginning with 'U'. Obviously, it would be more efficient if the query could be executed on the server side. Is this possible using ODBC? Some databases allow you to pass sql via the odbc connector for execution on the server side.
Many thanks for your patience and your help.
Dave