Valentina for Revolution 3.5.2

Valentina 3 Office Server is the fastest cross-platform database server available - Valentina turns hours into minutes, minutes into seconds - its blazingly fast. Use Valentina SQL, XML import/export, Unicode UTF-16 for best use of solutions with Japanese and other international text. New features in Valentina 3 include:

• VIEWS. Views are a form of virtual table based on the results of a query. You can now use CREATE/ALTER/DROP VIEW SQL commands to manage views in Valentina database schema.
• TRIGGERS. Triggers are executed based on events that occur within a database table.
  Valentina 3.0 implements BEFORE|AFTER triggers for Table events as Insert/Update/DELETE.
  Triggers can be of FOR EACH ROW kind; in this case, both OLD and NEW aliases are supported.
  Triggers also can be of FOR EACH STATEMENT kind that execute a SQL command or procedure.
  INSTEAD OF Triggers on Views.
• STORED PROCEDURES. Stored Procedures are code that can be stored within the database itself. Stored Procedures can be executed both on local and remote databases. They are stored in the Database Schema (.vdb file). See details in the Valentina Server section below.
• BACKUP. The Valentina 3.0 database engine supports a new SQL command: BACKUP DATABASE. You can use BACKUP even in local version to produce a backup copy of a database with a timestamp, that is in turn saved onto a drive.
• DOUBLE/FLOAT Improvements. DOUBLE/FLOAT columns now have (precision, scale) parameters. Only scale is taken into account by GetString().
• Other SQL Functions. Valentina 3.0 adds new SQL functions, including: PRINT EXPR, VERSION()
• VCONNECTION CLASS Improvements. The VConnection Class can now be used locally. It works as singleton, and provides 3 methods to execute SQL commands: SqlQuery(), SqlExecute(), SqlSelect(). These methods are global and are executed for the ACTIVE database.

Use ODBC to populate your database applications with Valentina. Valentina Office Server is fully scriptable with PHP and Ruby on Rails!

The fastest database solution for Runtime Revolution!