Category Archives: ASP

Executing Stored Procedures using COM API methods

This is developer specific technical tip which can be used in CRM customizations. In customizations we usually execute sql statements using CreateQueryObj function. For Eg. SqlQuery = “Select comp_name from company (nolock) where comp_compname=”+sCompId; SqlObj = eWare.CreateQueryObj(SqlQuery); SqlObj.SelectSQL(); Here to retrieve the value of comp_name we can use SqlObj(“comp_name”). The above example is for the… Read More »