VRB date in datacontrol

[Damon Pillinger]

Hi Ruslan and guys,

Thanks for that

  valdb.sqlExecute ("SET PROPERTY DateFormat OF DATABASE TO 'kYMD'")
  if valdb.error then msgbox valdb.ErrorMessage
  
  valdb.sqlExecute ("SET PROPERTY DateSeparator OF DATABASE TO '-' ")
  if valdb.error then msgbox valdb.ErrorMessage
  
This now does not have any errors; however, the date is still 0-00-00.

Is there anything else you have to set for Dates?

I remember reading something about 2005 -> 05 or something.
editfield4.text="2005-12-15"
but I tried
editfield4.text="05-12-15"
and it still gave 0-00-00

Anything else I can try?

Thanks
Best Regards

Damon L. Pillinger
Jensen 2005 by Daisychain
www.daisychain.no-ip.biz
Phone : 03 9532 1220
Fax : 03 9532 1280


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Wednesday, 6 July 2005 12:03 AM
To: valentina at lists.macserve.net
Subject: Re: VRB date in datacontrol

On 7/5/05 10:50 AM, "Damon Pillinger" <daisychain at iinet.net.au> wrote:

> Hi Ruslan,
> 
> Have had some success, the first execute below is fine and does not
cause a
> error but when I try to set the separator in the second execute
> 
>   valdb.sqlExecute ("SET PROPERTY DateFormat OF DATABASE TO 'kYMD' ")
>   if valdb.error then msgbox valdb.ErrorMessage
>   
>   valdb.sqlExecute ("SET PROPERTY DateSep OF DATABASE TO '-' ")
>   if valdb.error then msgbox valdb.ErrorMessage
>   
> the error "Invalid Parameter Value" is returned and the date is
0-00-00

DateSeparator

We need ship new VSQL.pdf


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


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina