LiveCloud arrays and Datagrid

[sid]

I tried to run a a simple query as well and post it to the datagrid, but it doesnt seem to work either

Code:

on mouseUp
 
  put empty into field "searchAllField"
  put empty into field "foundLogsLabel"
  put "Search all fields by typing here" into field "searchAllFieldsLabel"
 
  local tKeys, tOutputA, tCount, tDataA, tOperator, tValue, tTable, tTarget, tResultFormat, tkey
  set the dgData of group "DataGridLogs" to empty
 
  put cdb_tableKeys("logs") into tKeys
  put "time" into tKey
  put "=" into tOperator
  put text of field "timeSearch" into tValue
  put "logs" into tTable
  put "cloud" into tTarget
  put "recordData" into tResultFormat
 
  put cdb_Query(tKey,tOperator,tValue,tTable,tTarget,tResultFormat) into tOutputA
 
  put 0 into tCount
  repeat for each key xRecordID in tOutputA
     add 1 to tCount
     
     put tOutputA[xRecordID]["cdb"]["cdbRecordID"] into tDataA[tCount]["recordID"]
     repeat for each item xKeyName in tKeys
        put tOutputA[xRecordID][xKeyName] into tDataA[tCount][xKeyName]
     end repeat
  end repeat
 
  set the dgData of group "DataGridLogs" to tDataA
  set the dghProp["saved data"] of group "DataGridLogs" to tDataA
 
end mouseUp

if I alter this line :

put "recordData" into tResultFormat

to

put "recordList" tResultFormat

it errors..also i tried putting 'into' : put "recordList" into tResultFormat  (the query documentation leaves out the 'into'

still nothing happens (I suspect its the recordList format we need)

It would be awesome if you guys can provide guidance into using the query snippets within LCM to post data into the datagrid ( Its ok to post all the columns because we just 'hide' the ones we do not want users to see. 

I also attach a screenshot , everytime I run this query the Cdb engine thinks iI'm offline and not connected to the internet...this may be because I live in a rural town in South Africa, but i doubt it

will really appreciate help on this

Thanks guys