Delphi XE2 open result dataset from VIEW in SQLITE3
Posted: 25.12.2013, 14:29
Using 7.1.2-stable in Delphi XE2 with SQLite3.
I defined a VIEW in the database and now I want to show the resulting dataset on a Delphi dbgrid.
The TZTable component only finds the tables, not the views.
A TZQuery with an SQL statement SELECT * FROM <name of the view>; gives an error message when activated: No such table.
How can I connect to a VIEW in an SQLite database ?
I defined a VIEW in the database and now I want to show the resulting dataset on a Delphi dbgrid.
The TZTable component only finds the tables, not the views.
A TZQuery with an SQL statement SELECT * FROM <name of the view>; gives an error message when activated: No such table.
How can I connect to a VIEW in an SQLite database ?