How would you do this?

[JHaughey]

Is there any way to send data to a SQL sproc from FM GO?

 

Calling the sproc directly seems to be out since you can't use EXEC SQL from the mobile client. So, I thought we would insert data in to a sql table and feed it to the sproc with a trigger. Then we discovered this nasty problem:  

 

http://help.filemaker.com/app/answers/detail/a_id/7870/kw/ESS%20best

 

ISSUE
Using ESS with SQL Server you have a view setup in SQL Server that includes a trigger to the view so that if someone does an insert into the table, it will add the proper records in the proper places. 

When trying to create a new record from FileMaker, you receive the following error:

The target table '<example>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.

NOTE: Changing or deleting data works fine.  Using a trigger with UPDATE works fine.

FileMaker, Inc. is aware of this issue with the FileMaker products listed.

 

 

 So, I am out of ideas and turning to these esteemed forums.  Any thoughts are appreciated.

Thanks,

John