Can't connect to the database (Sqlite3)

[zzzzzzz7]

I already have a zdb.db file, which also contains a table (ID, NAME, etc.).
I am using Lus and cannot connect [Sqlite3Connerctiong1   SQL Transaction1   DataSource1   SQLQuery1].
1. Sqlite3Connerction1.DatabaseName = G\pascal\zdb.db;
Sqlite3Connerctiong1.Transaction = SQLTransaction1;
SQLTransaction1. = SQLite3Connection1;
DtatSource1.Dataset = SQLQuery1;
SQLQuery1.Database = SQLite3Connerction1;
If SQLQuery1.DataSource = DataSource1; (message: circular datasource references are not allowed);

DBgGrid1.DataSource = DataSource1;
Why can't I see the table I created in zdb (ID name, etc.) in DBgGrid1?
DBgGrid1.Active --- showmessage('SQL statement not set ');

How should I set it up to connect to SQLite3 correctly and display my table in DBgGrid1

[Zvoni]

Well, the message is clear: You have to tell the SQLQuery, which fields from which table to present.....

SQLQuery1.SQL.Text:='SELECT ID, Name FROM MyTable';
or set it in Object-Inspector

[zzzzzzz7]

thanks  , write select * from ...        the table show     

[CharlyTango]

I assume that @zvoni wrote
'SELECT ID, Name FROM MyTable';
on purpose because SELECT * is a bad habit and will bring you more troubles than you are willing to solve on the long run.