>I have never used the SQLPREPARE() command before and I was wondering if anyone could tell me a bit about where and when this command would be useful. It seems from reading the help file that issuing a SQLPREPARE prior to a SQLEXEC() may make the SQLEXEC() run faster?
>
>Is that true?
>
>Thanks,
>Don

From my understanding of it is that if you need to call the same SQL statement over and over again, with out other SQL statement in between, then use SQLPrepare once and then just issue SQLExec with the connection handle. But if you send anyother SQL statement then the Prepare is gone - so IMO not to useful.