Run trigger from SQL Server.

JTPro

Hello all,

First at all, let me wish you happy NEW YEAR. \:D/
I would like to know if it is possible to run from SQL Server trigger onValidate on the field of table? What I want is to put some date into field of table, and run onValidate trigger for it.
Im looking forward for answers from You.

Best regards
jtpro

Shenpen

I think it's impossible, although you could use NAS to check data in a table frequently and run OnValidate or anything else if needed. The safest choice is to create a new table in Navision, insert data there from SQL, and use NAS to check and copy data into the "real" tables.

kine

Shenpen is right. There is no way how to run C/AL code from external app. C/AL code can be runned only in Navision client or NAS.

ara3n

Navision 5.0 suppose to allow bussiness logic to run from outside.