Valentina 4.8 Technology Release tech notes tell you what is new in Valentina 4.8

Valentina Technology release 4.8 includes multiple feature improvements, Linux, iOS versions of products, SQLite support.

Valentina 4.x Releases

• Valentina 4.8 - December 15, 2010
• Valentina 4.7 - July 19, 2010
• Valentina 4.6 - April 30, 2010
• 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.8 introduces Valentina Interface Builder and new features for Cocoa, SQLite Support in Valentina Studio Pro, Valentina Studio for Linux (Preview), iValentina for iOS/iPhone, iValentina for iOS/iPad

Valentina 4.7 introduces 64 bit versions of Mac OS X PHP, Cocoa, C++ ADKs

Valentina 4.6 introduces the Function Browser in Valentina Studio

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

• [SQL] slow order by on views with not all fields required - resolved.
• [SQL Explain] EXPLAIN now prints info about materialization of VIEWs and SubQueries. - resolved.
• [Properties] [NEW] Global property LogFilesLocation - resolved.
• [Table Joins] Wrong expression result on self-join - resolved.
• [Docs] Example please for check constraint - resolved.
• [SQL Explain] [NEW] Explain now prints time of DISTINCT clause. - resolved.
• [SQL Explain] [NEW] Explain now prints time of RECORD LOCKS. - resolved.
• [SQL Explain] [NEW] Explain now prints ORDER BY time. - resolved.
• [SQL] ALTER TABLE xxx MODIFY .... OBJECTPTR sets value of ObjectPtrfield to 0- resolved.
• [Import/Export] Chunk boundaries import issues. - resolved.
• [Join of Tables] Recursive joins issue - resolved.
• [RAM Table] Issue on creation of RAM-based tables - resolved.
• [Fields] Writing to compressed BLOB issue - resolved.
• [SQL] Error on update with empty string - resolved.
• [API] Issue on Value_Numeric::put_String( String() ) - resolved.
• [Import/Export] Load SQL dump created from database named with numerals '111" - resolved.
• [Database] Error 5 when open vdb in readonly directory - resolved.
• [Views] Issue selecting from view which has GROUPBY over subquery (join) result (Ivan Smahin) - resolved.
• [SQL] Rename 'SPs' from SHOW PROCEDURES result to 'Custom functions'- resolved.
• [SQL] count(distinct(expression)) return issue- resolved.
• [New][Error Codes/Classes] Throw InternalError() shows info about FILE, FUNC, LINE
• [SQL Nodes] [NEW] SHOW PROCEDURES statement enhancements
• [Stored Procedures] Issue when using stored procedures with order by clause - resolved.
• [Import/Export] ImportAnalyze causes issue - resolved.
• [Import/Export] ImportAnalyze called with empty properties( separators ) causes issue
• [Performance] LOCATE better optimized in SQL searches - resolved.
• [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

• [Diagnose] Inaccurate reports in low verbose mode- resolved.
• [Cursors] Cursor::get_Query can return source query issue - resolved.
• [Fields] Truncate all records in some circumstances issue- resolved.
• [SQL] NULLs as binded value cause vKernel issue - resolved.
• [SQL Nodes] SQL-string function over date field produces exception - resolved.
• [Backup] backups created in /VServer main dir - resolved.
• [SQL] md5 function issue when used with PHP 5.3 - resolved.
• [NEW] Multi-threaded sort algorithm
• [Join of Tables] Outer joins with BLOB issue with segment map - resolved.
• [SQL] FIRST() and LAST() aggregate functions return numeric type fields issue - resolved.
• [SQL Nodes] Now() - milliseconds values - resolved.
• [Views] "select * from view order by f1" may produce issue in some circumstances. - resolved.
• [API] Issue on put string to field - resolved.
• [Views] Issue on query on a view - resolved.
• [NEW] [Properties] Property to database - UserTableCount
• [SQL] Complex Query issue on medium size DB - closed.
• [Cache] Cache flushing issue when Setting FlushEachDataChange = 1 - closed.
• [New][SQL] SHOW VARIABLES
• [New][SQL]Count of methods to SHOW TABLES result
• [New][SQL] Descriptions for procedures from "SHOW PROCEDURES ALL"
• [New][SQL] Count of properties to SHOW PROCEDURES result
• [New][SQL] MD5 hash function for SQL Expressions
• [New][SQL] Display 'comment' and 'category' to "SHOW PROCEDURES"
• [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.

• [Installation] Exe-name issue after installation of x64 VServer- resolved.
• [NEW] [ini-file]HostingMode property.
• [NEW] [Other] [IMP] VServer recognizes license and licence folder styles
• [API] vreports does not switch to enabled when there is a expired license file next to a valid license file- resolved.
• [SQL] SqlQuery() result issue (FlushEachDataChanges=1)- resolved.
• [ini-file] INI File management (Ruslan Zasukhin) - resolved.
• [ini-file] VSERVER uses INI file name as source.- resolved.
• Error reporting on duplicate key - resolved
• [Log Files] [New] VServer and any other App now on default (can) keep ALL log files in the VServer/vlogs folder. - resolved
• [Log Files] All logs should be named with the same time stamp - resolved
• [ini-file] [NEW] param. in INI for log-files location - resolved
• [SQL] [NEW] vServer property - LOGFILESLOCATION- resolved
• [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
• [New] Monitoring Server by SNMP
• [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/ Studio Pro

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

• [PRO] [New] SQLite Database Plugin
• [Import/Export] Change column size in file preview of import wizard- resolved.
• [Database] Clone database issue- resolved.
• [Performance] Move main window on mac- resolved.
• [Dialogs] Rewrite new Field Dialog using LT
• [Import/Export] Rewrite export to excel
• [Other] Replace wxAuiNotebook to LThemedNotebook
• [Preferences] font selector in preferences visibility issue- resolved.
• [Schema Editor - Tree View] On select item in tree issue- resolved.
• [Import/Export] Smart mapping on import - resolved.
• [Import/Export] Importing to vServer issue- resolved.
• [Other] vsFramePage inherited from LPanel- resolved.
• [Links] OnDelete property handler issue- resolved.
• [PRO][Reports - Controls] Field with linebreaks in content issue - resolved.
• [PRO][Report Editor] Vertical scrollbar issue when opening second report - resolved.
  
• [PRO][Reports - Export/Import] VStudio crashes when trying to export report - resolved.
• [PRO][Other] VStudio on Windows can connect to server on port 15432 even if server uses 15433 only- resolved.
• [SQL Editor] VStudio issue after a Kernel error: 0x60508. Stream EOF reached - resolved.
• [Inspector] [NEW] Inspector now shows editible CATEGORY and COMMENT for Stored Procedures. - resolved.
• [SQL Editor] [NEW] SQL Editor can now show the Function Browser dialog with list of all System and User defined procedures and functions.
• [SQL Editor] [NEW] SQL Editor gets a new menu item to enable Tune/Warnings/Output
• [SQL Editor] [NEW] SQL Editor gets a new tab-panels for Logs/Output/Warnings/Tune
• [Other] Issue on diagnose of DB- resolved.
• [Windows] closing the last tab of a window should close the window itself - resolved.
• [ODBC Import] Better scrolling/display in ODBC Import dialog - resolved.
• [Schema Editor - Column View] Code display refreshing- resolved.
• [SQL Editor] Replace selected text using numeric keypad - resolved.
• [SQL Editor] DB-popup menu in SQL Editor listing of unopened databases - resolved.
• [Preferences] [NEW] in the prefs dialog shows PATH to the prefs file and ability open it - resolved.
• [API] Move vsCursorGrid with all dependencies and parents from SQLPlugin to Application - resolved.
• [Import/Export] Correctly generate cursor dumps- resolved.
• [Schema Editor - Column View] multi item selection issues - resolved.
• [Schema Editor] multi item deletion ... warning issue - resolved.
• [Dialogs] Dialogs store own size and position on application close - resolved.
• [Bookmarks] Bonjour items and Bookmarks now display their properties in the Inspector - resolved.
• [Windows] Resizing of apps work correctly on display change. - resolved.
• [Contextual Menu] contextual menu and schema menu display issues - resolved.
• [Schema Editor - Column View] Dropping a method field via right click -> delete... on the field issue - resolved.
• [Schema Editor] VStudio issue on diagnose db - resolved.
• [Schema Editor - Column View] Issue while deleting several tables - resolved.
• [Schema Editor] when closing db issue- resolved.
• [SQL Editor] SQL editor export issue- resolved.
• [Import/Export] Export issue to Excel field types when exporting text starting with 0 - resolved.
• [Import/Export] Export dialog displays columns - resolved.
• [Import/Export] Export to Excel exports column names - resolved.
• [SQL] Issue with script execution- resolved.
• [Keyboard Shortcuts] Mac OS X: CMD-H assignable for hide - resolved.
• [SQL Editor] Creating a procedure crashes vstudio- resolved.
• [SQL Editor] Fix error log in the SQL Editor for server connection - resolved.
• [Schema Editor - Tree View] Treeview on schema editor does not refresh correctly / closing the database makes it temporarily dissappear - resolved.
• [Schema Editor] SCHEMA editor and PROJECT window display- resolved.
• [Form Editor] Page break generates an extra empty page at the end of a report - resolved.
• [Other] Studio error after creating a view - resolved.
• [Other] Crash when creating a field in Studio - resolved.
• [Reports - Preview] Switching renderer while in preview to OS native issue - resolved.
• [Other] Studio issue after creating a table - resolved.
• [Other] REGISTRATION dialog - resolved
• [Property Inspector] Renaming a table in Studio does not show the change until you select another table - resolved.
• [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

iValentina

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

• [New] New Product: iValentina for iOS / iPhone
• [New] New Product: iValentina for iOS / iPad
• [New][SQL Editor] Ability to change function's description
• [New][Diagrams] Ability to drop diagrams
• [Schema Editor] can't select field by touching on name - resolved.
• [New][Schema Editor] Edit button for field attributes
• [Client] Issue after closing app and reopen it - resolved.
• [New][Dialogs] Network Activity Indicator
• [New]Integrate TextExpander utility
• [SQL Editor] Wrong start position of the screen in the query editor in iOS4 - resolved.
• [New][Views] landscape mode support
• [New]Storing favorite queries in the file
• [New][SQL Editor] Storing recent queries in the file
• [Feature] Ability to create and drop methods
• [Schema Editor] ObjPtr Field didn't show all informations nor are they editable - resolved.
• [New][Windows] Show preview of SQL text when we create VIEW/PROCEDURES/... in GUI way
• [SQL Editor] Create dialogs and storing schema for Favourite Queries
• [Console] Log entries can not be deleted one by one - resolved.
• [New][Schema Editor] Ability to create and drop a table
• [New][SQL Editor] Button to clear the editor
• [New][Bookmarks] Bookmarks stored
• [New][SQL Editor] Editing of Time Fields
• [New][SQL Editor] Editing of Picture Fields
• [Schema Editor] In the field type picker the checkmark is missing - resolved.

Valentina Reports

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

• [NEW][Reports] Ability to use patterns for output data
• [NEW][Reports] Add Summary... button
• [Control - Label] wrap_text should only wrap on spaces- resolved.
• [EXPORT - PDF] PDF Exporting Report issues with VStudio - resolved
• [EXPORT - PDF] Correct display of Cyrrilic letters in PDF exports - resolved
• [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] Valentina for Cocoa Interface Builder Plugin
  
• [Other] Test for Valentina Enumerator objects
• [Other] Project for testing Valentina 4.8 Cocoa features
• [NEW] VTableEnumerator object
• [NEW] VLinkEnumerator object
• [NEW] VFieldEnumerator object
• [Other] [NEW] FastEnumeration protocol for enumerating fields in VCursor
• [NEW] VTable linkEnumerator method
• [NEW] VCursor fieldEnumerator method
• [Other] [NEW] VDatabase linkEnumerator method
• [API] VDatabase tableEnumerator method
• [Other] Use "NSInteger" instead of "int" to supress compiler warnings
• [API] DateComponents method of VDate and VDateTime Autoreleased object - resolved.
• [NEW] V4CC/iV4CC Frameworks should work in GC-enabled apps
• [Fields] Setting numeric fields by object value more than once issue - resolved.
• [NEW] [Cursors] ADD VCursor( KVC ) category with valueForKey, setValue:forKey
• [SQL] Getting DateTimeFormat property of database from V4CC SqlSelect issue - resolved.
• [Examples] [NEW] Example that show usage of VCursor KVC in bindings of Interface Builder
• [NEW] 64 Bit Version of Valentina for Cocoa
• [Fields] [NEW] class VBlob now has blobValue and setBlobValue methods. - resolved.
• [API] VField.value property should support NSData value for VBlob fields. - resolved.
• [Fields] Add to VBLOB class methods blobValue / setBlobValue. - resolved.
• [SQL] Issue with Sql Blob Update Fails with Binded NSData - resolved.
• [Fields] VField issue with value returns not an object when the field is boolean - resolved.
• [Installation] Installation uninstall resolved.
• [Class-way] Memory leaks with Class-way API
• [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.

• [API] [NEW] Valentina_CopyCursorToNewTable() function
• [Pictures] inQuality ignored in WritePictureAs() method - resolved
• [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.

• [Import/Export] vcursor.importText and vcursor.exportText issue - resolved
• [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.

• [API] [NEW] Valentina_CopyCursorToNewTable() function
• [Pictures] inQuality ignored in WritePictureAs() method - resolved
• [API] Memory - V4NET objects release all resources but not collected by GC. - resolved
• [API] Set compressed flag when creating BLOB field. - resolved
• [New] FindValues
• [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.

• [SQL] inserting a blob through vPHP issue vServer - resolved.
• [API] Connection was not closed properly issue - resolved.
• [NEW] [MAC] [Standalone] 64 Bit Operations Version
• [NEW] [MAC] [Server] 64 Bit Operations Version
• [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.

• [API] [NEW] Valentina.CopyCursorToNewTable() function
• [Database] Cannot open database using Cocoa build on latest REAL Studio - resolved.
• [Docs] Incomplete sentence for position - resolved.
• [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.6. Developers can continue to use Valentina 4.3 to connect to Valentina 4.5 Servers.

Valentina for LiveCode / Revolution

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

• [API] [NEW] Valentina_CopyCursorToNewTable() function
• [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

VSDK (C++)

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

• [NEW] [MAC] 64 Bit Operations Version

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