Hi All,

I want to perform a find in a table on a key field and if no records are found then create a new record but I can't find an error code to capture for "No records match this find criteria", can anyone tell me what it is please.

I can't find an error code to capture for "No records match this find criteria", can anyone tell me what it is please.

Read up on the Set Error Capture script step.

Hi All,

I want to perform a find in a table on a key field and if no records are found then create a new record but I can't find an error code to capture for "No records match this find criteria", can anyone tell me what it is please.

Pseudo Script

Perform Find

If Get(FoundCount)<1

show all records

New RecordRequest

End If

If you are trying to create a new record with a specific key field, store it prior to the find and then set field after creating a new record.

HTH

Dave

Read up on the Set Error Capture script step.

Hi Vaughan,

Yes, I realised that I had to capture the error but in the Filemaker error codes I could not find the code for this specific error the nearest one I could see was code 8, Empty result.

Hint:

Set Error Capture [On]

Enter Find Mode []

Set Field [Table::Field; "non existing value"]

Perform Find []

Show Custom Dialog [Get (LastError)]

Hint:

Set Error Capture [On]

Enter Find Mode []

Set Field [Table::Field; "non existing value"]

Perform Find []

Show Custom Dialog [Get (LastError)]

Sorry, I couldn't see for looking, I had looked at the list 5 times, 401 it is. Thank you