Browse By Tags
Home
»
All Tags
»
SQL
»
eWareQuery Object
»
COM
.NET API
ASP
Company
custom captions
custom_tables
Data Model
External Database
joins
Meta Data
newproduct
Oracle
OrderItems
orders
Person
Query
QuoteItems
quotes
Record Object
uom
uomfamily
Views
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 Joins in Web Services
Jeff Richards
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.*,...
on
9 Jun 2009
Blog Post:
Linking to 3rd Party Databases
Jeff Richards
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...
on
31 Mar 2009