[ANN] Valentina products 3.5.2 RELEASE uploaded

Sun Feb 10 03:24:20 CST 2008

Hi All,

We have finish 3.5.2 RELEASE.  Below you will find complete list of fixes
and improvements, and here is list of the most major issues by human words:

* VSERVER and Encryption
        Now vserver correctly manage encrypted db files, and SECOND user
        do not get access to decrypted info by first user.

* BIG FILES > 4Gb
        Fixed issue on Linux, and fixed issue for BLOB fields.

* COMPLEX JOINS improved.
        Now it is possible do complex joins and specify FILTER conditions
right 
        in the FROM clause.

* TRIGGERS and RecID
        now correctly works with values of this field.

* NOT(fldMethod) speed improved in 40+ times

* Tutorials updated to show fine err msg if VSERVER is not found.

* RBDB fixed to work under RB IDE GUI Tools.

* VISTA bug fixed for Valentina.EscapeString()

* Valentina Studio fixes/improved more than 30 issues, including:
        * Export of result in SQL Editor
        * Bookmarks for Valentina Server
        * Syntax highlights for Triggers and Stored Procedures editors.

kernel - 3.5.2
==============
- 0003006: [API] Default date/time values glitch (ivan) - resolved.
- 0002836: [Indexes] slow and misbehaving NOT indexes on methods (ruslan) -
resolved.
- 0003004: [SQL Nodes] Wrong sort order for join result in some cases.
(ivan) - resolved.
- 0002983: [SQL Nodes] Encrypted table/field/link might be operated without
encryption key. (ivan) - resolved.
- 0002956: [Triggers] Wrong results using NEW.RecID in trigger body. (ivan)
- resolved.
- 0002954: [API] [Linux] Database corrupted when one of it files growing
more then 4G (Kirill) - resolved.
- 0002952: [SQL] Problem with JOIN (ivan) - resolved.
- 0002911: [SQL] Subqueries are nullified when a group by clause is used
(ivan) - resolved.
- 0002931: [API] datediff doesn't work (ivan) - resolved.
- 0002932: [SQL] ALTER TABLE DROP CONSTRAINT not produced error if there is
no such index. (ivan) - resolved.
- 0002947: [SQL] NOT works NOT as expected (ivan) - resolved.
- 0002944: [SQL Nodes] Wrong sql-function result if arguments are
aggregative functions which depend on diff. tables. (ivan) - resolved.
- 0002934: [Performance] Mac OS X local DB stops retrieving any data past
3.88GB (ruslan) - resolved.
- 0002922: [Import/Export] Ability to determine in the CSV file keyword NULL
as NULL-value (ivan) - resolved.
- 0002920: [Join of Tables] Outer join on more than two tables may apply
"from" condition to join result instead of use it as "before-join" filter.
(ivan) - resolved.
- 0002919: [Join of Tables] Left outer join produces inner join result in
some cases. (ivan) - resolved.
- 0002905: [SQL] Speed of complex query very bad again (ruslan) - resolved.
- 0002796: [SQL] Predicate in join clause should be applied strictly before
join. (ivan) - resolved.

V4CC - 3.5.2
============
- 0002946: [Examples] Some targets of example project fail on plist file
(ruslan) - resolved.
- 0002945: [Examples] Tutorial Example do not links because of missing ICU
dlls. (ruslan) - resolved.

V4MD - 3.5.2
============
- 0002902: [Other] encoding problem with 3.5 (Kirill) - resolved.

V4RB - 3.5.2
============
- 0002825: [Docs] Documentation for DataBaseInfo is missing (user25) -
resolved.
- 0002948: [Examples] MultiWindow example is non-functional in many ways
(Kirill) - resolved.
- 0002993: [RBDB API] Can't add a column into existing table. (Kirill) -
resolved.
- 0002992: [RBDB API] Field property "Type" is always showed as "Unknown"
(Kirill) - resolved.
- 0002991: [RBDB API] Field property "Length" is never shows in the schema
of database (Kirill) - resolved.
- 0002987: [RBDB API] Opening database from the "Project Editor" will
produce a crash. (Kirill) - resolved.
- 0002984: [RBDB API] [RBDB] RecordSet.ColumnType( num ) do not return
current type of field (Kirill) - resolved.
- 0002831: [RBDB API] vrbdatabase class rejects datevalue (Kirill) -
resolved.
- 0002558: [API] Valentina.EscapeString crashes on Vista OS (Kirill) -
resolved.
- 0002943: [NEW] Methods to support SQL binding with BLOB values (ivan) -
resolved.
- 0002937: [SQL] Inserting data with bound parameters in SQL not working
with binary data. (ivan) - resolved.

V4REV - 3.5.2
=============
- 0002973: [API] Using of Valentina.EscapeString() in rare instances can
reduce to crash (Kirill) - resolved.

VCOM - 3.5.2
============
- 0003012: [API] [NEW] Valentina.ErrNumber and Valentina.ErrString
properties. (Kirill) - resolved.
- 0002982: [API] Diagnose crashes application (Kirill) - resolved.
- 0002974: [API] Using of Valentina.EscapeString() reduce to memory leak.
(Kirill) - resolved.
- 0002936: [SQL] Saving a ByteArray as a BLOB fails (Kirill) - resolved.

VNET - 3.5.2
============
- 0003001: [Examples] Examples and tutorials do not work into the x64 OS
after they was compiled. (Kirill) - resolved.
- 0003005: [Installation] Ability to install VNET.dll in the Global Assembly
Cache (Kirill) - resolved.
- 0002869: [Pictures] Methods VPicture.WritePictureAs() and
VPicture.ReadPicture() do not free memory (OS Windows) (Kirill) - resolved.
- 0002972: [API] Using of Valentina.EscapeString() in rare instances can
reduce to crash (Kirill) - resolved.

VPHP - 3.5.2
============
- 0002942: [Localization] After changing VPHP and VServer to 3.5, umlauts
and text fields are wrong (Kirill) - resolved.
- 0002926: [API] valentina_errno() and valentina_error() are not clean self
status after successfull execute (Kirill) - resolved.

VServer - 3.5.2
===============
- 0002986: [SQL] Deleting the first record added to a table containing a
BLOB/Picture field doesn't work correctly (ruslan) - resolved.
- 0002988: [Data Editor] After some operations against picture field it
shows only last RecID record (client-server mode). (igor_nikita) - resolved.
- 0002989: [Encryption] Encrypted table or field can be viewed by another
client without a key check in some circumstances. (ivan) - resolved.
- 0002958: [Import/Export] import routine should report the number of
records imported (igor_nikita) - resolved.
- 0002960: [API] A changed picture was reread from the cache and not from
the DB (ivan) - resolved.
- 0002935: [API] Concurrent insert of BLOBs (API way) crashes table (ivan) -
resolved.
- 0002933: [Performance] Linux VServer can't write past 2GB boundry on DB
Files (Kirill) - resolved.
- 0002917: [Other] VServer does not honor datesetting of database (ivan) -
resolved.

VStudio - 3.5.2
===============
- 0003010: [Data Editor] When add first record and RecId column is shown,
RecId for this first added record shown as 0 (igor_nikita) - resolved.
- 0003009: [Data Editor Related] After create ObjectrPtr field we cannot use
this link immediately in Data Editor (igor_nikita) - resolved.
- 0003008: [Other] On Mac OSX removed unused entry from list of windows in
"Window" menu with application name (igor_nikita) - resolved.
- 0002830: [Client] [VStudio Mac Os X] Drag and drop of DB on VStudio icon
or icon in the dock doesn't open the DB anymore on lates betas (igor_nikita)
- resolved.
- 0002807: [Contextual Menu] Ability to throw database from VServer.
(igor_nikita) - resolved.
- 0002798: [Users/Groups] Wrong Storage type of database for non admin user.
(igor_nikita) - resolved.
- 0003003: [SQL] b10 Query gives kernel error then continues (igor_nikita) -
resolved.
- 0002828: [Import/Export] Importing data impossible with VStudio 3.5b6
(igor_nikita) - resolved.
- 0002908: [Diagrams] Diagrams need a way to individually adjust column
widths (igor_nikita) - resolved.
- 0002916: [SQL Editor] Trying to close a local opened db reproducible crash
VStudio (ruslan) - resolved.
- 0002998: [Other] b10: VStudio export from sqlselect query does NOT work
(igor_nikita) - resolved.
- 0002800: [VServer Connection] Connection to the VServer closed when press
"Cancel" in the new database dialog. (igor_nikita) - resolved.
- 0002794: [Schema Editor] When "Query Result" of a table is open, attempt
to delete table reduce to error and not delete the table in the db.
(igor_nikita) - resolved.
- 0002994: [Dialogs] V3 Field creation dialog: after click on radio buttons
( method, default ) choice with field types clear selection (igor_nikita) -
resolved.
- 0002930: [Feature] Save Password (igor_nikita) - resolved.
- 0002608: [Schema Editor - Column View] When scrolling with scrollwheel the
scrollbar doesn't syncronize (igor_nikita) - resolved.
- 0002645: [SQL Builder] Graphical glitches when scrolling (igor_nikita) -
resolved.
- 0002975: [Property Inspector] Unable to turn off "indexed" field property
in some circumstances. (ivan) - resolved.
- 0002970: [Import/Export] Asserts and table_not_found exception generated
on import into table. (igor_nikita) - resolved.
- 0002971: [Dialogs] It seems better ask user for choosing diagnose-file
location instead of hard-code it. (igor_nikita) - resolved.
- 0002980: [SQL Builder] [NEW] Now VStudio highlight SQL keywords for
current query text in SQL Builder (igor_nikita) - resolved.
- 0002979: [Contextual Menu] "Open Query Builder" has changed to "Open SQL
Builder" for database context menu (igor_nikita) - resolved.
- 0002978: [SQL Builder] SQL Builder now use native colors on MacOS
(igor_nikita) - resolved.
- 0002977: [SQL Builder] Sometime we can get a crash when delete link
(igor_nikita) - resolved.
- 0002976: [Schema Editor - Column View] [NEW] Now VStudio highlight SQL
keywords for views, triigers etc text in column view (igor_nikita) -
resolved.
- 0002840: [Import/Export] V STUDIO CRASHS WHEN TRYING TO IMPORT XML FILE
(ivan) - resolved.
- 0002964: [Data Editor] Wrong record updated sometimes. (igor_nikita) -
resolved.
- 0002963: [Application Menu] Edit->Select All doesn't work for Schema
Editor (igor_nikita) - resolved.
- 0002542: [Sources] ChidCount() replace on HasChilds() (igor_nikita) -
resolved.
- 0002793: [SQL] Results in the "Query Result" changed by mouse click on it.
(igor_nikita) - resolved.
- 0001968: [Import/Export] Export results of SQL Query to text file
(igor_nikita) - resolved.
- 0002938: [Property Inspector] Wrong table size if table bigger than 2G.
(igor_nikita) - resolved.
- 0002950: [SQL Editor] autocompletion won't work if next key pressed is
Enter/Return (igor_nikita) - resolved.
- 0002957: [Schema Editor] Local connection is not shown if VStudio on init
try open only one local DB that was removed (igor_nikita) - resolved.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]