In this article I would like to discuss a number of distinct concepts and then bring them together.
Search Select Advanced Fields
Security and Data Access
Dynamically Changing Field Properties using an Internal (Create) Script
Imagine a business…
I have discussed calling Stored Procedures from within Sage CRM before in the the article " Using the COM CRM.CreateQueryObj() to call a Stored Procedure ". From that article it can be seen that it is possible to call stored procedures where ever a QueryObject…
Below is some code that illustrates how a Stored Procedure maybe invoked in the QueryObject.
var strSQL = "DECLARE @@ret int"; strSQL += " EXEC @@ret=eware_get_identity_id 'notes'"; strSQL += " INSERT notes"; strSQL += " (note_noteid,note_foreigntableid…