RocketTheme Joomla Templates
Valentina 4.3 Notes

Latest ReleaseValentina DB Release 4.3 is available

 

 

Valentina DB 4.3 adds a significant, new feature to Valentina SQL, plus several minor features and many customer requested fixes and improvements.

Valentina 4.x Releases

  • Valentina 4.3 - October 10, 2009
  • Valentina 4.2 - June 24, 2009
  • Valentina 4.1 - April 19, 2009
  • Valentina 4.0 - February 25, 2009

New Features and Improvements

Valentina 4.1 introduced Recursive SQL operations a feature we believe is original and new to Valentina. We know of no other database that does it.

All features in BOLD are new in Valentina 4.3. All other features are or were added in versions beginning with Valentina 4.0.

Valentina 4 Kernel Functions

New Valentina kernel functions introduced with Valentina 4 or later. Find greater detail in the Valentina Wiki.

  • [Imp][SQL] Result of complex query with DISTINCT keyword into subquery
  • [Imp][SQL] -> operator in update statement
  • [Imp][SQL] when one table is empty, join algorithm issue on getting index iterator on RecID field
  • [NEW][SQL] Create constructions: SELECT * FROM( CALL myProc )
  • [SQL] after insert trigger changes ALL records
  • [Imp][SQL] issue about @var in subquery with join
  • [NEW] alias for ANCESTORS
  • [NEW][Functions] FORMAT function
  • [Properties] SET PROPERTY QueryPoolMaxSize OF DATABASE TO 20
  • [Properties] SET PROPERTY EnableQueryPool OF DATABASE TO TRUE/FALSE
  • [Logs] [TUNE LOG] now have Info about whether the query was found in the pool
  • [NEW] UUID() -- function that returns 16 byte unique value
  • [NEW] get_fields_as_string() -- function to concat all fields values to the string
  • [NEW] Last_RecID_Of_Table(tblName) - return the last inserted recID for particular table
  • [NEW] Current_UserID()
  • [NEW] List_ItemCount( inList as string [, inDelimiter as string] )
  • [NEW] List_NthItem( inList as string, inItemIndex as integer [, inDelimiter as string] )

Valentina Kernel SQL

  • [Imp][Properties] System property "TableCount" of database always return value resolved
  • [Imp][Views] view statement always starts with CREATE OR REPLACE VIEW
  • [NEW][Views]CREATE TEMPORARY VIEW
  • [NEW][Views]CREATE VIEW IF NOT EXISTS
  • [Imp][Triggers] Passing a new.value inside an insert trigger on a view
  • [NEW][Other] add the "numeric field type" in the show columns for (table)
  • [Views] Executing create or replace on a view looses all triggers attached to the view
  • [Imp][Stored Procedures] Issue in functionname
  • [NEW][Views] create a 'ALTER VIEW' command
  • [Imp][Stored Procedures] Using Fields from a join result for a stored function has NULL in the fields
  • [Imp][Join of Tables] Where Condition with datetime
  • [Imp][Views] using select viewname.x from viewname produces different field set from select * from viewname
  • [Imp][Views] subqueries do not work in views
  • [Imp][Views] Recid not return in view when select * from view
  • [NEW][Stored Procedures] Default values for stored procedure arguments
  • [Imp][Triggers] instead of delete trigger refuses to work with old.values
  • [Imp][Triggers] instead of update trigger updates the wrong record
  • [Imp][Views] Optional Column spec does not work on views that use union
  • [NEW][Views] Set length of 'text' field in result from 'SHOW TABLES' to 2044
  • [NEW][Import/Export] Triggers can be fired while data dumps are loaded
  • [NEW][Feature Request] Please allow multiple jumps with -> operator
  • [NEW][SQL] Recursive queries need form "[TO|ON] LAST LEVEL"
  • [NEW][SQL] show connection properties for a given OTHER connection
  • [NEW][SQL] Brothers/Ascendants/Descendants recursive-link operations support in SQL
  • [NEW][SQL] SET PROPERTY now works for Stored Procedures
  • [NEW][SQL] SET PROPERTY now works for Triggers
  • [NEW][SQL] INSTEAD OF triggers now work with OLD/NEW values.
  • [NEW][SQL] SELECT ... FOR XML [RAW|AUTO ELEMENT] -- produce XML output from inside of a TEXT Field of a returned cursor
  • [NEW][SQL] SELECT ... FOR REPORT project.report AS {PDF|HTML|JPG} PAGES start TO end
  • [NEW][SQL] Correlated sub-queries implemented.
  • [NEW][SQL] CREATE/DROP USER command
  • [NEW][SQL] GRANT/REVOKE commands
  • [NEW][SQL] SHOW GRANTS
  • [NEW][SQL] DROP CONNECTIONS
  • [NEW][SQL] REGISTER/UNREGISTER DATABASE
  • [NEW][SQL] REGISTER/UNREGISTER PROJECT
  • [NEW][SQL] CREATE/OPEN/CLOSE PROJECT
  • [NEW][SQL] SHOW PROJECT
  • [NEW][SQL] SET var = GET PROPERTY X [OF Y] syntax for Stored Procedures
  • [NEW][SQL] Dynamic cursor declaration
  • [Imp][SQL] LIMIT clause now works for SELECTs inside of Stored Procedures
  • [Impr][SQL] **CREATE EVENT** now have [OR REPLACE] part.
  • [Impr][SQL] **CREATE DATABASE [IF [NOT] EXIST] db_name [WITH SET PROPERTY property_name_list OF DATABASE TO property_value_list]**
  • [Impr][SQL] Ability of using aggregative function in the having clause for pointing out the group by result column:
  • [Impr][SQL] Joins on Recursive tables for FK and ObjectPtr links now take into account order of fields in the join-condition
  • [Impr][SQL] Joins on recursive link specified by name now can choose ToParent or ToChild direction.

Valentina Server

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [Impr][MAC] Compatability with Mac OS X 10.6 Snow Leopard scheduler improved
  • [NEW][SQL] Local temporary tables - a user doing ''CREATE TABLE T'' do not conflict with another user doing the same table.
  • [NEW][SQL] SET PROPERTY OF CONNECTION
  • [NEW] Pool of connections -- if user connects to vserver but not free connections, this connection can wait for MaxConnectionTimeout before refuse.
  • [NEW][INI] MaxConnectionTimeout parameter. Connection timeout parameter.
  • [NEW][INI] MaxTransferTimeout
  • [NEW][INI] SystemProjectCatalog
  • [NEW][MAC] VServer now managed by LaunchD
  • [NEW][MAC] Added few helpful AppleScripts to manage VServer's start/stop/restart, Show In Finder.
  • [NEW][Lin] Creation of pidfile when vserver starts
  • [Impr][Lin] Scripts of vserver to restart

Valentina Studio Pro

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [NEW] [Database] Default Mode is now 4 file based
  • [NEW] [Reports Controls] Copy controls from one report to another
  • [Project Window] Project tab toolbar( like in Report Editor )
  • [NEW] [Reports Preview]Render Engine to preview reports
  • [NEW] [Report Editor] Report Inspector has menu > Render Engines
  • [NEW] [Project Tree] Duplicate added to context menu
  • [NEW] [Forms Editor] Splitter between controls panel and editor area
  • [NEW][Report Editor] Added property to label - can_grow
  • [NEW][Report Editor] Console can show detailed timing of report generation, profiling of reports
  • [NEW][GUI] Window Project
  • [NEW][GUI] Report Editor

Valentina Reports

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [Reports] Add format by condition
  • [Expressions] SUMs and Calculation in group footers
  • [Expressions] SUMs and Calculation in column footers
  • [SubReports] stored procedures calls are cached
  • [NEW][BarCode] Support of barcode OneCode for USA POST system
  • [NEW][Region - Page Body] Added property for all bodies from new page- new_page
  • [NEW][Region - Group Footer] Added property for group footers from new page - new_page
  • [NEW][Region - Column Footer] Added new property to column footer - always_at_bottom
  • [NEW][GUI] Window Project
  • [NEW][GUI] Report Editor

Valentina for Cocoa

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [New][Examples]  Examples/Class_way/Table_Create
  • [New][Class-way] Fixed work of target version. (Ruslan Zasukhin)
  • [New][Enum Constants] To EVDateFormat added 3 values kMYD, kDYM, kYDM
  • [Imp][API] Some properties of VDate, VTime and VDateTime classes was renamed
  • [New][API] NEW methods date Components and setDateComponents in classes VDate, VTime, VDateTime
  • [Imp][Fields] [field value] on double columns causes issue with float register
  • [Imp][Other] b12 - LOG - Long_SetValue.../Double_SetValue
  • [NEW][API] Class VProject
  • [NEW][API] Class VReport
  • [NEW][API] Class VQueryResult
  • [NEW][API] Valentina.GetLocalConnection()
  • [NEW][API] VConnection.SqlExecute()
  • [NEW][API] VConnection.SqlQuery()
  • [NEW][API] VConnection.SqlSelect()
  • [NEW][API] VDatabase.Connection
  • [NEW][API] VDatabase.SqlQuery()

