On 11/1/2010 3:42 PM, Carel Teijgeler wrote:
I have to disagree on that. You can do this with one F-spec declaration
globally.

Before calling the recursive (sub)procedure save the key values. After
returning do a SETGT on the saved key.

Opening a cursor in each recursive (sub)procedure is creating a new result
set. On a table with many records it can be taken some time, resulting in
bad performance.

With regards,
Carel Teijgeler

Hee hee!

Great minds, Carel.

Joe

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.