Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rejecting Duplicates during appends
Message
From
23/10/2003 14:52:49
 
 
To
23/10/2003 14:05:13
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00841699
Message ID:
00841745
Views:
24
Hi Greg,

A solution exist, and it is fast.
First you need to remove or close Candidate Index.
SELECT targetTable
* close or delete any index
INDEX ON uniqueExpression UNIQUE TAG TAG1
USE targetTable AGAIN ALIAS targetTableSearch IN 10000 ORDER 1
APPEND FROM textFile FOR !SEEK(uniqueExpression,100) OR RECNO()=RECNO(100)
USE IN 10000
* open index of targetTable
* REINDEX
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform