Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ODBC-update problem with Jet-Engine and null values

ODBC-update problem with Jet-Engine and null values

From: Loy&Hutz <loyhutz_at_freiburg.netsurf.de>
Date: 1998/03/10
Message-ID: <01bd4c30$2483cac0$60edc3c2@kom>#1/1

My problem again, but now more specific:

I get the error message 'data changed by another user' (visual basic-error 3197) when I try to update or delete a row in oracle tables (primary key exists, all columns are character-type) with the .update or .delete method in vb4 (16-bit) or directly in a linked access (2.0 / 97) table .

After searching a long time for the reason, now I have detected following reason:

In the ODBC-trace file I detected, that the Jet-Engine makes the update / delete with a where clause, where all columns are listed, although the engine knows the primaery key !!!

"UPDATE TEST1.T_STATUS SET F1=? WHERE F2 = ? AND F1 = ? AND F3 = ?" Also I recognized, that this statement do not work, when the Parameter (?) is Null. And this is my problem !!! The server answers correctly "no data found", but the jet-engine thinks "data are changed by another user".

But can this be true ?! There must be a trick - its a joke, isnt it ?

Sure, I can use directly my own SQL-Statements, but I have to migrate an existing big program and don“t like to change to much.

Any idea / help ? This would be great !!!!

I use ORACLE 8.0.3.0.0 on NT Server 4.0 (SP3), TCP/IP, and Client NT 4.0 (SP3) with Access 2.0 / 97 / Visual Basic 4.0 *(16-Bit) with ODBC 8.0.3.0.0 32-Bit. Received on Tue Mar 10 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US