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
_______________________________________________
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/[email protected]
** 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.
