Database tricks

  • It is possible to change the connect string because of a value found during the call to BaseSQL or PreQueueSQL
BaseSQL=Select TOP 1 KeyValue, DatabaseName as Level1 when TriggerValue=0
Assuming the DatabaseName that returned was 'DocDataStore', you should create an entry like :
DocDataStore.Connectstring=Provider=SQLOLEDB;Server=SqlServr01;Database=DocDataStore;UID=meme;PWD=secret
Assuming the DatabaseName that returned was 'DocMetaStore', you should create an entry like :
DocMetaStore.Connectstring=Provider=SQLOLEDB;Server=SqlServr02;Database=DocMetaStore;UID=meme;PWD=secret
  • Because the database version has more trigger points it is rather simple to create a log in the database
The Example Config File DB already contains something like that.
  • Use PreQueueSQL to get information from the database that is though on the database server. you can also use Stored Procedures if they are supported by the database server.

The commandline options in Examples are the same, with the main difference that any field returned by the SQL statement(s) can be used as a variable.

Gesponsorde koppelingen