Hi, I’ve some problems with the ODBC Select Command. If I try to get just a limited number of data records, I’m getting an Error. My Select Command looks like this: “Select * from table LIMIT 10” But it does not work. Does anyone know if it is possible to use the LIMIT command? Thanks in advance!!!
If you’re talking C/ODBC you can’t do it, even with a nested query. If you’re talking SQL Server ODBC driver, then its SELECT TOP 10 * from table.