[Gambas-devel] More Database Driver Changes

[Nigel Gerrard]

Benoit,

Here you are. Following on from your later email about using
rData["Table.Field"],
I can confirm that I have changed the drivers and this now works for
multitable fields.

I have included ChangeLogs for the changes I have made.

Nigel

----- Original Message ----- 
From: "Benoit Minisini" <gambas at ...1...>
To: <gambas-devel at lists.sourceforge.net>
Sent: Sunday, May 16, 2004 9:16 PM
Subject: Re: [Gambas-devel] More Database Driver Changes


> On Monday 19 April 2004 20:12, Nigel Gerrard wrote:
> > Benoit,
> >
> > Could you have a look at the following changes and feedback your
> > comments.  The changes apply to gambas-0.92.
> >
> > The major change is an attempt to implement access to fields with the
> > same name contained in a multiple table query. e.g.
> >
> > select fred.field1, sid.field1 from fred, field.
> >
> > In order for this to work within Postgresql, version 7.4.1 or greater
> > needs to be available.
> >
> > Please note that I have defined the $ character to separate
> > tablename$filedname within the class.  It would be better if '.' could
> > be used as $ is valid within field/tablename.  In each of my attempts to
> > use '.' a syntax error is thrown (thus I've gone to $). I'm sure  that
> > you will be able to get around this.
> >
> > Project.Module is a rouh demonstration of what I have been trying to
> > achieve.
> >
> > The other major change (and probably the one I have not tested enough)
> > is the use of parameters within .EXEC eg. .Exec("select * from &1",
> > table) would get evaluated as select * from 'table' which would throw an
> > error in mysql or postgresql.
> >
> > Have a look at the changelogs to see what else has been implemented.
> > Drop me a line if there is anything you need.
> >
> > Nigel
>
> Hi, Nigel.
>
> Excuse me, I completely forgot your patch.
>
> I think this is the the beginning of the Linus syndrome...
>
> I apologize, I apologize...
>
> Is it possible for you to send me a src/db directory updated for 0.93 ?
>
> I thnk you can send me a complete src/db source directory, without using
diff
> files, as I didn't touch them since a while, and as I don't know how to
apply
> them in one shot.
>
> I'm not sure for the gambas-database-manager. Could you send me it
completely
> too, by taking the one in 0.93 ?
>
> Regards,
>
>
> -- 
> Benoit Minisini
> mailto:gambas at ...1...
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: SourceForge.net Broadband
> Sign-up now for SourceForge Broadband and get the fastest
> 6.0/768 connection for only $19.95/mo for the first 3 months!
> http://ads.osdn.com/?ad_id=2562&alloc_id=6184&op=click
> _______________________________________________
> Gambas-devel mailing list
> Gambas-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-devel
-------------- next part --------------
A non-text attachment was scrubbed...
Name: db_changes.tar.bz2
Type: application/octet-stream
Size: 48174 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/devel/attachments/20040517/ed29f326/attachment.obj>