Browse by Tags

• Arabic
• Chinese
• customization
• Data Model
• Download
• eWareQuery Object
• Fields
• Record Object
• Sage CRM 6.2
• Self Service
• SQL
• Stored Procedure
• StoredProc
• Thai
• Unicode
• Workflow

• Investigating how the database has changed between versions of Sage CRM

  When a new version of Sage CRM is released or a new patch is issued there may be changes made to the database tables and views. These changes can be obvious, for example if a new table is added to support... Posted Oct 05 2009, 03:23 by Jeff Richards with | with 2 comment(s) Filed under: SQL, Data Type, Download, Data Model, Sage CRM 6.2, customization

• The Workflow Rule Action - Run Stored Procedure

  The system administration guide discusses the workflow action 'run stored procedure'. This article expands on the information contained in the documentation. A workflow rule action of type 'run... Posted Mar 03 2009, 09:38 by Jeff Richards with | with no comments Filed under: Workflow, Data Type, Stored Procedure

• The Sage CRM StoredProc Data Type

  This article has been edited to include extra information and to bring the code up to date with the coding standard introduced with Sage CRM 6.2 In the default system the StoredProc datatype is used to... Posted Feb 26 2009, 04:00 by Jeff Richards with | with 2 comment(s) Filed under: Self Service, Record Object, Fields, Data Type, StoredProc, Stored Procedure

• Getting the Database DataType for a field

  The code example in this article has been corrected and brought into line with the coding standard introduced in Sage CRM 6.2 Occasionally you may be faced with a requirement to know what database datatype... Posted Feb 25 2009, 09:05 by Jeff Richards with | with no comments Filed under: SQL, eWareQuery Object, Record Object, Data Type

• Why does N’ appear in system generated SQL?

  You may have seen in the SQL logs that Sage CRM passes strings using an N prefix. This denotes that the subsequent string is in Unicode (the N actually stands for National language character set). Which... Posted Dec 29 2007, 10:00 by Jeff Richards with | with 1 comment(s) Filed under: SQL, Unicode, Data Type, Thai, Chinese, Arabic