Valentina for COM

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [NEW][API] Class VProject
  • [NEW][API] Class VReport
  • [NEW][API] Class VQueryResult
  • [NEW][API] Valentina.GetLocalConnection()
  • [NEW][API] VConnection.SqlExecute()
  • [NEW][API] VConnection.SqlQuery()
  • [NEW][API] VConnection.SqlSelect()
  • [NEW][API] VDatabase.Connection
  • [NEW][API] VDatabase.SqlQuery()

Valentina for Director

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [Imp][Fields] VField::getString() display accented characters
  • [New][API] All classes return error code for non-existent propery
  • [Imp][Fields] VField property IsIndexedByWords renamed to IndexByWords
  • [Imp][API] VField.DefaultValue() assign the default value for the field
  • [NEW][Pictures] setImage() & setPicture(): Support for TIFF format
  • [NEW][Xtra] VProject
  • [NEW][Xtra] VReport
  • [NEW][API] Valentina.GetLocalConnection()
  • [NEW][API] VConnection.SqlSelect()
  • [NEW][API] VConnection.SqlQuery()
  • [NEW][API] VConnection.SqlExecute()
  • [NEW][API] VDatabase.Connection

Valentina for .NET

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [NEW][API] Class VProject
  • [NEW][API] Class VReport
  • [NEW][API] Class VQueryResult
  • [NEW][API] Valentina.GetLocalConnection()
  • [NEW][API] VConnection.SqlExecute()
  • [NEW][API] VConnection.SqlQuery()
  • [NEW][API] VConnection.SqlSelect()
  • [NEW][API] VDatabase.Connection
  • [NEW][API] VDatabase.SqlQuery()

Valentina ODBC Driver

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [NEW][Mac] Standalone driver for Mac OS X
  • [NEW][Mac] Client-only driver for Mac OS X
  • [NEW][Lin] Standalone driver for Linux
  • [NEW][Lin] Client-only driver for Linux

Valentina for PHP

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [Other] PDO Functions
  • [NEW] [API] valentina_stat()
  • [NEW] [API] valentina_db_name()
  • [NEW] [API] valentina_list_dbs()
  • [NEW] [API] valentina_insert_id_of_table
  • [NEW] [API] valentina_insert_id()
  • [NEW][API] VBinaryValue class -- allows send binary data via SQL Binding.
  • [NEW][API] bool valentina_trace_mode( [bool] )
  • [NEW][API] bool valentina_throw_exceptions( [bool] )
  • [NEW][API] class VProject
  • [NEW][API] class VReport

Valentina for REALbasic

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [NEW][Enum Constants] To EVDateFormat added 3 values kMYD, kDYM, kYDM
  • [Imp][Class-way] VTable class constructor issue
  • [Imp][Examples] Change extension of example files from *.rb to *.rbp
  • [Change] Valentina.GetLocalConnection method now is property Valentina.LocalConnection [r/o]
  • [NEW][API] Class VProject
  • [NEW][API] Class VReport
  • [NEW][API] Class VQueryResult
  • [NEW][API] Valentina.GetLocalConnection()
  • [NEW][API] VConnection.SqlExecute()
  • [NEW][API] VConnection.SqlQuery()
  • [NEW][API] VConnection.SqlSelect()
  • [NEW][API] VDatabase.Connection
  • [NEW][API] VDatabase.SqlQuery()
  • [NEW][API] Constructor VDatabase( inRbDatabase as VRBDatabase ) - bridge from RBDB way to Valentina API way.

Valentina for Revolution

This product also incorporates SQL Kernel and Kernel only feature improvements listed above. Information below is only product specific improvements.

  • [Imp][API] Valentina.GetLocalConnection() and VDatabase.Connection() return connection id
  • [Installation] Name of Valentina for Revolution driver changed to Valentina4
  • [NEW][API] Class VProject
  • [NEW][API] Class VReport
  • [NEW][API] Class VQueryResult
  • [NEW][API] Valentina_GetLocalConnection()
  • [NEW][API] VConnection_SqlSelectRecords()
  • [NEW][API] VConnection_SqlExecute()
  • [NEW][API] VConnection_SqlQuery()
  • [NEW][API] VConnection_SqlSelect()
  • [NEW][API] VDatabase_Connection property
  • [NEW][API] VDatabase_SqlQuery()
  • [NEW][Example] SQL_way/Field_Pictures


Please check ChangeLog in our Mantis bug tracker to see complete list of fixes for different Valentina products.
 
Banner
Banner
Banner
Banner
Banner