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

2009/7/17 Murray Cumming <[email protected]>

> On Tue, 2009-07-14 at 21:35 -0600, Shawn Ferris wrote:
> > Not that my opinion matters, but to add my $.02, I would absolutely
> > agree with this.. Nothing makes me more crazy than a tool creating a
> > table in oracle that is mixed case or using a reserved word.  I'm
> > mostly a command line guy and having to quote for quote sake is a
> > pain. I think it should follow suite to the rdms.. Sybase supports
> > mixed case natively so qoutes aren't necessary and oracle isn't by
> > default so its very awkward when introduced.
> >
> > I think tools need to support the ability to do this, but not as
> > default behavior.
>
> Glom is for users who don't care about SQL. Also, users of raw SQL will
> rarely want to use Glom's databases. I could prevent the user from using
> uppercase and spaces in table names but it would just seem arbitrary and
> unnecessarily techy, like requiring 8-character filenames.
>
> If quotes really mean "I really mean this" (as I believe) then I would
> expect well-written SQL to use them always, particularly if that SQL is
> generated.
>
> libgda generates SQL so it shouldn't require me to add quotes myself.


The new gda_sql_identifier_quote() function  does exaclty this for you: make
sure you pass TRUE as the last argument.

Vivien

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list