Customize CustomQuery

This routine is called when DataDigger places a query in the WHERE-editor and when you select a table. In that case the query is empty. In all cases this routine is called just prior to placing the text in the query editor. This gives you a chance to alter the query.

Parameters pcDatabase and pcTable give you the currently selected database and table. The pcQuery parameter is the query that is about to be placed in the WHERE box. Normally, this will be empty, but when you scroll through previously used queries, you will see it here first. It gives you a chance to manipulate the query before it is placed in the WHERE box.

Possible usage: if you want to automatically show the last used query on this table, you could place this inside:

The function "getQuery" is part of DataDigger itself. You can find a list of all functions in DataDigger.i. Please note that behaviour of these functions /might/ change in future versions.