Database Record lock

[Hind]

Hi,

I need to select a record from a table on an oracle database, manipulate it and update it to the database. But after executing my select statement i want to lock that record so that nobody can read it or write to it until i finish my update.i'm using ADO.
Does anybody know what the best way to do this?
Thank you

Hind

 

[MikeLacey]

I don't know anything about ADO -- but....

If you can run an sql statement through ADO then try this

Select [column_list] For Update
From

Where [where_clause] [sig][/sig]