Re: prev/next without select *

Marcel (atlasoft@pi.net) wrote: : I work with a large database. When I do a Select resulting in 1 record, is : it possible to do a next or previous in any order without selecting the : whole database ? I don't want to post a SELECT of all the records first : and then skip within the selection. SELECT * takes to much time. : For example: : Is there a way to post a select with an expression and than only receive : the first record matching the expression? To answer this question, use the statements: DECLARE cursor-name CURSOR FOR select-statement FETCH cursor-name INTO variable-list This will put the first record into your variable-list. --- Travis Rayhons trayhons@dordt.edu Dordt College Computer Services (712) 722-6299 (w) Programmer/Systems Administrator (712) 722-1412 (h)