locate methods for cursor

[Ruslan Zasukhin]

On 6/21/06 1:04 PM, "Lilu" <gogaworm at tut.by> wrote:

> Hi!
> I select data into cursor. In the data selected I've got some primary key.

> Using that key I want to be able to locate to the record in the cursor
> that has the value specified as a key. For example, my key field is
> "TEST_ID". I want to move to a record that has a value 3 of field
> "TEST_ID" and to delete or udate that record. How can I do it? Thanx.

As in any SQL database:

    DELETE ...... WHERE TEST_ID = 3

    UPDATE ...... WHERE TEST_ID = 3


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]