Valentina Studio Administrator specifications

• 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.
• Database Diagramming: Print Diagram. You can now print (to a single page) the current diagram.
• Database Diagramming: Save Diagrams to Different Database. You can now save your diagrams and import them into other databases.
• 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.
• Visual SQL Builder: Write Complex Conditions in a Single Filter Cell. Great productivity enhancer for working with complex queries.
• 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

 

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.

SQL SHOW VKEYWORDS. Lists all keywords supported by the engine.

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

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