Thank you Bill, you're a real knight in shining armor! Seemed perfectly logical to me at the time I created the file, but I sure could not have told you why. Well, now everybody knows I'm from the 'old' school... But, I'm having a lot of fun learning from my mistakes. ~Claudine :) :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Bill Downall Sent: Friday, January 31, 2003 2:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: OPEN cursor RESET 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 ... >
