c-treeACE SQL stored procedures (SP), user defined functions (UDF), and triggers provide powerful extensions to standard SQL operations allowing centralized business rules and enforcement of those rules.
The popularity of this feature has prompted several big new FairCom developments greatly extending development ease and platform extensibility:
NetBeans Plugin - Cross-platform Java is the current framework used to develop SP, UDF, and triggers for c-treeACE SQL. To ease development, a NetBeans/Eclipse plug-in has been created to provide a complete IDE for Java procedure development. This is immediately available to users of Java stored procedures.
.NET Support - Extending platform flexibility for Windows developers, c-treeACE SQL now supports stored procedures, user-defined functions, and triggers for the .NET framework. New Visual Studio integration provides simplified development of SP, UDF, and triggers in any .NET language that compiles to the CLI. .NET assembly dynamic link libraries are now easily deployed to remote servers from a convenient development platform. Templates for C# and Visual Basic are provided.
Dump and Deploy Utilities - To simplify the process of deploying SP, UDF, and triggers to multiple servers, scriptable command-line utilities can now be used to dump existing SPs, UDFs, or triggers and deploy to remote servers. These are provided to assist application deployments.
