need help with Clone

[Beatrix Willius]

Hello,

have had the pleasure of this, too, last weekend. Definitively, the  
system format was NOT used for the cloned database. When using the  
clone in my application everything worked okay, just not VStudio.  
Doesn't this look like a bug in VStudio?

Using VStudio 3.5.2 on G5 with 10.4.7.

Am 18.03.2008 um 23:57 schrieb Ivan Smahin:

> Hello Dave,
>
> Wednesday, March 19, 2008, 12:33:22 AM, you 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 '-';





Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: archive, clean and search email
http://www.beatrixwillius.de
Fractals, 3d landscapes etc.