Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
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