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
--Todd Sherman
-Wake Up! Smell the Coffee!