Setting system date to yyyy-mm-dd permanently

[william humphrey]

Should this property always be set when you open the database, everytime?
I haven't seen any examples of anyone doing this in a Runtime Revolution use
of Valentina and my present use of it on the Intel platform seems to be
fine. But the lack of examples seen is not anything new.

Would the following be corect?

In Runtime Revolution would you do:


*on** mouseUp pMouseBtnNo*

*  **get** valentina_Init( 10 * 1024 *
1024,"extremely_way_long_serial_number",,)*

*  DatabaseOpen*

*end mouseUp*

*
*

*on DatabaseOpen*

*
*

*  put VDatabase_Constructor() into gDatabase*

*  -- Build db full path near to stack:*

*  get the effective filename of this stack*

*  set the itemdel to slash*

*  put the (item 1 to -2 of it) & slash & "MyDatabase.vdb" into dbPath*

*  get VDatabase_Open( gDatabase, dbPAth )*

*  -- Put the make sure system date is set stuff here?*

*  VDatabase_DateFormat( **gDatabase**,"kYMD" ) -- specifies the format of
date.*

*  VDatabase_DateSep( **gDatabase**f, "-" ) -- separator for date*

*  -- Always set the date format everytime you open the database?*

*end DatabaseOpen*


Thanks for your help...


Bill


On Tue, Jul 22, 2008 at 2:17 PM, Joseph Morgan <joseph at checkos.com> wrote:

> I thought you have to set the date for the database each time you open
> it no matter what. I always use yyyy-mm-dd. But no matter the
> platform, the date always reverts to something else. This is the case
> in vstudio and outside of vstudio (ie. realbasic or perhaps runrev). I
> don't think this is a bug as I am pretty sure I recall Ruslan stating
> that this was the intended behavior. I always run the following sql
> command on any database right after opening it and it always works for
> me:
>
> SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO
> 'kYMD','-',':';
>
> You may want to check out the wiki for more info but I think kMDY
> would give you the mm/dd/yy dates then set your date separator and
> that should work.
>
>
> Joseph
>
> On Jul 22, 2008, at 12:17 PM, william humphrey wrote:
>
> > To add to system date and Valentina Studio date "funkiness". On an
> > Intel Mac which has the U.S. system date (no attempt to set a custom
> > system date to match YYYY-MM-DD there is no problem with the
> > settings in Valentina Studio and the settings in the database
> > changing by themselves back to mm/dd/yy.
> >
> > But it appears to happen on the older G4 Mac even to a database that
> > is moved back and forth and used in RunRev without opening it in
> > vStudio. There is no way I can report this to Mantis yet as I
> > haven't figured out exactly what is causing the database to change
> > the date settings on their own back to mm/dd/yy but it is an
> > important bug as all sorts of crashes result when the data in the
> > date fields are formated yyyy-mm-dd and the database is expecting
> > them to be mm/dd/yy.
> >
> > Has anyone else encountered this date setting weirdness? For me it
> > is limited to the G4 mac running OS 10.4 and does not happen on the
> > Intel Mac running OS 10.5
> > _______________________________________________
> > Valentina-studio mailing list
> > Valentina-studio at lists.macserve.net
> > http://lists.macserve.net/mailman/listinfo/valentina-studio
>
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-studio/attachments/20080722/f5d900d2/attachment-0001.html