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