Hi all,

Which is the better ways? (see below)

Method 1:
Retrieve all records of the sqlserver table. Index the view, and seek if record from vfp exist in this view. If not, SQLEXEC to insert.

Method 2:
SQLEXEC with SELECT with the WHERE clause for the pk. If not record, SQLEXEC to insert.

If there is better way, please advise. The tables will be big.

Regards.