RB WIN Valentina - date/datetime/binary/picture from RB

[Damon Pillinger]

HI Ruslan

When I use

dataControl1.database.sqlExecute ("SET PROPERTY DateTimeFormat of
DATABASE TO 'kYMD' ")

if dataControl1.database.error then msgbox
dataControl1.database.errorMessage
  
I get the msgbox 'Invalid parameter value'

Database is called ValentinaDB
Table is called test
Field is called f4 of type Date

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: Tuesday, 21 June 2005 9:04 AM
To: valentina at lists.macserve.net
Subject: Re: RB WIN Valentina - date/datetime/binary/picture from RB

On 6/21/05 1:58 AM, "Damon Pillinger" <daisychain at iinet.net.au> wrote:

> 1.
> If you create a table with a field 'f3' of type 'date', then use a
> datacontrol to update the value which is bound to an editfield with
the
> value "2005-06-20", as per the realbasic instructions, the value is
not
> saved in Valentina. Nor is it displayed in the RB database View table
> contents window. The value saved is 0-00-00.
> The exact same method works for both realbasic database and SQLite
> database.

I think this is because your db.DateTimeFormat is not YMD.

In the latest fc7 or fc8 build you can executeSql()

    "SET PROPERTY DateTimeFormat of DATABASE TO 'kYMD'"


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