>Good idea. But, I don't think it will help in my humble case. I'm doing inserts. (Its a data conversion from fox/dos files to sql anywhere. And I do mean conversion. Lots of goofy programming to make the data into a new format.)
>
>I seriously considered writting to vfp tables of the same name and size, dropping them to ascii files at the end, and then doing a SQL load statement to pick them up... but that looked kinda complicated. Plus, I wouldn't have control over each write to ensure that it happened correctly.
>
>>OK, here's my take: If you are executing calls to a backend database server and the same statement is sent several times but with different parameters, then you can get some improvement if you SQLPREPARE() it. Just my .02 and HTH
Well, let's see:
Use myfoxdbf
x=SqlConnect("mydsn")
Store "" To myfld1, myfld2
y=SqlPrepare(x, "Insert Into mysqltbl Values(?myfld1, ?myfld2)")
Scan
myfld1 = myfoxdbf.field1
myfld2 = myfoxdbf.field2
SqlExec(x)
EndScan
SqlDisconnect(x)
Use In myfoxdbf