Synametrics Technologies

Parameterized dynamic executable

Creating executables from a query result is a power tool in WinSQL. Version 8.5 takes this to the next step by allowing parameterized queries to be embedded.

Consider a scenario where a business manager in your company needs to run a set of queries once in a while. Rather than installing WinSQL on their machine, you can run the queries on your machine, create an executable file from the result set and have the business manager run this executable to get the required data.

The following images display this feature with some screen shots.



Once an executable file has been created, anyone can double click it to run it. A parameter value dialog box is displayed prompting the user for it values.



Finally, fresh data is displayed in the window representing the resultset of the two queries we used in this example.