Ben, I tend to use OPEN RESET even when I don't need the RESET - this sets the cursor back to the top of the data set.
DECLARE c1 CURSOR FOR SELECT whatever OPEN c1 RESET FETCH c1 INTO a bunch of variables WHILE SQLCODE <> 100 THEN .... Troy Sosamon <[EMAIL PROTECTED]> wrote: >Ben, > >I haven never seen this. Make sure you drop your cursor before you declare it >and then drop it after you are done with it. Maybee the firs one is not >getting dropped causing it to error out in the second one. > >Troy > > >>===== Original Message From [EMAIL PROTECTED] ===== >>Has anyone had experience with two files running one after another and both >files use the Declare Cursor and for some reason I have to run the second file >twice to get the Declare Cursor and other commands in the file to work. Any >answers? >> >>Ben Strickland > >Troy Sosamon >Denver Co >[EMAIL PROTECTED] > > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
