The purpose is not necessarily for "Select ...." its more for Inserts and deletes that would be repeated multiple times.

PF

>>>Is there an advantage to using:
>>>
>>>SQLPREPARE(mnconnection,'SELECT....','cMyCursor')
>>>SQLEXEC(mnconnection)
>>>
>>>as opposed to just:
>>>
>>>SQLEXEC(mnconnection,'SELECT....','cMyCursor')
>>
>>From what I understand, SQLPREPARE will make the call faster for functions that will be called multiple times, because the the request doesn't have to be compiled each time...
>
>Well, unless I'm missing something, that seems kind of useless. I can't even think of a reason why I would run the same SQL-SELECT multiple times in a row.
>
>Thanks for the reply.