Re: UPDATE at current cursor position using OCI

From: Gert Rijs <gem_at_wirehub.nl>
Date: 1997/02/20
Message-ID: <01bc1eeb$ea0b7ae0$525fa5c2@gertrijs>#1/1

PaulJ3 <paulj3_at_aol.com> wrote in article <19970219211100.QAA10871_at_ladder02.news.aol.com>...
> Is it possible to do an update at the current cursor position using OCI?
> I need to update a record, I know all the columns and values, but do not
> know the key fields.

change your select to include the rowid field and do an 'update tab set ... where rowid = :myrowid'
hope this helps,

Gert

-- 
At Home: gem_at_wirehub.nl
At Work: gert.rijs_at_corp.ah.nl

Received on Thu Feb 20 1997 - 00:00:00 CST