Table Scripting

This sample shows you how to check if the field has been changed from one value to another

function UpdateRecord() { if (Values("case_AssignedUserId")+""=="undefined")

 return;  //bad update from crm..or field not changed

var CaseRec=CRM.CreateQueryObj("SELECT * FROM Cases WITH (NOLOCK) WHERE " + WhereClause);

CaseRec.SelectSQL();

if (CaseRec("case_assigneduserid")!=Values("Case_AssignedUserId")) {

 ErrorStr="field value has changed from "+CaseRec("case_assigneduserid") +" to "+Values("Case_AssignedUserId");

} }

---