Re: [gnome-db] Per-table meta-data with capital letters in the table name?

2009/6/29 Murray Cumming <murrayc murrayc com>
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

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
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.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]