Title: Re: SQLite: Get field names from table
Post by: Zvoni on September 28, 2021, 08:39:06 am
Use "GetFieldNames" of TSQLite3Connection of TSQLConnection (SQLite3Connection inherits from it) --> TSQLite3Connection overrides the one from TSQLConnection https://www.freepascal.org/daily/packages/fcl-db/sqlite3conn/tsqlite3connection.getfieldnames.html https://www.freepascal.org/docs-html/fcl/sqldb/tsqlconnection.getfieldnames.html
EDIT: Alternative is to fire a PRAGMA-Call from a TSQLQuery-Object