Re: [Gambas-user] How to address more than one table in resultset

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 return

Re: [Gambas-user] How to address more than one table in resultset

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'

Re: [Gambas-user] How to address more than one table in resultset

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 tab

Re: [Gambas-user] How to address more than one table in resultset

On Thursday 29 January 2009, Ron wrote: > Ron_1st schreef: > > On Thursday 29 January 2009, Ron wrote: > > > >> Bit stuck. > >> > >> In an attempt to optimize some db queries. > >> > >> I changed this (gets all events first then check if enabled, then gets > >> the trigger fields for that event

Re: [Gambas-user] How to address more than one table in resultset

On jeudi 29 janvier 2009, Ron wrote: > Bit stuck. > > In an attempt to optimize some db queries. > > I changed this (gets all events first then check if enabled, then gets > the trigger fields for that event etc): > > DIM rResult, rResultTrig, rResultAction AS Result > > rResult = Main.hDB

Re: [Gambas-user] How to address more than one table in resultset

Ron_1st schreef: > On Thursday 29 January 2009, Ron wrote: > >> Bit stuck. >> >> In an attempt to optimize some db queries. >> >> I changed this (gets all events first then check if enabled, then gets >> the trigger fields for that event etc): >> >> DIM rResult, rResultTrig, rResultActio

Re: [Gambas-user] How to address more than one table in resultset

On Thursday 29 January 2009, Ron wrote: > Bit stuck. > > In an attempt to optimize some db queries. > > I changed this (gets all events first then check if enabled, then gets > the trigger fields for that event etc): > > DIM rResult, rResultTrig, rResultAction AS Result > > rResult = M

[Gambas-user] How to address more than one table in resultset

Bit stuck. In an attempt to optimize some db queries. I changed this (gets all events first then check if enabled, then gets the trigger fields for that event etc): DIM rResult, rResultTrig, rResultAction AS Result rResult = Main.hDB.Exec("SELECT * FROM events") IF rResult THEN I