>>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.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.