fmsavey Posted November 8, 2011 Posted November 8, 2011 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 Posted November 8, 2011 Posted November 8, 2011 Filemaker will delete everything except for the record being edited. Answer to your second question, only record in table A will be locked.
fmsavey Posted November 8, 2011 Author Posted November 8, 2011 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?
fmsavey Posted November 9, 2011 Author Posted November 9, 2011 If you have a portal on a layout and you click into a field on the portal will that loc k the record?
bcooney Posted November 9, 2011 Posted November 9, 2011 I think that you'll love this tutorial on record commit from Todd Geist: Understanding Commit Record
Recommended Posts
This topic is 4779 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now