[Gambas-user] RE: Database Field Names
Benoit Minisini
gambas at ...1...
Tue Apr 18 22:09:51 CEST 2006
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
More information about the User
mailing list