No optimistic locking with VB5 via RDO in Informix 7.11

Posted in 1998

Topics: Connectivity: ODBC / JDBC / .NET

pedrocr@dicoruna.es — Tue, 28 Apr 1998 05:25:40 -0600 — source: Informix-list mailing list archive (1991-1998)

Hi all, We're working with VB5 Enterprise (SP3), RDO, Informix OnLine 7.11 on AIX 4.1, ODBC drivers version 3.0.23.1 and the last one of Intersolv driver 3.50.3.69. When we use the optimistic lock we get this error message -Err.Number: 40002 err.Description: 01S03 [Microsoft] [ODBC Cursor Library] No rows updated or deleted -Rdo Errors Collection rdoerror.descripcion: 01S03 ... rdoerror.number: 0 rdoerror.state: 01S03 rdoerror.retcode: 1 After that we do a Recordset.move 0 but the cursor it's not refreshing, it gets the previous image and not the real value of the record and update it's not possible. We test other ODBC's drivers like SCO SQLRetriever and some versions of Intersolv but always the same. Thanks and bests regards Pedro Castelo & Chema Alvarez Diputacion de A Coru'a Spain pedrocr@dicoruna.es -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading