04-22-2021, 03:39 PM
Hi all,
I'm probably missing something basic here, so grateful for any help.
I've recently modified a table with the addition of 3 new keys and would like to set a default value for all records for these 3 keys.
I know i can read the entire table into an array, loop through this in liveCode, make the changes and then do an update back to liveCloud.
However this is cumbersome; i had envisaged that i may be able to use batchMerge, or batchUpdate to do this and simply pass "*" as the cdbRecordID, but this does not work - cdb_result shows me the error is The specified cdbRecordID is invalid: *
Is there a way to do this directly? If not will just process in LiveCode and update all records, but am hoping i've missed something more straightforward...
Many thanks
Stam
I'm probably missing something basic here, so grateful for any help.
I've recently modified a table with the addition of 3 new keys and would like to set a default value for all records for these 3 keys.
I know i can read the entire table into an array, loop through this in liveCode, make the changes and then do an update back to liveCloud.
However this is cumbersome; i had envisaged that i may be able to use batchMerge, or batchUpdate to do this and simply pass "*" as the cdbRecordID, but this does not work - cdb_result shows me the error is The specified cdbRecordID is invalid: *
Is there a way to do this directly? If not will just process in LiveCode and update all records, but am hoping i've missed something more straightforward...
Many thanks
Stam