A few things...

Why is there no PK for the notes table? Or, are you manufacturing a de facto key through multiple columns?

My suggestion is to create a test table in notes with a PK so that you could use a remote view to see if the updates will work. If the updates do work, then I suggest checking other sources to see if there are any known problems with Notes and OLE/DB.

Other than that, I am tapped out as far as suggestions go...


>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