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.

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

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

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 to an older database on a server (or elsewhere) in Valentina Studio Admin, you may receive an error indicating an unknown event as a message back from the server.

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

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 Free Server.

The following features are new to Valentina Database Kernel 3.5.

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.

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, let's 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 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

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

Lists all keywords supported by the engine.

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

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 the 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 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

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

REF: 0002767

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

REF: 0002768

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

Example code available for download.

Example code available for download.

Example code available for download.

Example code available for download.

Example code available for download.

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 a 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

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

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

REF: 0002730

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

The following features were added to Valentina for Revolution 3.5.

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

REF:0002717

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

REF:0002718

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 code available for download and supported with versions of Runtime Revolution or Mirye Runtime Revolution that support database connectivity.

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

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

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

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

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

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

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

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

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 supports the Microsoft .net framework and CLR and tested primarily with Microsoft Visual C# and Microsoft VisualBASIC.net.

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

REF: 0002685

Convert one or two links to another one.

REF: 0002684

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

REF: 0002683

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

REF: 0002682

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

Example code available for download.

Example code available for download.

Example code available for download.

Example code available for download.

Example code available for download.

The following issues were resolved in this release.

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

Valentina for PHP (VPHP) was updated to version 3.5.

The following features were added to Valentina for PHP 3.5.

Encoding parameter can now be passed in valentina_connect().

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.

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

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 an unexpected outcome in certain circumstances.

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 usabilities and diagramming features.

Paradigma Software | Mirye Software Publishing

The following features were added to Valentina Studio Admin 3.5.

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

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

Reference:0002826.

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

Reference:0002627.

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

Reference:0002817.

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

Reference:0002827.

Great productivity enhancer for working with complex queries.

Reference:0002773.

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.