[Gambas-user] Aahhhggrr Databasemanager

[Steven Lobbezoo]

OK,
But that is NOT good behavour !
I work with mysql, and it's sensitive to the case of field-names.
A reason to NOT change them to lower case
(or at least warn the user)
The conversion should then be done in the individual drivers, not in the 
user part! 
I admit it's difficult if you consider someone using the same field-names
with upper- and lower-case letters in f.i. MySQL, than switching to a 
non-sensitive systems could couse porblems. However, I think that
the case is much more exeptionel as the simple re-genaration of an
existing database.

Steven


Le jeudi 29 mars 2007 21:30, Benoit Minisini a écrit :
> On jeudi 29 mars 2007, Steven Lobbezoo wrote:
> > Hi,
> >
> > I small bug with HUGE consequences :
> > If you use the "Gestionaire de base de données" from Gambas, and you
> > change a field (string -> blob, since Gambas refuses to handle blob data
> > in a string databse field) or add a field,  ALL capitals in the field
> > names of ALL fields are changed to small letters!
> > SO, either I change it back, or have to change all other programs
> >
> > Steven (still like gambas anyway)
>
> The gambas database driver force every field name to lower case so that it
> can be sure that field names are not case sensitive. The reason was that
> some databases are case sensitive with field names, some are not.
>
> Regards,