Thread: FETCH and MOVE
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.
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>