[Gambas-devel] [Fwd: Re: [Gambas-user] Embedded Database]

[Philip A. Chapman]

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>