Browse By Tags
Home
»
All Tags
»
COM
»
eWareQuery Object
»
ASP
.NET API
create script
custom_tables
Data Model
External Script
Import
Query
Record Object
SQL
Stored Procedure
Web Services
Blog Post:
Discovering Data Relationships in Code
Jeff Richards
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...
on
13 Sep 2010
Blog Post:
Using the COM CRM.CreateQueryObj() to call a Stored Procedure.
Jeff Richards
Below is some code that illustrates how a Stored Procedure maybe invoked in the QueryObject. var strSQL = "DECLARE @@ret int"; strSQL += " EXEC @@ret=eware_get_identity_id 'notes'"; strSQL += " INSERT notes"; strSQL += " (note_noteid,note_foreigntableid,note_foreignid...
on
9 Feb 2009
Blog Post:
Some thoughts on Importing Data
Jeff Richards
I have written several articles in the past about the importation of data into Sage CRM. This article then is a 'header' record that attempts to bring these different thoughts together. It is certainly not unusual for a partner to occasionally need to design a custom import mechanism into...
on
31 Dec 2008