Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
Hi Wang
PACK is not supposed to be done after each delete. You should PACK once a week or once a month instead. Its a maintenance function.
>Hi Barbara and Frank,
>
>Thank you very much on replying to my question. With the info you have provided, I guess have finally resolve insert issue. Using the following
>coding, my table will no longer give funny feedback after insert (Without using reindex)
>
>Coding start :
>
>Local mworkspace
>mworkspace = Select()
>...
>...
>Select Mytable
>insert into Mytable value (......)
>....
>....
>Select (mworkspace)
>
>
>Instead of
>
>Open Mydatabase
>Use Mytable
>insert into Mytable value (....)
>
>
>With the above coding, I can insert data without using reindex and table work fine (So far so good). However for delete, I still have to open table exclusive so that I can pack after delete. But according to Frank, if I plan to work out a network application, table cannot be open exclusively ?? If so, how I can acheive packing after deletion without open the table exclusively ?
>
>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