Re: How do I find absolute position in a table

Adrian wrote : > I want to scroll throuch an informix table starting at a user defined > point. Can anyone help. > > Cannot use rowid as the table is sorted by one of three rows prior to > the search. ------------ Try to use a scroll cursor on this table, then with the fetch absolute command you will be able to start at any user defined point. Hope this help Fred +------------------------------------+--------------------------+ | Frederic BOUQUET | Phone : (33) 77 93 57 46 | | Cornut Informatique | Fax : (33) 77 92 51 39 | | 24, rue de la Telematique - BP 702 | AppleLink : CORNUT.INF | | 42950 St Etienne cedex 9 FRANCE | Compuserve: 100303,1061 | | frederic_bouquet@ascus.com | | +------------------------------------+--------------------------+ -------------------------------------------------------------------------- U.S.A. | AppleLink : ASCUS About Software Corporation | eWorld : ASC.US 10601, South De Anza Blvd. |America Online : ASCUS Suite 105 | Compuserve : 73243,36 Cupertino, CA 95014 | Internet : info@ascus.com general phone : (408) 725 4242 | Anonymous FTP : ftp.ascus.com sales : (800) 55 SOFTWARE | ARA Server : (408) 725 4250 tech support : (408) 725 4240 |FirstClass BBS : (408) 725 4252 fax : (408) 725 4243 | bbs.ascus.com -------------------------------------------------------------------------- FRANCE | AppleLink : ADV.SOFT ASC | Compuserve : 76034,2123 9551, route de St Laurent du Var | Internet : euro_info@ascus.com F-06610 La Gaude | Anonymous FTP : ftp.ascus.com general phone : +33 93 24 76 00 | ARA Server : +33 93 24 76 03 fax : +33 93 24 76 06 |FirstClass BBS : +33 93 24 76 13 --------------------------------------------------------------------------