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

Vivien Malerba <[email protected]> Mon, 5 Oct 2009 09:59:57 +0200

Newsgroups	gmane.comp.gnome.db
Message-ID	<[email protected]>

2009/10/4 Johannes Schmid <[email protected]>:
> Hi!
>
>>
>> When database providers render a GdaServerOperation to SQL when
>> performing the operation, the SQL identifiers are copied without any
>> transformation, so it's up to you to correctly set the SQL identifiers
>> values (such as table name), so the anwser is no, you don't have to.
>
> Wouldn't it be useful if GdaSqlBuilder would automatically check if the
> SQL identifiers need quoting and quote them if needed? As I programmer I
> would expect that it takes care of it as it takes care for quoting SQL
> keywords.

Id does when you use gda_sql_builder_add_id(), see for example
http://git.gnome.org/cgit/libgda/tree/samples/SqlBuilder/example.c.

Vivien