| The Database Manager supports a DDE command "Database/Select" which can be used to switch to another table, or to perform a new selection together with setting the order. If you specify such a command, the Scheduler will send this DDE command to the Database Manager whenever it opens a timetable. The string which is transferred must be a section string, possible sections are [DSN], [TABLE], [ALIAS], [WHERE], [ANDWHERE], [ORDER], [BUTTON],[STANDARD]. The combination DSN/TABLE can be used to switch to another table. This is also possible with the section ALIAS but the first combination is preferred. Next you can perform a specific SQL select statement by specifying a WHERE clause. ANDWHERE works like the previous but it does not replace the current selection. Instead it adds both where-strings (Do not forget brackets around your string or the result will not be what you expected). An alternative is pressing a BUTTON, if it exists. If it does not exist, nothing will happen. And with the ORDER section you have the possibility to specify an SQL order-by clause. A typical use of this feature is to select only the database entries which are ready to send (or perfect). The corresponding section string would be: "[WHERE]FLAGS LIKE '%R%' OR FLAGS LIKE '%P%'". Hint: the flags are stored in a string in which the letter 'R' means the entry is ready to send and the letter 'P' means it is perfect. In the STANDARD section you do not specify any information. Standard is the start selection of a table and if no start selection is defined it means: select all. |