2009/6/29 Murray Cumming <[email protected]> > I should take the time to make a test case, but it looks like libgda 4.0 > fails to get the meta-data for a specified table if the table name has > capital letters. I guess that this is a quoting (and escaping) problem > somewhere.
Yes, you need to surround any SQL identifier which is not case insensitive (or which has some spaces, etc in it) with double quotes. You can use gda_sql_identifier_needs_quotes(). The doc in http://library.gnome.org/devel/libgda/4.0/information_schema.html#information_schema:sql_identifiers mentions the quotes usage in Libgda, but maybe I should add reminders in the functions's documentation for functions where this may be a problem. Vivien
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
