Create new record if find is not met

[Oyseka]

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.

[Vaughan]

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.

[David McQueen]

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

[Oyseka]

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.

[comment]

Hint:

Set Error Capture [On]

Enter Find Mode []

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

Perform Find []

Show Custom Dialog [Get (LastError)]

[Oyseka]

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