Delete All Records [No Dialog]

[fmsavey]

I have a solution running on server 11. One person executes a script that finds records and then does a Delete All Records [No Dialog] while someone else is editing one of the found records.

Will Filemaker delete everything except the record being edited (locked) or will it skip the delete step entirely leaving all records undeleted?

Also, if two tables are conected via a cross join (X) and there is one record in table A and one hundred records in table B and you are modifying the one record in table A are all the records in table B locked?

Thanks in advance for your help.

[Jake_R]

Filemaker will delete everything except for the record being edited.

Answer to your second question, only record in table A will be locked.

[fmsavey]

Thank you. One more question if you don't mind. Simply selecting a record (making it current) does not lock it. You have to click in a field to lock it, yes?

[comment]

No, you have to start modifying it.

[fmsavey]

If you have a portal on a layout and you click into a field on the portal will that loc

k the record?

[bcooney]

I think that you'll love this tutorial on record commit from Todd Geist:

Understanding Commit Record