Now you should not synch vClient API calls  - vClient do it self and you are free to access and operates with vClient’s remote objects from different threads similiangly. In particular, vStudio operates with remote connections via multiple threads  and it was a source of some glitches and unexpected errors especially with a long queries.  Now [...]

ObjectPtr field contains RecID values of some “target” table. If you need to change ObjectPtr in order to point another table those values are not valid anymore – so default behavior is to nullify them.  But sometime it looks to be too strong. For instance - changing  field or link name or on-delete policy should not cause [...]

Paradigma Software is a truly international company, but it also has strong roots in the great Northwest – the Silicon Forest area including the greater Portland area.  Paradigma Software is proud to be a sponsor for Portland Code Camp 2010.

Erne have report bug http://www.valentina-db.com/bt/view.php?id=4885 in Valentina for Cocoa (V4CC). Problem was that VField.value in ObjC implemented as pair of methods (in other Valentina ADKs, e.g. Valentina for REALbasic it is a true property of class). So if to override this pair in the sub-classes then always will be called overridden methods. To resolve issue, we have [...]

Ivan have implement today MD5() function, which can be used in EXPRESSION of Valentina SQL. Bart have asked this function to be able produce UNIQUE INDEX for strings/texts bigger of 128 chars. This limit comes from fact that indexes of Valentina use pascal-like storage format for strings, e.g. 256 bytes maximum, 128 for UTF16.

44 Seconds for that 1023 tables DB still not looks good for me, and I have continue search for ways to improve it. And after one more day of work time have go down to 34 sec from original 54. And this new optimization is even better! It is also made on INDEX-level and affects [...]

One developer have produce Valentina database with 1023 tables. And note us that it takes long time to open it. On my macbook it have take 54 sec. After some profiling and optimization, time is now 44 sec. Nice thing here is that optimization was made on INDEX-level for functions that return ArraySets. This means [...]

Thanks to new SHOW PROCEDURES ALL, we was able implement Function Browser in the SQL Editor of Valentina Studio. This Function Browser contains a list of system function and used defined stored procedures and functions listed by categories such as:

We have added the left side bar into Schema Editor. It looks similar to what have OS X Finder and Windows 7. This sidebar allows you easy jump to the most common and/or recent places of your job. For example, you can by single click open recent database or connection or your bookmark to a [...]

We have added to SQL Editor of Valentina Studio great new feature: now you can get much more rich output from an SQL command. And this output is separated into 4 tab panels at bottom of Editor.