Update a record with SQL Query

SuperSage77

Hello!

I want update a Record with a SQL Query but when I launch it, the record is good created , but no functions proved like Relationtable or no CAL/Code into the record are launched, like triggers OnInsert or OnValidate ?
Can I launch the CAL/Code on the trigger OnValidate for example, with the SQL Query ?




USE NDS_09062011
INSERT INTO "NDS Technologies France$Table_tampon"("DateTime Key","Table ID","Company Name","Update maked",FilterKeyValue,Champ1ID,Champ1Value)
VALUES(CURRENT_TIMESTAMP
,CONVERT(int,'38'),'NDS Technologies France',CONVERT(tinyint,' '),'Devis,DA016398 ',CONVERT(int,'120'),'1')

Thanks for answer
Rudy

ara3n

no you cannot. you need to integrate using webservice or use nas.

kine

NAV is interpret and the C/AL code is interpreted by NAV client/Service tier. It is not possible to call the code from outside without using these components. It is not coded as SQL trigger or anything around...

SuperSage77

OK
Thanks!