Hi Borislav

>It is very hard to say w/o proper testing. I would vote for second if you first issue SQLPREPARE() to prepare your query first and then in loop just change parameters and issue SQLEXEC(), BUT as I said, I am not so sure that this is the faster way.

So an SQLEXEC() (w/o a SQLPREPARE) containing the same SQL statement (but different parameters) will be slow inside the loop. But if the same thing is SQLPREPAREd() before the loop it will give a better performance, if then the SQLEXEC() is called in the loop?