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

[Ruslan Zasukhin]

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]