Emmitt - would not SELECT ... WHERE COUNT = LAST not work for this?
Emmitt Dove <[EMAIL PROTECTED]> wrote: > >Albert, > >There are quite good uses for cursors without loops. �One place we use them >is trying to find the last value for invoice number in an application where >the invoice number is permanently bound within a 10000-number >range. �(Invoice number hits 19,999 for example and then reverts to >10,000.) �In this case a SCROLL cursor with a FETCH LAST works quite nicely >where SELECT (MAX(...)) would not. > >>Do you know, I have never used a cursor without a loop? I only use cursors >>to return individual items from a set of items one at a time. In other >>cases I SELECT ... INTO ... FROM ... WHERE ... >> > >Emmitt Dove >Manager, DairyPak Business Systems >Blue Ridge Paper Products, Inc. >40 Lindeman Drive >Trumbull, CT �06611 >(203) 673-2231 >[EMAIL PROTECTED] >[EMAIL PROTECTED] > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
