Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: GetTableNames for SQLite database


This question is answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Jan 8, 2015 8:12 PM Last Post By: Dmitry Arefiev
Larry X

Posts: 15
Registered: 6/29/06
GetTableNames for SQLite database  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 8, 2015 1:08 PM
I use the following syntax to get a list of tables in the SQLite database to which FDConnection1 is connected:

FDConnection1.GetTableNames('', '', '', ListBox1.Items, [osMy, osSystem, osOther], [tkTable, tkView]);

But the only table that gets populated in ListBox1 is sqlite_master.

Any thoughts would be appreciated. Thanks.
Dmitry Arefiev

Posts: 1,406
Registered: 12/7/03
Re: GetTableNames for SQLite database  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 8, 2015 8:12 PM   in response to: Larry X in response to: Larry X
If you expect, that there are other tables, then try to query any one of these tables.
If you will fail to query, then probably this is a new database. Which may be created
when you specified wrong path to existing database.

If all above is not true, then please provide environment report, generated from your
test application:
http://docwiki.embarcadero.com/RADStudio/XE7/en/DBMS_Environment_Reports_(FireDAC)#Using_Delphi_Code

--
With best regards,
Dmitry Arefiev / FireDAC Architect

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02