Hi All
I am passing an SQL string to the EasySoft Interbase ODBC driver (accessing an Interbase 6 DB) from a GIS package.
When passing an SQL string to an MS Access DB one can use the FIRST command to limit the rows returned to just the first row e.g.
SELECT DISTINCT [SPECIMENS].[CASNO]...
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.