SQL (nowadays normally pronounced seequell) originally stood for Structured Query Language and was designed as an English Like way of asking for information from a database. SQL has been a standard for many years now and someone with some SQL experience under their belt is very welcome in most organisations.
blackdogCRM talks to its database using SQL exclusively. Unlike many systems blackdogCRM does not hide its internal workings from you, why should we ? We have nothing to hide and you have plenty to gain should you wish to view the statements that blackdogCRM is issuing and maybe use them yourself within our Query Tools or within a third party reporting tool. If you have Crystal Reports or Business Objects experience for example then that can be put to good use with blackdogCRM and SQL.
The ability to log all the SQL statements sent to the database is a useful and often overlooked function that can at times be extremely useful. For Auditing or Verification purposes it can be invaluable.
There are two ways of logging SQL. The first involves setting a Preference, see image below:
This method save the SQL to a log file stored in your blackdogCRM.Live folder. This file is called blackdogCRM_SQLLog.r10
When opened in your favourite Text Editor or Spreadsheet program, the contents look something like this:
The second method requires you to select the Toggle SQL Session Log menu option, from the Utilities menu. When the SQL Session Log window opens click the Start button. Subsequent SQL statement executions will be captured by this window.
If either of these two logging methods are activated then additionally the SQL statements are logged to the local computers System Log. Access to the System Log differs according to whether you are running blackdogCRM on Windows or Mac OSX. How to view the entries within the System Log is beyond the scope of this document.