[prev in list] [next in list] [prev in thread] [next in thread] 

List:       gambas-user
Subject:    [Gambas-user] How to address more than one table in resultset
From:       Ron <ron () cyberjunky ! nl>
Date:       2009-01-29 11:31:48
Message-ID: 498193A4.3080001 () cyberjunky ! nl
[Download RAW message or body]

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
    IF rResult.Count THEN
      FOR EACH rResult
        IF rResult!enabled THEN
          IF rResult!trigger1 THEN
            rResultTrig = Main.hDB.Exec("SELECT * FROM triggers WHERE id 
= &1 ", rResult!trigger1)
            IF rResultTrig THEN
              IF rResultTrig!param1 =
...
       NEXT
----

to this (gets selected events and triggers table/fields):
----
  DIM rResult AS Result

  rResult = Main.hDB.Exec("SELECT * FROM events, triggers WHERE 
events.trigger1 = triggers.id AND triggers.type = 3 AND events.enabled 
AND triggers.param1 = &1", iId)

  IF rResult THEN
    IF rResult.Count THEN

      FOR EACH rResult
...
      NEXT
----
In the sql query tool from database manager it returns exactly the 
correct records/fields etc

But how can I get the fields from the triggers table from this resultset?

I cannot do something like  rResult!triggers.id
Is this possible?

Thanks.

Regards,
Ron_2nd.

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