Le 04/07/2015 14:44, Klaus-Peter Mais a écrit : >> >> ok, ... i use the "sqlite data browser" >> (sqlitebrowser.sourceforge.net). But also in android the fields are >> without the reference (tableName.Field1, ........, tableName.fieldn in >> Gambas). >> I have the phenomenon only in gambas. Also in Android it's ok. >> >> Description: >> I will copy a table with content (in a gambas app) >> I use: create table newTable as select * from oldTable >> >> in my newtable i find the fieldnames: oldTable.Field1, ..........., >> oldTable.Field2 (for example with datagrid or directly over the field >> names with a result object. >> >> if i create this newtable with the sqlite browser or in android, and >> now when I look at the newtable in gambas, the fields are correct, >> without reference on old Table. >> Only, if i create with the sqlite statement: create table [name] as >> select * from [oldname], the problem arises in a gambas app. >> >> and unfortunately, these fields can not be addressed with SQL (for >> example:... where fieldname = 'trulla'). >> The same SQL statement in SQLite browser or android running, there is >> no problem. there is no reference to the oldTable. >> >> best Regards (from Sahara-Germany) >> >> Klaus-Peter Mais >>
When you open a sqlite database, Gambas issues these commands: PRAGMA empty_result_callbacks = ON PRAGMA short_column_names = OFF PRAGMA full_column_names = ON I suggest you call "PRAGMA full_column_names = OFF" before running your request in Gambas. Regards, -- Benoît Minisini ------------------------------------------------------------------------------ Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
