Re: FETCH and MOVE

No, there is no way to do what you want.

If you only want to go to John, why not add the where clause?

Dave
On Wed, 2003-08-20 at 08:18, Waldomiro wrote:
> Hello,
>
> In a table indexed by name, I created a cursor like this :
>
> BEGIN TRANSACTION;
>
> DECLARE cursor1 FOR SELECT NAME FROM AUTHORS ORDER BY NAME;
>
> What should I do when I want to move to author wich name is John ?
>
> Are there anyway to Move with Strings ?
>
> I don't know how much I need to move the cursor to John.
>
> Are there any function that show me how much I need to move the cursor
> to John ?
>
> Can anybody help me ?
>
> Thanks.
>
> Waldomiro C Neto.
> Shx Informática Ltda.
> +55 (11) 5581-1551
> www.shx.com.br
> wmiro@shx.com.br
--
Dave Cramer <Dave@micro-automation.net>