AnsweredAssumed Answered

How to disable auto create/insert a new record?

Question asked by martinhim on Sep 5, 2017
Latest reply on Sep 7, 2017 by beverly

Hi

 

I would want to disable auto- create a new record.

 

I have two stored procedures. one is used to validate the all fields, the another one is used to insert the record to tables.

I want that the validation is passed, then the record is inserted.

However, filemaker commit the record automatically. It will be a problem, when i insert the data using SP.

 

EG:

 

EXECUTE SQL(validate_SP)

set variable [$Error, get(lastexternalerrordetail)]

if ($Error)

.............

ELSE

EXECUTE SQL(insert_SP)

end if

 

Hence, how can i disable the auto create record in filemaker.

Thanks

Outcomes