Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
V6s5 - REQUERY() a view for a given SELECT no. of recs
Message
De
16/04/2004 08:32:49
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00895276
Message ID:
00895495
Vues:
32
>Hello Mike
>
>Thanks a lot for responding.
>
>>Are you deleting the record in the view used to make the treeview?
>
>Yes
>
>>If so, do not do a requery / refresh.
>
>Okay
>
>>Delete the record, do the tableupdate,
>
>CodeBook seems to be doing this, alright
>
>>repopulate the tree from the view, excluding the deleted record.
>
>Here I do a SELECT on the (I had forgotten to mention, remote) view, yet the returned cursor shows the deleted record.
>
>>Don't forget the cursor already has the data for the tree.
>
>Yes but as above I am recreating the cursor

I don't believe you need to do that. However, SELECT * FROM thecursor WHERE NOT DELETED().
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform