Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detecting Dirty Reads in Oracle with Passthrough
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Detecting Dirty Reads in Oracle with Passthrough
Miscellaneous
Thread ID:
00408908
Message ID:
00408908
Views:
33
Hi,

The goal is simple, as the title says...here is a bit:

sqlexec(lnConn, 'update table ser value = xx where key_fld = 42 and touch_count = 23')

(touch_count is updated on every insert by a trigger, thus acts as a timestamp).

The question is; how do I find out if the update succeeded? If SQL Server I can just do a 'sqlexec(lnConn, "select @@rowcount")' to find out how many rows were updated - can anybody point me in the right direction for Oracle?

Joe G.
Joe Gotthelf
Filters Are EVIL.
Reply
Map
View

Click here to load this message in the networking platform