Search code examples
sqlitegambas

Tablenames in sqlite Result

Hy I wrote an Application with Gambas uning SQLite

When I try to port to another Linux Ditro, I have different keys for the fields in the resultset for the SQLite Result

For example:

sqlect * from table

In on resultset I get 

res["Tablename.Column1"] = Value
res["Tablename.Column2"] = Value
res["Tablename.Column3"] = Value

and In onther it is

res["Column1"] = Value
res["Column2"] = Value
res["Column3"] = Value

this is a big problem for me. Any Ideas ?

Solution

  • After a very long journey I found it: I have to call 

    PRAGMA short_column_names = OFF

    Very detailed Information can be found here:

    https://www.sqlite.org/pragma.html#pragma_full_column_names