Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting all the records in a view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00106083
Message ID:
00106148
Vues:
26
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform