SQL Wizard | Access Add-in
• If you click a query name in the Query List box, its SQL shows up in the bottom box. Notice that the SQL statement is followed by its query name for your easy reference. If you click another query, its SQL shows up after the first one with some space between them. You can choose to show as many statements as you want.
• You can run any existing query listed in the top box.
• You can also type any SQL statement into the bottom box for quick execution.
• If you save a SQL statement, its query name shows up in the top box sorted immediately.
• You can increase the font size of query names/SQL statements by double-clicking on an appropriate text box or decrease the font size by typing a size in either of the two text boxes.
_______________
You can comment out as many sections of your SQL statements as you want as in this example where the query name plus the other three parts were commented out. If you click the Run SQL button, you end up with the query output as shown above. This debugging tool will serve you well if you have to identify an invalid section of your SQL quickly.
_______________
[click on image to enlarge]
Sometimes you may need to look at each and every SQL definition of your queries in one place.
If you click the View All SQLs button, a table will open up listing the names of all your queries along with their SQL statements and query type. You can filter/query the table for type of query you want.
_______________
If you select a table or query from the top box (second tab), its field names show up in the bottom box. You can select as many fields as you need for your new query. As you can see below, the table or query name and its fields selected will be typed up in the bottom box on the first tab.
_______________
Click the Create SQL button after taking the above step. You will get what you see in the bottom box (first tab). If you choose not to select any table/query or its fields, you will see only the six key words for a select query.
We offer an unconditional 30-day Money Back Gurantee and free e-mail support! Your order is secured via RegNow SSL Secure Server (see RegNow Security/Privacy statement). You will be able to download the product immediately after ordering!
|
