Sage CRM

I want to execute a sql command to update the person age field but checking it's value with person's birthdate where i set sql trigger as Pers_Deleted IS NULL and set sql command as update Person set pers_age = DATEDIFF(YYYY,pers_birthdate,GETDATE(…

Hi How can i do this in .net SDK i try but not work

whenever i create an escalation against vcommunication table.... CRM automatically adds comm_communicationid=0 in where clause.... which will make this escalation not to run...does anyone else have this issue