[Gambas-user] RE: Database Field Names

[ron]

On Tuesday 18 April 2006 22:09, Benoit Minisini wrote:
> 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,
> 

Let the names as the user it enters.
It is his fault if the backend does not now the name in the case he ask.

If some systems are case sensitive and are created with mixed case field 
names and gambas converting to lower case the user is in trouble now.

He enters as field name 'CreateDate' as in the databse definied.
gambas send 'createdate' and the backend don't understand it.

It is the users requirement to enter the correct names or he has troubles.
By auto changing to lowercase gambas is giving him the troubles.


My 2 cents :)

Ron