Total Visual Developer Suite
在增强您 Visual Basic 开发环境的同时,将质量、经过测试的代码集成到您的应用程序中。
在增强您 Visual Basic 开发环境的同时,将质量、经过测试的代码集成到您的应用程序中。
Total Visual Developer Suite offers an extensive source code library and tools to assist with writing code. It significantly improves the productivity and consistency of individuals and teams of VB developers. Includes the award-winning Total Visual SourceBook and Total Visual CodeTools . Please see individual product descriptions for more information.
Total Visual SourceBook includes the following features:
Use the Total Visual SourceBook Repository to store, index, and manage all your code in a shared environment. Track author, creation and modification dates, comments, examples and more.
Source Code Exchange (SCE) is our new technology for sharing code when you aren't connected to your network. Take any code from SourceBook and package it into an SCE file--code, comments, and author information are automatically included. Then email your SCE file or put it on your website. Other SourceBook users can import SCE files and handle new and modified code with ease.
Direct Integration with the Integrated Development Environment (IDE) Total Visual SourceBook is completely integrated with the Visual Basic IDE available in Visual Basic 6 and Office 2000/XP. Start it as an add-in and its always ready to get you to the code you need.
Total Visual CodeTools provides a robust set of tools to help you in the day-to-day development of Visual Basic (VB) and Visual Basic for Applications (VBA) code. The main features of Total Visual CodeTools are:
Standardizing the visual appearance of the code is probably the single most important factor for code maintainability. Choosing this option tells Code Cleanup to do the following:
Procedure Sorting
Procedures can be inserted in any order in VB/VBA. This may be good, but it can also create a mess. Code Cleanup makes it easy to sort the procedures in your modules including property statements in class modules.
Module Comments
Add a standard module header to the top of each module such as a project name, creation dates, copyright notices, and ownership rights. A complete list of all procedure names and procedure definitions can also be added.
Procedure Comments
Add comment headers to each procedure. Although the program cannot determine what the code is actually doing and write the comments for you, it can take much of the drudgery out of the process of creating consistent comment headers for each procedure.
Property Comments
Inserts the specified property comment template into all the property procedures.
Error Handling
Error handling is one of the key attributes of robust applications. This feature inserts error handling code into your procedures that lack error handling, and allows you to specify separate error handling routines for regular modules vs. class modules. Error handling can also be added in a way to be automatically updated in the future.
Variable Naming Conventions
Rename your existing variables to conform to naming conventions based on the variable type (Integer, String, etc.). Every variable is given a prefix or suffix identifying its type with additional options for global and module level variables.
Option Explicit
Insert "Option Explicit" into the declarations section of every module that lacks it. One of the cardinal rules of writing reliable and maintainable code is to explicitly declare all of your variables. By adding "Option Explicit" to your module, you are telling Access to require variable declaration.
Remove Line Numbers
Removes the line numbers in your code. This is useful if line numbers were added to your code (say with the Code Delivery feature), and you now want to remove it.
Total Visual CodeTools provides several useful builders for your day-to-day development efforts. These builders allow you to automate and simplify the following processes:
Procedure Builder
This builder allows you to quickly create new procedures that adhere to a set of standards that you define. It allows you to specify comment headers, error handling, indentation, naming conventions, and global procedure identifiers.
Property Builder
You can write property procedures in VBA that allow you to define properties of the objects you define in class modules. The process of creating such procedures can be difficult. You can use the Total Visual CodeTools Property builder to quickly build the property procedures necessary to implement a property in a class module.
Long Text/SQL Builder
Adding long SQL strings into a module and easily viewing it usually requires breaking it into a multi-line statement. The SQL Builder automates this by automatically converting a SQL string to a series of VBA lines that assign the string to a variable. Like SQL text, you may need to assign a long text string to a variable in your code. The Long Text Builder takes a string and automatically generates the multi-line code necessary to assign the text to a variable.
Message Box Builder
Message boxes are a common feature in VBA driven applications. Unfortunately, VBA does not provide tools for visually creating message boxes. Even experienced developers need to refer to the manual or help system to determine the values of icons and button options. The Message Box builder lets you visually create a message box statement or function.
Recordset Builder
Creating recordsets against a table or stored procedure is another of those routine tasks, which could be error prone. The SQL Builder generates code for you depending upon your chosen table object or stored procedure object.
Select Case Builder
Typing Select...Case statements can be a tedious process, especially when there are many conditions. The Select Case Builder allows you to quickly create such statements.
Code Delivery provides the tools for the final preparation of your code before distribution. Easily add line numbers to all of your code so you can take advantage of VB/VBA's ability to pinpoint the exact line where an error occurs. You can also obfuscate your code for situations where you need to distribute your source code, but are concerned about its misuse. Code Delivery provides the following code operations: