Browse By Tags

  • The Journal Table

    I was tempted to start a new series of articles called " Mysterious Tables of Sage CRM " but since this is supposed to be a sensible library of "Hints, Tips and Tricks" I have resisted. Nevertheless, there are a few tables in the Sage CRM database that…
  • The Design of Web Service Applications and Performance

    My hope is that if you have attended any of my presentations about the Web Services interface for Sage CRM you will have taken away with you an impression of the importance of the design of the client application and how this would affect performance…
  • Tips for Building Views: A round up of articles on views.

    The following is a survey of all the different articles that have discussed creating and editing views within Sage CRM. Understanding SQL views is essential as they under pin just about every feature within Sage CRM and completely determine what can or…
  • Web Services, Where Clauses and Subqueries

    This article follows on from a previous article " Using Joins in Web Services ". That article discussed how views that are linked into CRM and described as 'tables' in metadata can be used to provide access to data from multiple tables within a single…
  • 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…
  • Call WS

    Hi! I'm trying to call an web service using Visual Basic in a spreadsheet but it returns me an error: xsi:type="xsd:int">0</traceRequestSize></technicalInfos></runReturn></wss:runResponse><multiRef id="id0" soapenc:root="0" soapenv:encodingStyle=…
  • Consuming external webservice SOAP

    Hello guys, Someone can tell me please if it's possible to invoke an external webservice (soap) using 4GL ? I don't find any information here about this subject. Thanks