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], First([COLLECTORS].[SURNAME]) AS FirstOfSURNAME
I have been through the Interbase 6 documentation to see if I can find an equivalent but with no success. Any help would be appreciated.
Thanks
Greg
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], First([COLLECTORS].[SURNAME]) AS FirstOfSURNAME
I have been through the Interbase 6 documentation to see if I can find an equivalent but with no success. Any help would be appreciated.
Thanks
Greg