Kbase P22638: Cannot update twice the same record using ADO Data Control
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2003 |
|
Status: Unverified
SYMPTOM(s):
Cannot update twice the same record
No rows were affected by UPDATE/DELETE WHERE CURRENT OF cursor emulation
Using ADO Data Control
Using SQL-92
The CursorType property is set to 2 - adOpenDynamic
The CursorType property is set to 3 - adOpenStatic
CAUSE:
The ODBC driver does not support those cursor types with the Micorosft ADO Data Control.
FIX:
Use the property 1 - adOpenKeyset instead.