Am I crazy ? Am I doing something wrong ?
I have just accidentally found, that whenever SQL property of TADOQuery
changes, there is a separate stored procedure call sent to SQL server.
It can be seen via SQL Server Profiler.
Whenever either SQL.Add is used or SQL.Text is changed in any way, there is
a call looking like "sp_prepare @p1 output etc.."
If I do
SQL.Add ('select');
SQL.Add ('from');
SQL.Add ('customers');
then there will be 3 calls to sp_prepare !!!
I generate long sql statements in loops and get tonns of this sent to the
server.
I found that these calls do not occur if ParamCheck property of ADOQuery is
set to FALSE ! But then ':' style parameters do not get recognized by ADO
and they all have to be somehow manually created.
Does anyone have any suggestions,comments,ideas on this ?
Regards
Alex
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
