[Gambas-user] SQLite3 Query failed: SQL error or missing database

Robert Held robert.martin.held at ...1601...
Fri Apr 1 10:04:48 CEST 2011


Hello,

when I try to get data out of a table "dummy" with a
DataSource-Control and a DataView-Control, I get this error: "Query
failed: SQL error or missing database".
With DB.Debug = "on" I can see that Gambas compose a wrong SQL-Statement.
e.g.
Table: dummy
Fields: fe_id, fe_name
the SQL looks like this:

select from dummy

If you can see, no field list!

Tried with Gambas 2.22 on Fedora 14 and 2.21 on Ubuntu 10.10

Changed connection type from "sqlite3" to "postgresql" and it worked.

Any ideas?

Thanks
Robert




More information about the User mailing list