Status: New Owner: ---- Labels: Version Type-Bug Priority-Medium OpSys-Any Dist-Any Arch-Any Desktop-Any GUI-Any
New issue 339 by schatten.markus: DataSource.Table does not read tables with non-lowercase names (PostgreSQL) http://code.google.com/p/gambas/issues/detail?id=339 If a table has a non-lowercase name it is impossible to use it with DataSource.Table since it seems to be "converted" to lowercase and the system returns an error about a non-existent table (SQL is case insensitive which is why this happens). Haven't tested with other DBMS, but with PostgreSQL 9.1.5: db=# CREATE TABLE "Uppercase" ( id SERIAL ); NOTICE: CREATE TABLE will create implicit sequence "Uppercase_id_seq" for serial column "Uppercase.id" CREATE TABLE Then in Gambas3 DS.Table = "Uppercase" where DS is a DataSource connected to the db above, raises the error: Query failed: ERROR: Relation "uppercase" does not exist LINE 1: SELECT COUNT(*) AS nRecord FROM Uppercase The query above would be correct if there were double quotes around the table name, e.g. SELECT COUNT(*) AS nRecord FROM "Uppercase" System info ----------- Version: 3.3.0 Operating system: Linux Distribution: Ubuntu Architecture: x86 GUI component: QT4 ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct _______________________________________________ Gambas-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/gambas-user
