Information générale
Titre:
Packing in a cursor
Is it possible to completely remove deleted records from a cursor? Pack gives me an error that the operation is not available for a cursor (or something like that).
-The cursor is a view based on a SQL Server 7 view.
-The user initially sees an empty grid (cursor) for listing selected names (curSelected). They then select names from another list that get added to and removed from the curSelected cursor. Kind of like a mover class, except using grids instead of list controls.
-I have Set Deleted On and Private DataSession
-In my grids, I use the RecNo() function to set the backcolor of each row. When there is a deleted record, the two records before and after it display the same backcolor. This is confusing to the user, because they cannot see the deleted record.
Thanks in advance for any help with this!
Don
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