Or maybe just use the Upsizing wizard from vfpx.org ?
wOOdy
-----Ursprüngliche Nachricht----- Von: ProFox profox-bounces@leafe.com Im Auftrag von Chris Davis Gesendet: Donnerstag, 28. November 2019 17:55 An: ProFox Email List profox@leafe.com Betreff: SQL Dump
Hi All
Is there any tricks I am missing which would speed up a dump of a VFP table into a SQL table.
I have predifined by SQL statement something like this
"insert into mytable (myfield) values (?m.myfield)"
I am then scanning through the VFP table performing a scatter memvar and then executing the SQL.
It works it just seems to take alot longer than I imagined it would.
Thanks IA
Chris.
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]