[Gambas-user] Some bugs

[Nigel Gerrard]

Benoit,

I will send the changes  soon but you'll need to check them as I haven't
been
able to meet everything that you wished for in the last email :-)

As for mysql and Sqlite field names are insensative in that Field1 = field1,

so Create table Fred ( Field1 int, field2 text);
select field2 from Fred where field1 = 2; will work and so will
select Field2 from Fred where Field1 = 2

But Field1 and field1 can be stored as the field name in the schema.

Only gambas tries to stop this implementation.

Nigel

----- Original Message ----- 
From: "Benoit Minisini" <gambas at ...1...>
To: <gambas-user at lists.sourceforge.net>
Sent: Monday, June 14, 2004 10:11 PM
Subject: Re: [Gambas-user] Some bugs


> On Thursday 10 June 2004 20:28, Nigel Gerrard wrote:
> > Further to the answer below, currently gambas only creates field names
> > in lower case. e.g. if you have used  hTable.Field.Create("LOWER",
> > gb.String)
> > then the field name will be converted to lower case - lower.
> >
> > I'm not sure why the driver needs to convert case before creating a
field;
> > perhaps Benoit can answer.
> >
> > Nigel
> >
>
> I did that because I innocently thought that in SQL fields were case
> insensitive !
>
> SQL is the worst implemented standard I ever see! There isn't two database
> backends that have the same behaviour !
>
> I think we should simulate that fields are case insensitive by:
>
> 1) create fields in lower case (already done)
> 2) convert fields name in lower case when reading the database (partially
> fixed)
>
> Tell me Nigel if you can send me an update of the database driver soon. If
you
> can, I will wait before releasing the 0.94. Otherwise, I want to make more
> important changes in the Gambas database drivers before the 1.0, as I told
> you before.
>
> Regards,
>
> -- 
> Benoit Minisini
> mailto:gambas at ...1...
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference
> Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer
> Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA
> REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user