[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_1st" <ronstk () tiscali ! nl>
Date:       2009-01-29 15:25:46
Message-ID: 200901291625.46746.ronstk () tiscali ! nl
[Download RAW message or body]

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. 



> 
> Regards,
> 
> -- 
> Benoit Minisini
> 


Best regards,

Ron_1st

-- 
 A: Delete the text you reply on.
 Q: What to do to get my post on top?
 A: Because it messes up the order in which people normally read text. 
 Q: Why is top-posting such a bad thing? 
 A: Top-posting. 
 Q: What is the most annoying thing in e-mail? 
 

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