Re: tracking changes on a table through ODBC application

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 17 Jul 2003 20:13:26 +0200
Message-ID: <3ppdhvs63utvdicrcm6g13vcldqj30cdbd@4ax.com>

On 17 Jul 2003 08:45:44 -0700, stephen.howard_at_us.pwcglobal.com (Steve Howard) wrote:

>> My question is weather it is possible to keep the resultset open and
>> see changes from other users in that result set. Can this be done
>> using a cursor?
>>
>> Thanks
>
>It has been a four or five years since I programmed any ADO, but IIRC,
>you can open a cursor that allows you to see changes made by other
>users. I can't remember the mode of it off-hand, but a search in the
>ADO documentation should turn it up.
>
>Regards,
>
>Steve

We are talking Oracle here. Oracle doesn't have 'dirty reads' like the Mickeysoft toys do.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 17 2003 - 13:13:26 CDT