eWare and CRM objects in Sage CRM

In Sage CRM, for ASP pages customization, we always use eWare.GetContextInfo() or eWare.AddButton() and etc. Have you ever thought, what is eWare? eWare is an object of ACCPAC CRM class. This object is created and initialized in the two files named as “”crmwizardnolang.js and “accpaccrmNoLang.js”. In order to use eWare object and its related properties… Read More: eWare and CRM objects in Sage CRM »

SQL Trigger to track previous & new values for fields

Description: Think about tracking the old data whenever it is changed to new one??? Suppose you want to track this information in single table and display in the tab against any CRM entities. This can be achieved using sql trigger functionality. Solution: For this first you may need to create two magic tables (i.e. inserted… Read More: SQL Trigger to track previous & new values for fields »

SQL Trigger to track previous & new values for fields

Description: Think about tracking the old data whenever it is changed to new one??? Suppose you want to track this information in single table and display in the tab against any CRM entities. This can be achieved using sql trigger functionality. Solution: For this first you may need to create two magic tables (i.e. inserted… Read More: SQL Trigger to track previous & new values for fields »

How can you detect the enter key being pressed in any text input field?

Want to trap the Enter key press event and have it click a button for you? Consider the search engine in the standard Sage CRM. Generally we all people use standard find screens for searching the cases, company, person and opportunity records respectively. In the standard search screens, suppose user wants to search all those… Read More: How can you detect the enter key being pressed in… »

EOleException error while executing Procedure

You must have seen this irritating error while executing Stored Procedure from Workflow Action. EOleException: Procedure or function TESTSP has too many arguments specified. Solution: The point is that, when Stored Procedure gets executed from the Workflow action, CRM appends default parameters to the Execute Procedure statement. So we have to declare these parameters at… Read More: EOleException error while executing Procedure »