Procedure Builder
This add-in creates the shell of a procedure. This includes a header and error handler
You specify the 'Scope', 'Type', and in the case of a function, 'Return Type' and 'Name' for the procedure. Optionally a 'Description' for the procedure can be provided.
Up to three parameters can be specified. A name and type for each parameter are required. Use the CheckBox to specify if a parameter is optional.
Finally the 'Error Handler' can be specified, there are four (five if you count 'None') standard error handlers, listed below: -
- Show - Use the Supplied Error Form
- Raise - Err.Raise
- Next - On Error Resume Next
- Blank - No code in the handler
In addition to the standard error handlers you can use Custom Error Handlers to create a custom error handler of your own. These will be listed after the four standard handlers. To create the procedure click 'OK' or 'Apply'.
Auto Coder
The purpose of Auto Coder is to ensure that every procedure within a particular module has a header and/or an error handler.
Select want you to apply to the selected module, when you click 'Create', TurboVB will then scan through all the procedures and insert the required header or error handler to your requirements. The username is defaulted to the currently logged in user but it can be changed. The error handler can be a standard one or a custom handler, created in Custom Error Handlers.
TurboVB has General Options, where many options are set for the add-in suite. With Auto Coder Options you can specify the default Error used and whether Procedure Headers and/or Error Handlers are selected by default. You can also select whether the login name is used by default.
Clear Immediate Window
If the Immediate Window is open the window is wiped of its contents. TurboVB has General Options, where many options are set for the add-in suite. Clear Immediate Window is identical in TurboVBLite to the version in TurboVB.
Proc. Recoder
Proc. Recoder, (Procedure Recoder), provides a vast array of functionality. Procedure Header will add an header to the current procedure if one isn't present or update an existing one. This is very useful if you change the procedures name or amend one of its parameters. If a parameter has comments they will be preserved. Property procedures are also supported by Procedure Header, the appropriate style header being produced.
DB Data Scripter
Sometimes its very useful in development to return a database back to an initial state, one way of doing this is to simply develop a SQL file to clear down the necessary tables and insert the required data. DB Data Scripter automates this process by producing the .SQL file straight from the current contents of a particular database.
Select the DSN you want from the 'DSNs' DownDrop. The tables within the database are listed in the left hand ListView. Move the tables you want to script to the right hand ListView, using the four CommandButtons in the middle.
The 'Username' and 'Password' are required to access the database. A location for the .SQL file must be given and select either 'Clear Down All Tables' in the database or just the tables in the script list, 'Clear Down Script Tables'.
Note: Only MS SQL Server databases are currently supported.
