Can you use SQL pass through with a select statement taking data from a VFP table??
Example:-
lnResult=SQLEXEC(lnSqlHandle,"INSERT INTO sqltable SELECT * FROM vfptable)
The VFP table will contain up to 100k rows. If this is possible, how would I reference the table - do I use the ? prefix??
I am currently using a remote view and appending from the VFP table - I don't like it, something inside me tells me this is not right! Even though it solves all my problems!