Using ZeosLib 7.2.0 Beta in C++Builder XE2 and SQLite 18.104.22.168, I wasn't able to list Columns using the TZSQLMetadata component. I've tested (MetadaType = mdTables) and it works fine, but (MetadaType = mdColumns) shows a empty ZMetaData object (via DBGrid visual component).
Here are the basic property settings.
Code: Select all
ZConnection->ControlsCodePage = cGET_ACP
ZConnection->Database = C:\MyApp\EssentialSQL.db
ZConnection->LibraryLocation = C:\MyApp\sqlite3.dll //Version 22.214.171.124
ZConnection->Protocol = sqlite-3
ZMetaData->Connection = ZConnection
ZMetaData->MetadaType = mdColumns
DSource->DataSet = ZMetaData
DBGrid->DataSource = DSource
Am I missing something here? I can share the demo database I'm testing.
Thanks in advance.
P.S. Please alert me if this subject is better on ZeosLib 7.2 Beta's forum.