Valentina Release 3.2 Notes

Paradigma Software announces Valentina Release 3.2, an update to Valentina 3.0.

The number listed is the feedback number found in our feedback system.

These user requests and fixes were corrected in this release.

Unless otherwise noted, improvements and fixes to the Valentina Database Kernel are available in any software solution in the Valentina product line labeled with the number 3.2 - including application developer kits, Valentina Office Server, Valentina Embedded Server or Valentina Free Server.

• 0002499: [Tables] [NEW] Custom System Tables
• 0002500: [SQL] [NEW] CREATE SYSTEM TABLE ….

• 0000789: SQL write access or functionality to V4RB2-LogFile - resolved.
• 0002498: API - String::setULLong with a 20 digits value issue - resolved.
• 0002437: API - Add a new value to field which have a method used this field and before addition has been changed type of it field - resolved.
• 0002438: SQL issue when adding new records to a field which used in some method and type of it field has changed - resolved.
• 0002430: SQL issue when change field type after created SP which works with it - resolved.
• 0002445: Issue when Triggers are used without a defined user variable in trigger - resolved.
• 0002458: API issue when delete table with two INSERT and UPDATE triggers - resolved.
• 0002425: [SQL] Alter table add column ObjectPtr result issue - resolved.
• 0002427: Altering ObjectPtr link in SQL issue with ObjectPtr in some circumstances.- resolved.
• 0002428: Dropping RDB link in SQL does not drop FK constraints - resolved.
• 0002435: [SQL] SQL View is not replaced by “CREATE OR REPLACE VIEW” command - resolved.
• 0002436: After create a clean ObjectPtr field without link, the link count of database and table show that link is correct - resolved.
• 0002439: VTable.UpdateAllRecords with unique field issue - resolved.

Valentina COM works with any IDE that fully supports the Microsoft COM specification, including Visual BASIC 6, Visual BASIC.net and Delphi.

• 0002483: VLink2.CopyLinksTo( inLeftTargetLink As VLink2, inpRightTargetLink As VLink2).
• 0002482: VLink2.CopyLinksFrom( inLink1 As VLink2, inLink2 As VLink2 = NULL ).
• 0002476: Valentina.WriteToLog( inMsg As String ).
• 0002475: VLink.Kind() As EVLinkKind (Kirill).

• 0002485: Free Visual Basic Example Code: API_way/Link_Convert_M_TO_M.
• 0002484: Free Visual Basic Example Code: API_way/Link_Convert_1_TO_M.
• 0002481: Free Visual Basic Example Code: SQL_way/Link_Convert_M_TO_M.
• 0002480: Free Visual Basic Example Code: SQL_way/Link_Convert_1_TO_M.
• 0002479: Free Visual Basic Example Code: SQL_way/Triggers.
• 0002478: Free Visual Basic Example Code: SQL_way/Stored_Procedures.
• 0002477: Free Visual Basic Example Code: VServer/ScheduledBackup.

• 0002465: VTable::Create*Field methods issue with throw errors in Visual Basic - resolved.

Valentina for Director 3.2 works with both Macromedia Director and Adobe Director.

• 0002505: VField.getString() return <null> for NULL and empty not NULL value to ensure compatibility with Director for this type of return.
• 0002504: [API] VField.Value return <void> instead of ”” for empty not null value to ensure compatibility with Director for this type of return.

Fixes apply to each operating system platform of REALbasic - REALbasic for Linux, REALbasic for Windows and REALbasic for Mac OS X.

• 0002489: VLink2.CopyLinksTo( inLeftTargetLink As VLink2, inpRightTargetLink As VLink2.
• 0002488: VLink2.CopyLinksFrom( inLink1 As VLink2, inLink2 As VLink2 = NULL ).
• 0002487: Valentina.WriteToLog( inMsg As String ).
• 0002486: VLink.Kind() As Integer.

• 0002496: Free REALbasic Example: API_way/Link_Convert_M_TO_M.
• 0002495: Free REALbasic Example: API_way/Link_Convert_1_TO_M.
• 0002494: Free REALbasic Example: SQL_way/Link_Convert_M_TO_M.
• 0002493: Free REALbasic Example: SQL_way/Link_Convert_1_TO_M.
• 0002492: Free REALbasic Example: [NEW] SQL_way/Triggers.
• 0002491: Free REALbasic Example: SQL_way/Stored_Procedures.
• 0002490: Free REALbasic Example: VServer/ScheduledBackup.

• 0001935: LLong and ULLong.Value issue using Class-Way.
• 0001242 table.field.Value returns 64-bit values in REALbasic 2006 - resolved.
• 0002383: Issue when trying to perform a SELECT on a damaged database - resolved.
• 0002443: Documentation for SQL command BACKUP DATABASE
• 0002449: Documentation for “If not exists” doesn't exist
• 0002434: Deleting of record with BLOBs issue resolved.

• 0002420: Opening encrypted databases using PHP - resolved.
• 0002502: Using Valentina under Windows PHP 5 - resolved.
• 0002432: Unsigned medium field always returns NULL on fetch array - resolved.

Improvements to Valentina 3.2 are available in both the Windows and MacOS X versions of the product unless specifically indicated by the note.

• 0002511: Data is now cached in the Data Editor improving connectivity with any server.

• 0002452: SQL Editor views now autocomplete.
• 0002453: SQL Builder empty areas in tables - resolved.
• 0002512: Open files in Views with names that begin with “select”.
• 0002376: Import text files without .txt extension resolved.
• 0002440: Save File button issue resolved.
• 0002460: Schema Editor changing proprties - resolved.
• 0002380: Stripping “\ r ” - resolved.
• 0002501: Schema Editor Selection in Tree Mode updates in Column Mode - resolved.
• 0002459: Schema Editor - Opening SQL editor issue - resolved.
• 0002441: Application Menu Updating database in the “Datasource Elements” list - resolved.
• 0002442: Clicking SQLEditor in VStudio when connecting to Database Server issue - resolved.
• 0001979: Data Editor Data-browser modify CR to LF - resolved.
• 0002455: Text fields in data entry on multiple lines - resolved.
• 0002322: Data-Editor scrolling fieldnames issued resolved.
• 0002188: Issue with connecting to a database server over a VPN fixed.
• 0002473: Views varchar field in view limitation to 20 characters removed.