Delphi XE2 open result dataset from VIEW in SQLITE3

The official tester's forum for ZeosLib 7.1. Ask for help, post proposals or solutions.
Post Reply
jaap
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 25.12.2013, 14:17

Delphi XE2 open result dataset from VIEW in SQLITE3

Post by jaap »

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 ?
jaap
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 25.12.2013, 14:17

Re: Delphi XE2 open result dataset from VIEW in SQLITE3

Post by jaap »

Never mind, I closed and opened the database, problem solved.
Post Reply