Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
'USE EXCLUSIVE' in a 24 / 7 Environment
Message
De
22/05/1998 17:54:53
 
 
À
22/05/1998 16:14:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00101295
Message ID:
00101326
Vues:
18
Instead of packing, you take steps to eliminate the need for packing. When you insert records you take the following steps:
lcSetDeleted = set("deleted")
set deleted off
locate for deleted() && index on deleted() is always recomended
if found()
    blank
    recall
else
    append blank
endif

*update/replace goes here

set default to &lcSetDeleted
Memos are a different matter, but they can be simulated. Create a pseudo-memo table with key, sequence, text fields where key relates to the parent table, sequence is the sequence number of text blocks that make up the pseudo-memo. you concatenate all the text blocks for a key followinf sequence order into a memory variable for display and editting. You reverse the process to write the text to the table using the record reuse code shown above. This may seem cumbersome but, the Fox memo writing algorithms do not reuse previously allocated space and can grow very quickly if there are many changes to memo fields.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform