You could always "recycle" the records - this is what we do with VFP mtdll web apps since it was so hard to do a pack in a web app. For records that you intend to delete just blank out the key field and any additional fields. Then when you add a new record just seek the first empty key and add to it. It works great for our web apps and keeps the file size way down...
>Thank you Chris
>I have actually tried this by writing a vfp com server. Unfortunately I can't get the exclusive table access to do the 'pack'
>ie the asp is still locking the table.
>
>Normaly I could write an administration program to close down the web server and perform the nessescary the packing. Unfortunately I'm expecting heavy use of the table so it remains unfeasible.
>
>Oh well the challenge is still open .
>!!!!!Delete records in a vfp table from within an ASP page.!!!!
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