Appending/Truncating SQL-Server Tables

[hjohnson]

I have a Foxpro app with a view to SQL-Server Table through which I first have to delete all the current records and append new ones. My current process (below),- A delete statement, then an Append from statement - is too slow. Is there a faster or better way?

** View name is Load_data **
use load_data
delete from load_data
append from Newdata


Many thanks in advance for any help on this matter
HJ

 

[DEDMOD]

Have you tried creating a new table using the structure of the old one and then renaming the tables? First give the old table a back-up name and then rename the new one to the old one. You could then delete the back-ups at leasure. -- Dave

 

[foxdev]

If user permissions are not an issue, try:

[tt]sqlexec(MyHandle, "truncate table MyServerTable&quot
use load_data
append from Newdata[/tt]



Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com