Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to replace / overwrite a table by other table !!
Message
 
To
07/05/1999 08:24:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00215998
Message ID:
00216020
Views:
29
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform