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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only