Valentina 4.5 Notes

RocketTheme Joomla Templates

Valentina 4.5 Notes

Valentina DB Release 4.5 is available

Valentina DB 4.5 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.5 - February 14, 2010
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.5 introduces 64 bit versions of Valentina Office Server and Valentina Embedded Server

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.5. 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

[New][SQL] Add count of user properties to SHOW COLUMNS result
[New][SQL] Add new column to "SHOW COLUMNS" result and method correct( compiled )
[New][SQL] Add count of user properties to SHOW TRIGGERS result
[New][SQL] Add count of user properties to SHOW TABLES result
[[New]SQL] Add encryption info into result of SHOW commands
[New][Docs] Documentation for ALTER PROCEDURE - resolved
[Compression] error selecting data from compressed field resolved
[SQL] order by issues when using joins resolved
[SQL Nodes] Issue if part of "or" clause produces empty recordset resolved
[SQL Nodes] Re-raising error may get wrong error message resolved
[XML Dump] XML Dump load ignores custom properties for everything except a database resolved
[Cursors] Server issue on attempt to update read-only cursor resolved
[SQL Nodes] IN(join-subquery) statement may produce "unique violation" error resolved
[Methods (aka Calculated Fields)] Issue on indexed methods under some circumstances - resolved
[Stored Procedures] Empty stored procedure generated issue with vserver resolved
[Triggers] instead of triggers on view often generate segment errors resolved
[Stored Procedures] Using IN( join-subquery ) inside some loop may cause issues - resolved
[Functions] Segmentation fault caused by calling function - resolved
[Database] Sometimes valentina tmp-files not deleted - resolved
[Triggers] Creation of trigger does NOT show errors in code - resolved
[Import/Export] Importing big file (>2Gb) may lead to grow internal buffer untill bad_allocation exception resolved
[SQL] query makes vserver issue - resolved
[Views] order by gives other results then without - resolved
[Feature Request] [NEW] Join result might be updatable under certain circumstances - resolved
[Stored Procedures] stored procedure generates vserver issue - resolved
[Views] Altering view may detach its triggers if any error occured - resolved
[Fields] length() may return wrong values for TEXT fields where field content > 64kb - resolved
[SQL] SQL Single Line Comment issue on MAC - resolved
[SQL] Wrong position info in the error message for given query - resolved
[Error Codes/Classes] errormessages are cached - resolved
[SQL] Issue on query with XML result - resolved
[Other] some function does not return a varchar or string result - resolved
[Links] A link refused insert, and then all inserts got rejected by that link - resolved
[FBL Nodes] Last_RecID() and Last_RecID_Of_Table() should be session dependent - resolved
[Properties] Add 'EventCount' property to list of database properties
[SQL] LIMIT does not work on views - resolved
[Triggers] parser accept non declared variables when compiling instead of (delete)triggers - resolved
[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.

[NEW] 64 bit versions of Server: Linux, Windows, Mac OS X
[Property Inspector] [NEW] vServer's OS info available via SHOW PROPERTIES OF SERVER command - resolved
[ini-file] Empty records also with FLUSH_EACH_DATACHANGES - resolved
[SQL] WIKI examples not working for SQL Grant - resolved
[API] Get more info about users - resolved
[Other] Monitoring Server by SNMP - resolved
[Other] Switch to ACE v5.7 on Windows - resolved
[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.

[Preferences] VStudio Pro Preferences dialog does not function - resolved
[Dialogs] Opening SQL Editor gives error - resolved
[Project Tree] deleting datasource from project does not work- resolved
[Dialogs] Constraint in listview shows wrong value - resolved
[Application Menu] vStudio error when diagnose database - resolved
[Property Inspector] properties are not refreshed when clicking on another object - resolved
[Property Inspector] Server connection should have more INFO params - resolved
[Property Inspector] It should be an ability to turn off index flag on the field without impacting unique one - resolved
[Application Menu] Server Menu on opening of Vstudio has command "Server Admin" black - resolved
[Import/Export] The order of columns when exporting is NOT shown in the export dialog - resolved
[SQL Editor] Exporting from sql resultset - resolved
[Property Inspector] Assign property "Size" of the Link in the Property Inspector to the VLinkget_Size() - resolved
[Other] Double clicking can cause issues - resolved
[NEW][Preferences] Add ability to change colors
[TAB-Panels] Shortcuts to walk tab-panel has a problem - resolved
[Application Menu] Allow user to change autosave option - resolved
[NEW][Application Menu] "Add Report", "Add Folder" in main menu
[SQL Editor] text search function in sql editor - resolved
[Dialogs] Server connection dialogs differs between ONE or MORE bookmarks - resolved
[Schema Editor - Column View] MAc OS X: cmd-a in a field of "create new field" dialog selects ALL tables of the schema view - resolved
[Import/Export] Import generates error on mapping columns - resolved
[Project Tree - Data Sources] Create Datasource from Bookmarks does not work when not connected before - resolved
[Feature] Clicking on the dock icon (Mac OS X 10411) does not open the minimized Valentina Studio - resolved
[XML Dump/Load] Unexpected result on load XML dump in client mode - resolved
[Import/Export] Import ASCII on mac always produces error dialogs - resolved
[Other] when hitting command-s while SplashScreen is open it becomes blocked - resolved
[Import/Export] Mac OS X: ESC doesn't cancel (= close) import pane - resolved
[Data Editor] MAC command keys consistency - resolved
[Other] Saved Window size maybe wrong - resolved
[Other] VStudio opens with wrong position on screen - resolved
[Performance] Working on remote server database is unusable slow (Ruslan Zasukhin) - resolved
[SQL Editor] "Refresh" Button opens new result pane instead of refreshing the active one - resolved
[Schema Editor] Refresh button wrong functionality or no functionality - resolved
[Database] The cloned database is created in the wrong place - resolved
[SQL Editor] "Refreshing" doesn't keep the column width user settings - resolved
[Import/Export] crash when closing import wizard through via close BUTTON (bottom left in screen) - resolved
[Schema Editor] NOT deleted tables showing up in database list - resolved
[SQL Dump/Load] Crash on load database dump to VServer - resolved
[Data Editor Related] Removing a filter issue - resolved
[Import/Export] Random issue after import - resolved
[Views] refreshing with a opened view visible issue - resolved
[Printing] Printing Diagram issue VStudio - resolved
[Other] VStudio issue when try to open the open dialog - resolved
[Import/Export] export wizard doesn't keep order of columns to export - resolved
[Dialogs] Clicking in the delete field dialog on the background closes the dialog - resolved
[Dialogs] cmd-w doesn't works on text viewer window - resolved
[Data Editor Related] removing a filter in upper pane crashes VStudio - resolved
[SQL Editor] closing a sql pane issue - resolved
[Database]clone and diagnose - resolved
[SQL Editor] Editor toolbar can not be controlled by view menu - resolved
[Dialogs] Dialog CREATE TRIGGER should have COMMENT field - resolved
[Schema Editor] Closing DB issure - resolved
[Import/Export] select a file, hit refresh-button issue - resolved
[SQL Editor] issue on select statement + hovering mouse - resolved
[SQL Editor] Find and Replace functionality in SQL Editor - resolved
[Dialogs] selecting multiple db's in open dialog doesn't work - resolved
[Schema Editor] Context menu called for some selected objects work only for one - resolved
[Schema Editor] Need to correctly set state of edit toolbar items for Schema Editor - resolved
[Dialogs] Result window of diagnose must be significantly improved - resolved
[Application Menu] Open Recent does not work - resolved
[API] View definitions NOT editable or selectable - resolved
[Views] View definitions should be editable in VStudio - resolved
[API] Remove vs_I_Unknown and fix all child methods (Kirill Pekarov) - resolved
[API] Remove duplicated properties for vs_I_ObjectWithProperties - resolved
[SQL Editor] Option to enable text wrapping in the Editor(s) - resolved
[Schema Editor - Column View] refresh issue if a table is not deletable - resolved
[Application Menu] VStudio Recent Menu - resolved
[SQL Editor] Shift-End key does not select a line - resolved
[Schema Editor] delete table command fails without warning - resolved
[Property Inspector] [NEW] - Property Editor Dialog to edit values of object properties without SQL - resolved
[Triggers] [NEW] - Dialog to create trigger - resolved
[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.

[API][NEW] VConnection.databaseCount property
[API][NEW] VDatabase.connection property
[API] API for Database Format
[API] VVarchar init methods fault resolved
[New][Examples] Examples/Class_way/Table_Create
[New][Class-way] Fixed work of target version.
[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.

[Docs] Add into PDF info about property list parameter for AddRecord() method
[API] VTable.addRecord() should accept LIST of values as VCursor.addRecord()
[Client] Issue if do conection.close() on not opened one resolved
[Log Files] Forgetting to disable log files in apps causing deployment issues resolved
[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

Mac Carbon version no longer supported under Valentina 4.5. Director 10 Mac developers can continue to use Valentina 4.3 to connect to Valentina 4.5 Servers.

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] Support for REALbasic/Cocoa plugin
[Feature Request] Add timestamp to warning log
[Other] Additional warning files
[Class-way] VTable class constructor consistency resolved
[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.

Mac Carbon version no longer supported under Valentina 4.5. Developers can continue to use Valentina 4.3 to connect to Valentina 4.5 Servers.

Valentina for Revolution

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

[API] [NEW] VDatabase_Diagnose() method
[Examples] Examples are now all in the separate file instead of one example stack
[API] Using example provided in v4rev_examples.rev
[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.

Paradigma Products

Customer Center