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 ?
Delphi XE2 open result dataset from VIEW in SQLITE3
Re: Delphi XE2 open result dataset from VIEW in SQLITE3
Never mind, I closed and opened the database, problem solved.