[Gambas-user] Some bugs

[Nigel Gerrard]

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

----- Original Message ----- 
From: "Nigel Gerrard" <nigel at ...38...>
To: <gambas-user at lists.sourceforge.net>
Sent: Sunday, June 06, 2004 11:06 AM
Subject: Re: [Gambas-user] Some bugs


> On Saturday, June 05, 2004 1:28 PM  Jonas Baggett wrote:
> >
> > I found 2 bugs with the sqlite driver:
> > 1) When I get some data from a database, sometimes the last 2 or 3
> > characters of the data are replaced by a "X", "P" or "`". With 1 or 2
> > refresh, the data becomes OK.
>
> I have not seen this behaviour before.  Would it be a possible to have a
> copy
> of your project to reproduce this error.
>
> > 2) I made a database whose fields have the first character in uppercase,
> > and when I execute a SQL request (SELECT ...) if I want to read what to
> > read the result, I have to type TheResult["one_field"] rather than
> > TheResult["One_field"]. If not there is this error: "Unknown field:
> > One_field". I remember that I didn't have this bug with Gambas 0.92.
> > I tried mysql, and I don't have this 2 bugs.
> >
>
> In both mysql and sqlite field names are infact case insensative, so these
> fields are the
> same.  I'm not sure why it would work in 0.92 and not in 0.93 as I don't
> believe any
> changes were applied to the database components between versions.   Saying
> that,
> there is a possibility that there may be a similar problem to that posted
a
> couple of
> days ago with regard to the mysql driver.
>
> Please try the following update to the following file in the sqlite driver
> directory and recompile:
>
> ...../src/lib/db/sqlite/dataset.cpp
>
> line 519: if ((*fields_object)[i].props.name == fn )
> to:         if (strcasecmp((*fields_object)[i].props.name.c_str(),fn) ==
0)
>
> Let me know how this goes and I'll get Benoit to correct.
>
> Nigel
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the new InstallShield X.
> From Windows to Linux, servers to mobile, InstallShield X is the one
> installation-authoring solution that does it all. Learn more and
> evaluate today! http://www.installshield.com/Dev2Dev/0504
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user