[prev in list] [next in list] [prev in thread] [next in thread]
List: gambas-user
Subject: Re: [Gambas-user] How to address more than one table in resultset
From: Benoit Minisini <gambas () users ! sourceforge ! net>
Date: 2009-01-29 15:28:21
Message-ID: 200901291628.21841.gambas () users ! sourceforge ! net
[Download RAW message or body]
On jeudi 29 janvier 2009, Ron_1st wrote:
> On Thursday 29 January 2009, Benoit Minisini wrote:
> > The '!' syntactic sugar works only if you use an identifier. Otherwise
> > you must use the [] syntax: rResult["triggers.id"].
>
> Does gambas returns then from second table 'triggers' the field 'id'
> as "triggers.id" ?
>
> The query "SELECT * FROM table1,table2 WHERe table1.id= table2.id"
> I'v never seen every field is returned as "table1.anyname".
>
> Just a question, I can't remember 100% or try ATM here to verify.
>
Alas, it depends on the database driver. (SQL... standard ?)
--
Benoit Minisini
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic