Batch_update a specific key in a number of records

[mark_talluto]

Hi Sid. You did a fine job with the query.

Here is some sample code that may help.

Code:

on mouseUp
    local tInputA, tOutputA, tUpdatedLastName, tTableID
   
    put "Franklin" into tUpdatedLastName
    put cdb_tableID("Agents") into tTableID
   
    --QUERY FOR MATCHING DATA
    put cdb_query("lastName","=","Talluto","Agents","cloud","recordList") into tOutputA
   
    --REPEAT THROUGH EACH RECORD AND UPDATE THE 'lastName' VALUE FOR EACH RECORD FROM THE QUERY
    repeat for each line xRecordID in tOutputA
         put tUpdatedLastName into tInputA[tTableID][xRecordID]["lastName"]
    end repeat
   
    --UPDATE DATA IN THE CLOUD
    cdb_batchUpdate tInputA, "cloud"
end mouseUp