Master Update Form for multiple records

[mindtpi99]

Hi

Does anyone know if this can be done;

I have an -edit page that contains a list of bookings related to a master job record. The records are contained within [FMP-Record][/FMP-Record] tags. Each record is updatable so I've stuck an update form for each row.

Is there anyway you can have it as above but use a single form to update all the records in one go?

Thanks!!

[Leb i Sol]

hello mindtpi99!

may I ask why would yo uwant to do that...I mean it leaves a lot of room for a massive erros if ALL the records are getting updated at the same time.....but your solution might be in some JavaScript (select all-->)and checkboxes that =CurrentRecID.....[theory:no practice from my side]

good luck

[cjaeger]

that's like calling a "replace" script step from web. How do you prevent other users from accessing those records at the same time? You will have to lock them first.

[Leb i Sol]

for mindtpi99:

"script step from web"

most developers seem to hold the opinion that this is unsafe practice....

also read the CJaeger's post....some funny grounds ur starting to walk on....

all the best

[Unable]

Unless you are as sharp as Keith, you should avoid using ScriptMaker's scripts.

JavaScript's scripts have been shown on the Internet Forums to be the way to go. You will run a JS loop on the client's machine. Search on the Internet Forums and you will find the answers to your question.

Good luck.

RE: "...most developers seem to hold the opinion that this is unsafe practice..."

Yes, the issues, have been stated on these forums many many many times (it's good to read old threads and the problems others face). The first issue is that ScriptMaker is single-threaded and does not queue subsequent requests if an event is processing. Thus, if near-simultaneous requests are made on ScriptMaker, only the one being processed will succeed. Secondly, CDML has no way, in and of itself, to recognize an event failure, which means that the client whose ScriptMaker event fails to run is given the success page. Apparently, Keith figured out a way to do this successfully, but he has disappeared from here. Though he posted today on the Using FileMaker forum. Perhaps he will return.

[Anatoli]

RE: Keith figured out a way to do this successfully

The trick is to set some flag field via script to check via script if script was running successfully.

RE: Is there anyway you can have it as above but use a single form to update all the records in one go?

Just for this feature I would update to Lasso in next 5 minutes. But regardless of how you are doing this (Lasso or JS) in FM it is slow. Not extremely slow, but somehow FM doesn't like that sequence update. Fortunately Lasso is nicely multithreaded and another users have chance to work with another things.

[mindtpi99]

It was requested to me due to performance issues updating multiple records, however, I said it was a bad idea and your comments have confirmed this!!

Thanks for the responses!!