Query Datawindow Report

The Query Datawindow report is run from the Reports dropdown toolbar or the menu under Actions\Run Reports. This report searches datawindow objects using a quasi-SQL like comparison of column properties.

The upper left part of the window has a list of properties to be included in the query. Use the Add and Delete buttons along with the property dropdown to build a list of properties. Properties have to be included here in order to be available in the query builder.

The bottom part of the window has the query builder. It is somewhat like the SQL painter in PowerBuilder. The PB Help button will bring up the PowerBuilder help file on the topic about datawindow column properties.

You can use the Open Query File and Save Query File buttons to reload and save queries from/into text files. A sample query file, dwquery.txt is included. It searches for datetime columns which are open for editing. Editmask is displayed so you can verify all have a proper editmask.

Actions: