Hi John,

Thanks for looking into my problem. When I use SQLCOLUMN function Foxpro thinks it is T ( datetime ) type field which OK. If i try using date() i am getting the same ODBC OLEDB Notes error not a valid data or date, time field type.

I can not use remote views or SQLPASS to update data on the backend. This particular table doesn't have a unique key setup so anyhow i gave up on using remote views and went with ADO 2.5.

Regarding ODBC, Notes has only 1 driver which is NotesSQL ODBC driver ver 3.0 which i've downloaded from Lotus web site.

Regards

Dejan