This is a comprehensive list of notes, new features, improvements and user education additions with the Valentina 3.5 Technology Release.

For specifics related to your product or development environment, scroll down to the section governing your product.

Valentina Release 3.5 Notes

This is a comprehensive list of notes, new features, improvements and user education additions with the Valentina 3.5 Technology Release.

For specifics related to your product or development environment, scroll down to the section governing your product.

• Valentina Database Kernel 3.5 (all)
• Adobe Director Developers
• REALbasic Developers
• Revolution Developers
• COM Developers (Delphi, VB 6)
• .NET Developers (C#, VB.net)
• PHP Developers
• Valentina Server (all versions)
• Valentina Studio Admin

Products not listed above, including Valentina C++ (all operating system versions), Valentina for Cocoa/Objective C and Valentina for Ruby benefit from the database kernel updates.

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

Important Notes

If you are updating to Valentina 3.5 products, you should read the following notes.

Valentina Studio Admin 3.5 Compatibility

Valentina Studio Admin 3.5 includes several key improvements including support for new SQL queries. Valentina engineers recommend that if you are working with database files earlier that technology release 3.5, that you use the equivalent earlier version of Valentina Studio Admin.

If you connect with an older database on a server (or elsehwhere) in Valentina Studio Admin, you may receive an error indicating an unknown event as a message back from the server.

Improvements and Fixes

Below are the most significant user requests and fixes that was implemented in this release. The complete list of changes you can find in Change Log.

Valentina Database Kernel 3.5

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.5 - including application developer kits, Valentina Office Server, Valentina Embedded Server or Valentina Community Server.

Valentina Database Kernel 3.5 New Features

The following features are new to Valentina Database Kernel 3.5.

Server Properties

Valentina databases are becoming more object-oriented in order to follow modern programmatic trends. Using SQL, you can now read and read/write properties of a Valentina Server database.

The following properties are read/write properties:

• BACKLOG
• BONJOURENABLE
• BONJOURPROTOCOLNAME
• BONJOURSERVICENAME
• CACHESIZE
• DISABLEDNS
• FLUSHEACHDATACHANGES
• LOGTOCONSOLE
• LOGTOFILE
• LOGCONNECTIONTRAFFIC
• MAXCLIENTTIMEOUT
• PORT
• PORT_HTTP
• PORT_SSL
• SCHEDULEENABLE
• SYSTEMCATALOG
• SSL_CERTIFICATE
• SSL_PRIVATEKEY
• THREADS
• USEOLDPASSWORDS
• VERBOSELEVEL

The following properties are read only:

• CONNECTIONSAVAILABLE
• CONNECTIONSMAX
• VERSION

Mantis: 0002729.

Group By with Roll Up

Valentina 3.5 and higher supports Group By with Roll Up - using the modifier Roll Up. Normally, when you make a Group By query, you get back data that you might otherwise need to query.

For example, lets say you want to query your total sales for each month in a year. A Group By without this modifier would return a number for each month. A Group By with Roll Up can automatically return the total sales for the entire year.

OR with fields from different JOIN tables

OR between fields from different join tables is now supported, making such syntax possible:

FROM T1 join T2 ON T1.id = T2.ptr AND T1.f > v1 AND T2.f4 < v3 ... WHERE

New SQL Commands

The following new SQL commands were included in Valentina Kernel 3.5. These are specific extensions to SQL support in Valentina.

SHOW VKEYWORDS

Lists all keywords supported by the engine.

SHOW VIDENTS

Lists current IDENTs of database. Used for auto-completion of Valentina Studio.

Valentina Database Kernel 3.5 Improvements

The following issues reported by engineers and customers were improved or fixed in this release. You can get more detail by entering the issue number in our reporting system.

• 0002468: [Other] Clone under certain circumstances would have unexpected results.
• 0002771: [Join of Tables] Join on String Methods under certain circumstances would have unexpected results.
• 0002604: [Indexes] Initial search on index by words method can be slow.
• 0002716: [Triggers] "Before-update" trigger usage can have unexpected results.
• 0002748 | 0002703: [SQL] Stored procedures returns unexpected results in certain circumstances.
• 0002708: [SQL Nodes] Incorrect case results inside SP in certain circumstances.
• 002709: [SQL] "set var = select f1 from t1 WHERE false" can produce unexpected results in certain circumstances.
• 0002796: [SQL] Predicate in join clause should be applied strictly before join.
• 0002863: [SQL] max(length()) under certain circumstances would have unexpected results.

Valentina for Director 3.5

Valentina for Director 3.5 is a set of products for connecting Valentina databases with Adobe Director.

Adobe Director is the proven multimedia authoring tool for professionals. Director combines broad media support for media types, ease of use, high-performance, and an infinitely extensible development environment to deliver rich content and applications for CDs, DVDs, kiosks, and the Internet. Director MX 2004 offers powerful new features, including two scripting languages, DVD-Video support, cross-platform publishing, and Flash MX 2004 integration.

Paradigma Software | Mirye Software Publishing

Valentina for Director 3.5 Features

VLink.Kind() As String

This is read-only property that returns a kind of link.

REF: 0002767

Valentina.WriteToLog( inMsg As String )

This method writes the specified string into the database Log file.

REF: 0002768

Valentina for Director 3.5 Improvements

• 0002814: [API] VField.DefaultValue. In certain circumstances, unable to set this value.

Valentina for Director 3.5 User Education

Example: Scheduled Backup with Valentina Server

Example code available for download.

Example: Using Director with SQL: Stored Procedures

Example code available for download.

Example: Using Director with SQL: Triggers

Example code available for download.

Example: Using Director with SQL: Link_Convert_1_TO_M

Example code available for download.

Example: Using Director with SQL: Link_Convert_M_TO_M

Example code available for download.

Valentina for REALbasic 3.5

Valentina for REALbasic 3.5 is a set of products for connecting Valentina databases with REAL Software REALbasic.

REALbasic is a rapid application development (RAD) environment that provides developers a marked increase in productivity over other cross-platform development tools. REALbasic includes drag-and-drop capability to enable you to quickly create a user interface design, then incorporate the code behind it to add power and functionality.

Paradigma Software | Mirye Software Publishing

Valentina for REALbasic 3.5 Features

The following new features were added to Valentina for REALbasic 3.5.

Valentina for REALbasic 3.5 Class New Get Properties

VRBDatabase class get properties Port, ConnectionTimout, EmbeddedSerial, for working with the RBDB API.

REF: 0002730

Valentina for REALbasic 3.5 Improvements

This release included the following improvements or fixes.

• 0002754: [RBDB API] VRBDataBase unexpected result when using certain RBDB API calls.
• 0002868: [SQL] Unexpected results with queries in certain circumstances.
• 0002867: [SQL] Unexpected results when using SQL IN clause with a Subquery using UNION.
• 0002857: [API] VCursor.ObjectPtrField() removed.
• 0002810: [API] Set VField.DefaultValue unexpected results in certain circumstances.

Valentina for Revolution 3.5

Valentina for Revolution 3.5 is a set of products for connecting Valentina databases with Runtime Revolution.

Revolution Studio provides you with all the tools to build fantastic looking solutions in no time at all - it includes a pre-built application shell or project environment, plus all the graphical interface elements you need to create and deploy native solutions on four operating systems!

Start by laying out your presentation layer, add some code, then instantly test without long compilation times! Revolution Studio also supports major video, graphics, and audio formats so you can easily integrate it into your production workflow.

Valentina for Revolution 3.5 Features

The following features were added to Valentina for Revolution 3.5.

VLink.Kind() As String

This is read-only property that returns a kind of link.

REF:0002717

Valentina.WriteToLog( inMsg As String )

This method writes the specified string into the database Log file.

REF:0002718

Valentina for Revolution 3.5 User Education

The following example stacks were added and available for download. The examples may work with earlier versions of Valentina for Revolution; these examples are only supported using Valentina for Revolution 3.5.

Example: Scheduled Backup with Valentina Server

Example code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

Example: Using Runtime Revolution with SQL: Stored Procedures

Example code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

Example: Using Runtime Revolution with SQL: Triggers

Example code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

Example: Using Runtime Revolution with SQL: Link_Convert_1_TO_M

Example code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

Example: Using Runtime Revolution with SQL: Link_Convert_M_TO_M

Example code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

Example: Using Runtime Revolution with Native Valentina API: Dump SQL Database

Example code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

Example: Using Runtime Revolution with Native Valentina API: Dump XML Database

Example code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

Example: Using Runtime Revolution with Native Valentina API: Dump XML Table

Example code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

Valentina for Revolution 3.5 Improvements

The following improvements were made in Valentina for Revolution 3.5.

* 0002332: Using RevDB API, pictures stored in the database can be viewed.
* 0002812: Set VField.DefaultValue had unexpected results.

Valentina for COM 3.5

Valentina COM 3.5 is a set of products for connecting Valentina databases with any development environment that supports the COM standard on the Windows | Intel platform.

Valentina for COM 3.5 Improvements

The following improvements or issues were resolved in release 3.5.

* 0002841: [API] field(...).value unexpected result in returning Byte array.
* 0002813: [API] Set VField.DefaultValue had unexpected results.
* 0002785: [Change] sqlselect() could produce a statement error after a raised VCOM exception.
* 0002671: [Fields] A second access of VField.value could have an unexpected result.
* 0002732: [Fields] "null-value" of VT_NULL can produce unexpected result.
* 0002268: [API-way] Speed issues after server reboot.
* 0002664: [Other] UseEncrytionKey spelling.

Valentina for NET 3.5

Valentina for NET 3.5 supports the Microsoft .net framework and CLR and tested primiarily with Microsoft Visual C# and Microsoft VisualBASIC.net.

Valentina for NET 3.5 New Features

VLink2.CopyLinksTo( inLeftTargetLink As IVLink2, inRightTargetLink As IVLink2)

Convert one link to two links. Used with M:M relationships.

REF: 0002685

VLink2.CopyLinksFrom( inLink1 As IVLink2, inLink2 As IVLink2 = NULL )

Convert one or two links to another one.

REF: 0002684

Valentina.WriteToLog( inMsg As String )

This method writes the specified string into the database Log file.

REF: 0002683

VLink.Kind() As EVLinkKind

This is read-only property that returns a kind of link.

REF: 0002682

Valentina for NET 3.5 User Education

New example projects are available to learn how to use Valentina for NET 3.5 with C# and Visual Basic.net.

Example: Using C# or VB.net with SQL: Triggers

Example code available for download.

Example: Using C# or VB.net with SQL: Stored Procedures

Example code available for download.

Example: Using C# or VB.net with SQL: Valentina Server and Scheduled Back Up

Example code available for download.

Example: Using C# or VB.net with SQL: Link_Convert_1_TO_M

Example code available for download.

Example: Using C# or VB.net with SQL: Link_Convert_M_TO_M

Example code available for download.

Valentina for NET 3.5 Improvements

The following issues were resolved in this release.

• 0002811: [API] Set VField.DefaultValue had unexpected results.

Valentina for PHP 3.5

Valentina for PHP (VPHP) was updated to version 3.5. Valentina PHP works with PHP 4 or PHP 5 and is available within Valentina Office Server as well as kits for developing local PHP applications.

Valentina for PHP 3.5 Features

The following features were added to Valentina for PHP 3.5.

Encoding Parameter

Encoding parameter can now be passed in valentina_connect().

Valentina Server 3.5

Unless otherwise noted, features and improvements apply to both Valentina Embedded Server and Valentina Office Server and on all supported operating systems: Windows, Linux and Mac OS X.

Valentina Server 3.5 Features

Linux Installation Improved

You can now install on Linux without write permissions to /usr/.

Valentina Server 3.5 Improvements

The following were improved or fixed in Valentina Server 3.5.

• 0002859: [API] LoadDump would not work in certain circumstances.
• 0002843: [Localization] Unexpected outcome with specific chars in a string value in certain circumstances where non-system encoding was used in a connection.
• 0002823: [SQL] Stored procedures had unexpected outcome in certain circumstances.

Valentina Studio 3.5

Valentina Studio Admin Edition is the visual utility application for visual creation, query and administrative chores by database developers and administrators. Valentina Studio 3.5 added several new usability and diagramming features.

| Paradigma Software | Mirye Software Publishing

Valentina Studio 3.5 Features

The following features were added to Valentina Studio Admin 3.5.

Add Views | Properties | Procedures Menu, Buttons and Dialogs

You can now accelerate your development by quick access to creating new Views, Properties and Procedures from the tool bar or through menu items Add View, Add Property, Add Procedure.

Database Diagramming: Search

You can now search for terms within a database diagram using a Search field, and go to the result.

Reference:0002826.

Database Diagramming: Print Diagram

You can now print (to a single page) the current diagram.

Reference:0002627.

Database Diagramming: Save Diagrams to Different Database

You can now save your diagrams and import them into other databases.

Reference:0002817.

Resizing All Columns in Column View in Schema Editor

You can now resize all of your columns at once in the Schema Editor Column View.

Reference:0002827.

Visual SQL Builder: Write Complex Conditions in a Single Filter Cell

Great productivity enhancer for working with complex queries.

Reference:0002773.

Valentina Studio 3.5 Improvements

The following issues were reported by engineers and customers and corrected in this release:

• 0002878: [Other] Set|Drop Primary Key for Server Connection. Fixed.
• 0002848: [Data Editor] Bring to front condition.
• 0002849: [Diagrams] Deleting fields in diagrams.
• 0002872: [Application Menu] File > Dump Database > XML layout.
• 0002866: [SQL Editor] Auto-completion on Mac OS X text.
• 0002661: [SQL Editor] German Umlauts on Mac OS X.
• 0002834: [Schema Editor] Finding more than one Bonjour databases.
• 0002833: [Schema Editor - Tree View] Open | Close Bonjour database.
• 0002822: [Diagrams] Comments wrapping issue.
• 0002816: [SQL Editor] Auto-completion on events.
• 0002775: [Property Inspector] Using illegal field names.
• 0002678: [Stored Procedures] Refreshing text of stored procedures.
• 0002735: [Import/Export] Loading SQL dumps from Valentina Server.
• 0002740: [Data Editor] Add records issue.
• 0002599: [Contextual Menu] Contextual menus on Mac OS X appearance.
• 0001569: [Application Menu] Schema Browser Column headers appearance.
• 0002736: [Other] Quit issues in specific circumstances.
• 0002714: [Other] Choosing Clear Recent files unexpected outcome.
• 0002672: [SQL Dictionary] Missing Entry.
• 0002739: [Schema Editor] Error on Drop Table in certain circumstances.
• 0002749: [VServer Admin] Unregistering a database in certain circumstances has unexpected outcome.
• 0002750: [Other] Closing a database in certain circumstances has unexpected outcome.
• 0002756: [Schema Editor - Column View] Fixed appearance.
• 0002670: [Events/Sheduler] 10-minute demo limit timeout message had unexpected outcome.