Information générale
Catégorie:
Codage, syntaxe et commandes
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement