TSQLConnection.GetTableNames fails with SQL Compact

cameron · Post by **cameron** » Sat 26 Jan 2008 06:43

Hi

Using SQL Compac 3.0 and Dbexpsda.dll (4.20.0.6), however i get the following error when calling TSQLConnection.GetTableNames

EOLEDBError with message 'There was an error parsing the query. [Token line number,Token line offset,,Token in error,,]'

sample code is below

lTables := TStringList.Create;
lTables.CaseSensitive := False;
SQLC.TableScope := [tsTable];
SQLC.GetTableNames(lTables, 'dbo', False);

i have also tried

SQLC.GetTableNames(lTables, False);

How am I meant to find out the tables within a SQL Compact database? Is there any documentation anywhere that states the limitations of your dbexpress driver when used against SQL Compact?

thanks in advance,
Cameron

Antaeus · Post by **Antaeus** » Mon 28 Jan 2008 16:25

Thank you for information. We have reproduced the problem. The investigation of the problem is in progress. As soon as we solve the problem we will let you know.

Antaeus · Post by **Antaeus** » Wed 30 Jan 2008 10:30

We have fixed this problem. This fix will be included in the next DbxSda build. Please watch for announcements at this forum.