[Gambas-devel] [Fwd: Re: [Gambas-user] Embedded Database]
Philip A. Chapman
pchapman at ...33...
Sat Jul 12 16:58:45 CEST 2003
For the edification of others....
-----Forwarded Message-----
> From: Benoit Minisini <gambas at ...20...>
> To: Philip A. Chapman <pchapman at ...33...>
> Subject: Re: [Gambas-user] Embedded Database
> Date: 12 Jul 2003 12:34:16 +0200
>
> Le Jeudi 10 Juillet 2003 16:54, vous avez écrit :
> > On Wed, 2003-07-09 at 16:08, Benoit Minisini wrote:
> > > Let's decide that all incorrect or unknown datatypes become String.
> >
> > That is acceptable. I will parse the strings which are provided from
> > SQLite as datatype. If the data type word matches one defined by SQL97,
> > I will translate it into the gambas native type. If it cannot be
> > converted to the native type, I will raise an error. I feel the need to
> > specify this since you can store any string value in a field no matter
> > what the column type says.
> >
> > > It is not very important, as creating tables from the gb.db interface
> > > implies a control from the driver - It transforms the table description
> > > filled by the user into a SQL compliant CREATE TABLE statement.
> >
> > I respectfully disagree. I believe that this is important because the
> > developer may want to A) use gambas to access a SQLite database created
> > by a different program, such as the SQLite command line utility or B)
> > create the tables in the database using embedded SQL (passing in a
> > create statement) from within the application rather than Gambas' db
> > interface. In such situations, Gambas has no control over what the
> > datatype names are for the tables. I think that the above decision will
> > help Gambas deal with this issue.
>
> Hmmm... You are right. But don't forget to cache the CREATE TABLE statement
> analyze !
>
> Don't hesitate to go on the devel mailing-list, because, this way, all the
> explanations I will be able to give you, will be able to be read by other
> people. (The mailing-lists are automatically archived, and can be browsed
> with a search engine).
>
> Regards,
>
>
> --
> Benoit Minisini
> mailto:gambas at ...1...
--
Philip A. Chapman
Application Development:
Java, Visual Basic, PostgreSQL, MySQL, MSSQL
Linux, Windows 9x, Windows NT, Windows 2000, Windows XP
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.gambas-basic.org/pipermail/devel/attachments/20030712/ead711a7/attachment.sig>
More information about the Devel
mailing list