speed & reliability

[efrain.c]

Hi sltfn,

Here is one way to use cdb_batchUpdate in your code:


global myVar
set itemDelimiter to tab

put "thisCustID" & tab & "thisFullName" & tab & "thisLastName" & tab & "thisBalance" & tab & "thisCode" & tab & "thisStatus" & tab & "thisRecordID" into theLineItems

put cdb_tableID("CUSTOMERS") into tTableID
put "cloud" into tTarget
set itemDelimiter to tab

repeat for each line DBrecordLine of myVar

repeat with itemCount = 1 to (the number of items of theLineItems)
do "put item" && itemCount && "of DBrecordLine into" && (item itemCount of theLineItems)
end repeat

put thisRecordID into tRecordID
put thisCustID into tDataA[tTableID][tRecordID]["CUSTOMER_ID"]
put thisFullName into tDataA[tTableID][tRecordID]["FULL_NAME"]
put thisLastName into tDataA[tTableID][tRecordID]["LAST_NAME"]
put thisBalance into tDataA[tTableID][tRecordID]["BALANCE"]
put thisCode into tDataA[tTableID][tRecordID]["CODE"]
put thisStatus into tDataA[tTableID][tRecordID]["STATUS"]

end repeat -- looping through each line of myVar

cdb_batchUpdate tDataA, tTarget


There are a couple changes to note. cdb_batchUpdate uses tableID instead of table name. tDataA is structured differently to allow updates across multiple records across multiple tables. cdb_batchUpdate is placed after the repeat, the repeat structures the data and cdb_batchUpdate sends all the updates as a single request.

Hope this helps. Let us know if you have any questions.