>> You can normally quite happily SELECT away into the same cursor repeatedly without closing it first. There's something else happening here. Try adding 'nofilter' to the Select statement.<<
Correct on the repeated SELECTs Alan, I was not clear on my post. What I was thinking and not writing (it was late) was that the alias is probably already in use for an open table. Selecting into the tmp alias when it is already in use somewhere else is going to throw the "Alias name is already in use" error. So closing the alias before the select should solve the problem (and quite possibly create another). Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Alan Bourke Sent: Friday, June 18, 2010 04:01 AM To: [email protected] Subject: RE: VFP9 - error On Thu, 17 Jun 2010 22:34 -0400, "Rick Schummer" <[email protected]> wrote: > Correct, you have to either close the cursor to reselect into the same > alias, or you have to pick a different alias. > > USE IN (SELECT("tmp")) > > lookprev=client > > SELECT client,date,sum(ttlamount-disc+gst) as sumttl, invnum FROM winhst > WHERE client=lookprev AND trantype='I' GROUP BY invnum ORDER BY date INTO > CURSOR tmp You can normally quite happily SELECT away into the same cursor repeatedly without closing it first. There's something else happening here. Try adding 'nofilter' to the Select statement. -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/000001cb0eee$79ce0020$6d6a00...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
