How can I execute Sql Trigger in Fm

[camelCasing]

Hi everybody,

I want to copy my records to MS Sql( LKS GO - it is an ... program) from filemaker.

There is a relation between filemaker and Ms Sql with ODBC.

As a usually, i create and update records in sql table. I create records but i couldn't save some special table for Ms Sql(LKS Go program). There is an exception as like in attachment.

Attach1 =

As you see , These tables have some triggers.(insert - update - delete ). I think i must run an insert Trigger. When i run sql query(insert trigger), there is also an exception.

Attach2 =

[camelCasing]

is there noone to answer this question?

[bcooney]

Your setup isn't clear. Have you defined the external data source and sync'd the tables? Have you read any of the documentation or help?

[Jonathan Monroe]

I believe it is not possible to insert into a MS SQL Server table that has a trigger defined. This is an artifact of the mechanism FM uses to replicate FM behavior on a SQL table. I don't know that this limitation is documented anywhere, but I've seen this question posted a few times for both Mac and Windows platforms. The problem does not occur with MySQL or Oracle databases.

I suggest that you file a bug report on the FM bug report forum:

http://forums.filemaker.com/hives/1eea103f05/summary

Provide as much information as you can: version of Windows, version of SQL Server, table definition, etc.

Jonathan Monroe

Actual Technologies - ODBC for Mac OS X

http://www.actualtech.com