There's a fair amount of old R:Base code out there that declares (or sets) a cursor just to check for the existence of any data matching a condition.
I think there were some early versions of SQL that had no equivalent of SELECT ... INTO VAR, only FETCH, and some programmers moving to R:Base preserved their old habits, even if it used a lot more resources than necessary. (DECLARE; OPEN; FETCH; DROP rather than just SELECT COUNT (*) INTO) Bill On Fri, 31 Jan 2003 15:06:56 -0500, Albert Berry wrote: >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 ... >
