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:
The following properties are read-only:
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.
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.
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
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.
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.
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.
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.
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.
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.
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.
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: