NotesSQL Update Problem

HCL Domino Domino Forum
1

I have a NotesSQL ODBC connection to a Notes DB. I want to update a field in the Table (Form).

I use my Delphi ADO tool to update a record using the Table.edit; TableMyField.asFloat=123; Table.post;

My ADO connection returns “Row cannot be located for updating. Some values may have been changed since it was last read”.

If I use SQL (UPDATE MyTable SET MyField = 123 WHERE NiteUNID = ‘XXXXXX’) the call does not return and the nsqle32.exe is working overtime.

Any thoughts?? I can provide a copy of the database.

John

2

Subject: NotesSQL Update Problem

I realize that this does not answer your question, but it’s another option to consider:

If you are using Delphi 8, which has .NET support, you can use Proposion N2N (a pure managed ADO.NET data provider) to access Notes/Domino data and services. See Products A-Z.