Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Wang
I do not understand exactly what you are trying to do.
SET DELETED ON is one way to hide deleted records.
If you Select * from Mytable into cursor Mycursor and them pack mytable, the deleted records in mytable are still in mycursor.
>Hi Mike,
>
>Thank you for the reply. If i don't use pack (Which you are rite that this suppose to be done weekly or a period of time) how i can avoid to display the data from the table which i have deleted.
>
>Also beside this, i found another thing about pack. If i have run the statement as below (which in other button like scrolling)
>
>Select * from Mytable into cursor Mycursor
>THISFORM.Combo1.controlsource = "Mycursor.Myfield"
>
>
>The subsequent pack after the deletion will not take effect at all even i have already put a "select Mytable" before the deletion statement ? Instead, if i just use
>
>Select Mytable
>THISFORM.Combo1.controlsource = "Mytable.Myfield"
>
>Every thing go back to normal.
>
>Why is this cursor thing can affect the pack statement ?
>
>
>Thank you and best regard
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