How to set a value for all records?

[stamatis]

Hi Stam,

You are correct, batchMerge and batchUpdate do no accept "*" for cdbRecordID. You can use cdb_list(yourTableName, "cloud") to get a line delimited list of all the recordIDs in a table. Then repeat for each line to populate the array for a batchMerge.

Let me know if you need any help or run into any issues.

- Efrain

Thanks Efrain,
I wasn't aware of cdb_list, will use that...

Best regards
Stam

PS: It would be good to have a function that replaces all values -- similar to 'replace field contents' command in FileMaker Pro, where you can replace the field in all records of a table with a static value, an auto-incrementing serial number or a formula/function (and it's mighty fast)... Any mileage in submitting that as a feature request for this?