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

[Robert Held]

Hello,

small project at the attachment.

Thanks!

2011/4/1 Benoît Minisini <gambas at ...1...>:
>> 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
>>
>
> Can you provide a small project that shows the bug?
>
> --
> Benoît Minisini
>
> ------------------------------------------------------------------------------
> 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: sqlitetest.zip
Type: application/zip
Size: 9872 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20110401/3c303cc1/attachment.zip>