[Gambas-user] RE: Database Field Names

[Benoit Minisini]

On Tuesday 18 April 2006 21:26, Timothy Marshal-Nichols wrote:
> I am using the Gambas database objects to create a database.
>
> Why on earth does Gambas always convert field names into lower case. You
> enter a field name of 'CreateDate' and Gambas always converts it to
> 'createdate'. I find this really annoying. It does not do this to table
> names or database names or the primary key field name!!! Why the hell does
> it mess up my field names. It's just plain stupid.
>
>
> Thanks
>
> 8-{)} Timothy Marshal-Nichols
> <mailto: timothy.marshal-nichols at ...247...>
>

Because some database systems have case sensitive field names, and some others 
are not. The aim was to have the same code run whatever the database backend 
is.

The solution I used was always converting field names to lowercase. If you 
have a better solution...

Note that I find that annoying too. :-)

Regards,

-- 
Benoit Minisini