TSQLConnection.GetTableNames fails with SQL Compact
Posted: 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
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