ApexSQL Code quickly generates thousands of lines of error-free code for Microsoft SQL Server 7 or 2000 using Rapid Application Development techniques. Compatible with ASP, VB, C#, SQL, and more.
The most significant feature of ApexSQL Code is its ability to automate custom code patterns through Template-based code generation. Users can configure templates easily with the scripting language of their choice such as VBScript or JScript.
The software comes with several features that enhance the template creation process, including the Template Wizard, which allows users to create templates by following seven simple steps. Additionally, the powerful template property page provides the user with the convenience of editing templates in place with simple picklists and dialogs. The templates are XML-based, allowing for attributes to be embedded directly in the template structure.
ApexSQL Code also comes with built-in session and application variables, enabling users to control file operations and dialogs programmatically from the template. Files can be output or appended, or all file operations can be suppressed if the user chooses to use the File System Object. Furthermore, ApexSQL Code automatically remembers table, view, sproc, field, parameter and result column selections between sessions and for a specific database, which can be saved, cleared, and retrieved.
Users have the choice of either VBScript or JScript for template scripting. The software handles looping, including For Each loops, constructs, error handling, etc. This flexibility allows users to create virtually unlimited code patterns.
ApexSQL Code boasts an extensive template library including C#, VB.NET, AsP, VB, SQL, and Delphi templates. The software also supports unlimited Include files just like ASP! A real Intellisense is built-in to easily navigate the ApexSQL Code object model, and a default color-coded text editor to manage templates is already provided, currently supporting ASP / VBScript, VB, Java / JScript, CSharp, and SQL.
Finally, multiple tables, views, and stored procedures can be scripted simultaneously, even within the same template. Overall, ApexSQL Code is an impressive software solution for RAD Code Generation, making the code generation process much faster and easier.
Version 2.39.158: N/A