> > SELECT MyOtherCursor
> >
> > APPEND FROM DBF("MyCursor") FOR NOT DELETED("MyCursor")
> >
> > I still get the deleted records from MyCursor in MyOtherCursor. VFP
> > 9 SP 1,
> > Win 2000 Pro
>
> This is "correct" behavior. The reason is that the FOR condition is
>evaluated for each record being appended, but the record pointer in
>MyCursor is not changing. So if you run the APPEND when the current
>record in MyCursor is not deleted, you get *all* the records; if you
>ran the APPEND while the current record in MyCursor is deleted, you
>would get no records.
Thanks, Ed. Not only "correct" but dumb--it implies that no FOR clause
would actually work for APPEND FROM.
So I'll just SELECT the non-deleted records out of the cursor into an
intermediary cursor and APPEND FROM that.
Ken Dibble
www.stic-cil.org
_______________________________________________
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.
