Exporting and Printing
The export and print features apply to both the content of the SQL pane and the content of the Result tab-view. In particular, using copy/paste operations the user may copy the content of the SQL pane to the clipboard, and then paste this content into another text editor application. The user may also print the content of the SQL pane to get a hardcopy of the query text derived in the ELS-QB. In addition to the export and print operations there are Find and Replace operations that may be applied on the content of the SQL pane.
In the case of the Result tab-view, the copy/paste operation is more useful, since any segment of the result grid may be copy/paste into other MS-Office applications (e.g. Excel, Word, etc.). The user may also print the result of a query via the Print menu item. In addition, the user may use the Find operation to search for a particular text in the result grid.
ELS-QB ActiveX Version 1.70 now has special API functions to export query results directly into Delimited or Fixed Text, CSV (for Excel), dBASE III and XML file formats. To study these API functions please download the Word document form of this user's guide.