Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VIEW Question
Message
 
À
26/05/1999 11:08:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00222924
Message ID:
00223024
Vues:
29
>Craig,
>
>One of us is misunderstanding - probably poor explanation on my part!
>
>I'm not looking to a get a new BLANK RECORD - but to essentially lose ALL the existing records in the view. Let's say I requery the view and end up with 5 records in it. After modifying and updating those records, I want to "clear" the view - that is - set it to have no records just like it had just been opened "nodata"
>
>DELETE ALL won't work because that "modifies" the view and goes to back-end - and I don't want to have to requery with some dummy parameter - that seems silly and takes time.
>
>Thanks for your help!
>Ken
>
>>>Hi,
>>>
>>>Does anyone know of a way to "empty" a paramaterized view without having to requery it? Essentially, I would like to put it back to "nodata" status. At the time I want to do this, the view has been updated (currently unmodified) and thus, not sitting with any uncommitted records.
>>>
>>>TIA!
>>>Ken
>>
>>APPEND BLANK into the view. Make sure you REVERT before doing anything else.

Ken,
Could you not do the following

SELECT cView
=TABLEUPDATE(.T., .T.)
USE cView NODATA

Just a thought ?

Mark Letheren
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform