need help with Clone

[Ruslan Zasukhin]

On 3/19/08 12:57 AM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com> wrote:

>> I used Valentina Studio to clone a database (Mac OSX version).
> 
>> VStudio changed the date format to DDMMYYYY from its original YYYYMMDD
>> format.  I try to change it back in VStudio but it does not take affect.
> 
>> Is there any way to change the date format after the database has been
>> created?  Everything I try is not working...   I messed up and did not
>> keep backups...
> 
>> Can you use the various date format setting commands upon opening the
>> database, or is that only before / upon creation.
> 
>> I also tried dumping and pulling the data into a new database created
>> with correct date format, but when I do SQL import crashes VStudio.
> 
>> How come VStudio changed the format?
> 
>> Any fix ideas?
> 
> Currently - I suppose starting from some 3.5.2 version
> 
> * DateTime settings ARE NOT stored to disk files anymore.
>     So it is wrong to expect that db restores date/time format from
>     prev. setting.
>     If you omit date-time format properties set the SYSTEM format will be used
>     instead.
>     (You should specify it each time for db right after open.)
> 
>     Particularly vStudio skip format set - so system one is applied.
> 
> * All you will need to fix - is add
> 
>    SET PROPERTY DateTimeFormat OF DATABASE to 'kYMD'
>    set property DateSeparator OF DATABASE TO '-';

Add this into your RB code right after db.open().

Again, like Ivan points, now DateTimeFormat is RUNTIME value.
It is not stored to disk.

This was changed to allow VSERVER work with different clients
    from Japan, Russia and USA and each have own date format


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