Visit Sage CRM Main Website
About Sage CRM
Browse By Tags
Getting the Database DataType for a field
Occasionally you may be faced with a requirement to know what database datatype a field is before you start to work with it. This type of information is not held in the custom_edits table - only the Sage CRM entrytype is held there. These are all documented in the developers guide. We may also have...
25 Feb 2009
Discovering Data Relationships in Code
You may have a business requirement to cascade a change through the child records of a company. I have discussed previously how a table level script can be used to update all opportunities if the company is reassigned to a new account manager. See the article " A Table Level Script to update Opportunities...
13 Sep 2010
Using Joins in Web Services
Imagine you need to retrieve information from CRM via the webservices interface; this query should combine data from multiple tables. In the COM API (ASP pages, self service, table level scripts etc) you could use the QueryObject to build the exact SQL you need. var mySQL = "SELECT Person.*,...
9 Jun 2009
Linking to 3rd Party Databases
Within the Administration screens is the location that allows the System Administrator to create an additional database connection to a 3rd party database. Administration -> Advanced Customization -> Tables and Databases Sage CRM allows us to connect to a different database on a different...
31 Mar 2009
© The Sage Group plc 2019
All Rights Reserved