Actually, it's great for parameterized selects. From the SQLPREPARE help:
gcAuthor = 'Smith'
= SQLPREPARE(gnConnHandle, 'SELECT * FROM authors;
WHERE au_lname = ?gcAuthor')
= SQLEXEC(gnConnHandle)
...
gcAuthor = 'Jones'
= SQLEXEC(gnConnHandle)
>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.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao