[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:       Ron <ron () cyberjunky ! nl>
Date:       2009-01-29 15:35:49
Message-ID: 4981CCD5.2020802 () cyberjunky ! nl
[Download RAW message or body]

Benoit Minisini schreef:
> 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 ?)
>
>   

For my purpose it works, with MySQL, and rResult["triggers.id"].
But my events.id is not linked to triggers.id, it event.trigger1 -> 
triggers.id

This solution with brackets is in my case better than the 'as "xx"' 
solution, since I use quite a few fields from both tables, and the query 
string got a bit long ;-)

Regards,
Ron_2nd.


------------------------------------------------------------------------------
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]