VRB date in datacontrol

[Damon Pillinger]

PS
If I use

  valdb.sqlExecute ("SET PROPERTY DateTimeFormat of Database TO 'kYMD'")
  if valdb.error then msgbox valdb.ErrorMessage
  
the error "Invalid Parameter Value" is returned

V4RB_204fc12_win

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 Damon
Pillinger
Sent: Tuesday, 5 July 2005 5:19 PM
To: valentina at lists.macserve.net
Subject: VRB date in datacontrol

Hi Guys,
 
If you make a datacontrol and have an editfield bound to a field of type
"date" and then add a record the date returned is always
 
0-00-00
 
instead of
 
editfield4.text="2005-06-20"
 
There is no way to set the YMD format or the separator that I can see
for a RB datacontrol, is it a bug or am I not doing it right.
 
When I do the same thing using RB database it returns the correct date.
Also when I change to field type "datetime" it returns 0-00-00 00:00:00
 
I use the datacontrol because my app already has this in it and it is
too difficult to remove.
 
Thanks
 
Best Regards
 
Damon L. Pillinger
Jensen 2005 by Daisychain
www.daisychain.no-ip.biz
Phone : 03 9532 1220
Fax : 03 9532 1280
 
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina