More than one database query at a time

jcoleuk · Post by **jcoleuk** » Sat Feb 11, 2006 3:08 pm

How can I do something like this:

  If DatabaseQuery("SELECT...") = 0
    MessageRequester("Error", "DB ERROR: "+DatabaseError())
  Else
  
    While NextDatabaseRow()

      DatabaseQuery("SELECT...") = 0
      ; Second database query!
    
    Wend
    
  EndIf

I need to be able to run a query using data retrieved for each row of the first query, can this be done in PureB? I can do it in PHP.

Paul · Post by **Paul** » Sat Feb 11, 2006 4:10 pm

Open 2 instances to your database

Code: Select all

OpenDatabase(0,"myDatabase"...
OpenDatabase(1,"myDatabase"...

  UseDatabase(0)
  If DatabaseQuery("SELECT...") = 0
    MessageRequester("Error", "DB ERROR: "+DatabaseError())
    Else
 
    While NextDatabaseRow()
      UseDatabase(1)

      DatabaseQuery("SELECT...") = 0
      ; Second database query!

      UseDatabase(0)
    Wend
   
  EndIf

NoahPhense · Post by **NoahPhense** » Sat Feb 11, 2006 4:23 pm

Threads ..

Post by **Fred** » Sat Feb 11, 2006 4:51 pm

With PB4, each database commands has a database number as well.

jcoleuk · Post by **jcoleuk** » Tue Feb 14, 2006 7:24 pm

Thanks Paul I used your method and it's worked great.

I'm a bit worried about the number of calls to the database I'm having to do, but I'll sort that out later.

Paul · Post by **Paul** » Tue Feb 14, 2006 7:45 pm

Are you not able to get the desired data by joining tables in your query?

jcoleuk · Post by **jcoleuk** » Tue Feb 14, 2006 7:50 pm

I know that it can be done, I just don't know how to do it, yet. But I'll work it out before I release my program.