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

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and 
publish your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user

Reply via email to