[Gambas-user] How to address more than one table in resultset
Ron_1st
ronstk at ...239...
Thu Jan 29 16:25:46 CET 2009
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?
More information about the User
mailing list