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

[Damon Pillinger]

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.

2.
When you open a database from the RB window 
i.e. menu File/ Add Data Source/ New Valentina You create a new table
i.e. MyData
Then create a field called 'f4' of type 'datetime'
It saves but when you go back in it displays as type 'Unknown'

3.
When you open a database from the RB window 
i.e. menu File/ Add Data Source/ New Valentina You create a new table
i.e. MyData
Then create a field called 'f5' of type 'binary'
And try to save it, you an error 'Unexpected token: binary'

4.
When you open a database from the RB window 
i.e. menu File/ Add Data Source/ New Valentina You create a new table
i.e. MyData
Then create a field called 'f6' of type 'picture'
And try to save it, you an error 'expecting "(", found ")"'


Tested on fc7 and release

Thanks
Damon