Small parts left out here Ken:
1. Create the cursor with SQL. Don't forget the NOFILTER clause! This forces
the VFP-SQL engine to actually create the cursor in a temp-file. When the
query is fully optimizable fox will otherwise pass you a reference to the
actual source table with a SET FILTER clause in effect. This will cause some
problems when modifying or deleting records and you're not expecting you're
modifying the source table.
2. USE DBF('YourCursorName') again alias <MyData> IN 0Regards, Sietse > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kenneth > Kixmoeller/fh > Sent: maandag 16 oktober 2006 21:45 > To: [EMAIL PROTECTED] > Subject: Re: System not deleting files > > > On Oct 16, 2006, at 2:20 PM, John J. Mihaljevic wrote: > > > I'm on 6.0 right now. I need to get into 9.0, but wanna get this > > system stabilized first. > > In that case: > 1. create the cursor with SQL > 2. USE DBF('YourCursorName') again alias <MyData> > 3. Select <MyData> > 4. Manipulate at will > > Ken > > [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 ** 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.
