Setting system date to yyyy-mm-dd permanently

william humphrey shoreagent at gmail.com
Wed Jul 23 10:48:47 CDT 2008


I can do this:
>>
>
VDatabase_SqlExecute(

dbRef,

inStrCommand,

inBinds = nil )


I'll try this next but still if someone would tell me how to get the other
functions working I'd appreciate it  :)

VDatabase_SqlExecute(
dbRef,"SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE
TO 'kYMD','-',':'")


> Is there a way for you to send an sql command to the the database similar
>> to how you send a select statement?
>>
>> in realbasic I do the following:
>>
>> myVDatabase.SQLExecute("SET PROPERTY
>> DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO 'kYMD','-',':'")
>>
>>
>>
>> Joseph
>>
>> On Jul 23, 2008, at 6:26 AM, william humphrey wrote:
>>
>> Well I just tried
>> *  VDatabase_DateFormat( **gDatabase**,"kYMD" ) -- specifies the format
>> of date.*
>> *  VDatabase_DateSep( **gDatabase**f, "-" ) -- separator for date*
>> *
>> *
>> *in RunRev and I get the error message "can't find handler" which means
>> that this must have been changed to something else but that change isn't in
>> the V4REV _reference*
>> *
>> *
>> *Does anyone know what it should be?*
>>  *
>> *
>> *Thanks*
>> *
>> *
>> *Bill*
>>
>>
>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina-studio/attachments/20080723/767f1840/attachment.html 


More information about the Valentina-studio mailing list