Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting all the records in a view
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00106083
Message ID:
00106148
Views:
25
Paul,

>Is there a good way to delete all the records in a view? I've got a view I use as a temporary place to modify/adjust information that ends up on a report. Once I'm done with the report, I need to delete all of the records so they don't affect the report the next time it's run.
>
> Actually, what I really need is a temporary cursor that is available/modifiable while the business object is instantiated and goes away when it's destroyed. It is, after all, only needed temporarily. Hmm...and it's definitely going to fail if more than one person tries to access it at the same time. Dang. Time to do some more thinking.

Would creating a view that does not "Send SQL Updates" work in your situation? You could initially Requery the business object/view and obtain the records you need, then manipulate to your heart's content without affecting the underlying tables.

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform