Page 1 of 1

TSQLConnection.GetTableNames fails with SQL Compact

Posted: Sat 26 Jan 2008 06:43
by cameron
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

Posted: Mon 28 Jan 2008 16:25
by Antaeus
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.

Posted: Wed 30 Jan 2008 10:30
by Antaeus
We have fixed this problem. This fix will be included in the next DbxSda build. Please watch for announcements at this forum.