LiveCode Forums.

Code: Select all

 
 --table1 selection  
 put "SELECT id,name FROm table1" into tSQL
 put revQueryDatabase(gConnectionID, tSQL) into theCursor
   if theCursor is an integer then
      ConvertSQLCursorToArray theCursor, listArray
      put the result into theError
      if theError is empty then
         set the dgData of group "TestGrid" to listArray
      else
         answer theError
      end if
      revCloseCursor theCursor
   end if


   --table2 selection
   put "SELECT id,name FROM table2 " into tSQL
   put revQueryDatabase(gConnectionID, tSQL) into theCursor
   if theCursor is an integer then
      ConvertSQLCursorToArray theCursor, listArray
      put the result into theError
      if theError is empty then
         set the dgData of group "TestGrid" to listArray
      else
         answer theError
      end if
      revCloseCursor theCursor
   end if

Code: Select all

---
put query 1 into tArray1
...
put query 2 into tArray2
...
## Now do something like this (out of my head) to combine these two array to one array
...put the keys of tArray1 into tKeys
put the num of lines of tKeys into tNum

## We use repeat for each, so we need to manage our own counter
## We add all elements of tArray2 to tArray1
put tNum into tCounter
repeat for each line tKey in tKeys
  add 1 to tCounter
  put tArray2[tKey] into tArray1[tCounter]
end repeat
set the dgdata of grp "TestGrid" to tArray1
...