user12837

Run SQL Stored Procedure In ESS Table?

Discussion created by user12837 on Dec 8, 2011
Latest reply on Jan 5, 2012 by LSNOVER

in the archives there is a message from lsnover@tplus.com which says

 

I use a utility record for each user to "Trigger" the call to the Stored Procedure. The record just has the name of the Stored Proc to call, along with generic fields to hold parameters that you want to pass to the stored procedure.

The only major caveat is that since a record is being used to Trigger the stored proc, it is part of a transaction, so you can not perform Commits or Roll Backs in the called stored procedure. Also, if you have a parameter to get errors back, it will roll back without any new information, if the transaction rolls back.

 

I don't understand the text highlighted in red. Does it refer to a FileMaker transaction of some sort?

 

Thanks,

 

Tom

Outcomes