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]
