Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to replace / overwrite a table by other table !!
Message
 
À
07/05/1999 08:24:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00215998
Message ID:
00216020
Vues:
28
>I would like to ask the question again.
>I have a temp table and real table, they have the same structure,fields and number of records. I want to replace or overwrite the whole real table records by the temp table records.
>That will do in runtime. Can the table not in exclussive ? becoz both of the table will be in the form data environment.

You might use FLOCK() if needed for multiusers, then if successful, just delete all, and append or insert the new records. You'll want to clean up (PACK) the base table occasionally, though, or it'll get bloated with deleted recs...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform