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

2009-01-29 Thread Ron_1st
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 =

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

2009-01-29 Thread Ron
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, rResultAction AS Result

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

2009-01-29 Thread Benoit Minisini
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 =

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

2009-01-29 Thread Ron_1st
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 etc): DIM

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

2009-01-29 Thread Ron
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