Sage CRM

Hi all, I have a problem running a query to update a Company record from inside of the Comm_Link (secondary) entity. The query starts in Comm_Link > grabs Communication details > grabs Company details > updates a new custom field in the Customer entity…

I am experiencing an error when running an update to sql from an ASP page. The page has worked in the past and I am not sure what is causing it to fail now. I can see the error in the log. However, I do not know what is causing it. Aug 28 2020 3:12…

Help please! I have an sql statement that returns data if I run it directly in SQL Management Studio. However, I don't think I am getting any results when I run it in Sage CRM using CRM.CreateQueryObj(). What options do I have available to see what…

Hoping someone can assist me with an issue I am having with a custom query. I was trying to create something similar to an ADO recordset. Therefore, I was trying to use the CreateQueryObj method. I wanted the record set to be in the context of the company…

In the COM API you can specify the target database you want to run a query against using CreateQueryObj. For example CRM.CreateQueryObj ("select * from mytable","MYDB"). This uses the Advanced Customization->Tables and Databases->Database connection.…