Row-ID

From: Sven Kunze <svenkunze_at_aol.com>
Date: 1998/03/17
Message-ID: <1998031723050800.SAA20795@ladder01.news.aol.com>#1/1

I´m looking for a way, that the MS yet engine can update / delete via ODBC.

The yet-engine query the complete row again before update, to see, if an other user has changed the data. therefore it uses all columns in the where clause, causing an error if there is a NULL-value.

somebody tells me, that with SQL server and timestamp columns, the yet engine uses this row automaticly for change-check.

so im looking for something like that in oracle.

is the row-id something like that ?
i created a row-id column, but there are now values in it inserting a new row.

Please help.
Sven Kunze.

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) and ODBC 8.0.3.0.0 32-Bit. Received on Tue Mar 17 1998 - 00:00:00 CST