>> not by name, but using a scrolling index
Yes parameters are (zero) indexed in the TParameters collection: you can refer
as Parameters[0], instead of Parameters.ParamByName('myParam')
So, if you added the params by hand, then I think the conclusion you reach is
probably correct. Not sure why the params needed to be added manually: did you
set the Active property of the query to True in the OI?
I'm glad that it all works as it should now.
Regards
Steve
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Behalf Of mauro russo
Sent: 29 October 2008 17:47
To: [email protected]
Subject: Re: [delphi-en] updating through ADOquery
any comment?
----- Original Message -----
From: "mauro russo" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, October 29, 2008 1:14 PM
Subject: Re: [delphi-en] updating through ADOquery
I found out the problem!
SQL Server Profiler helped me.
In a previous post I underlined about something wierd, that is
the Parameters did not automatically appear after I set the SQL property,
and so I had to add by hands (at design time).
Well, the order of Parameters was not the same in appearing in the SQL.Text
string,
and so I believe in the Execution, every time it finds a ':' char, it fetch
the value
of the next parameter, not by name, but using a scrolling index.
So.... this causes the errors.
I accurately checked the order, and now everything works.
Thanks for useful help!
----- Original Message -----
From: Cord Schneider
To: [email protected]
Sent: Tuesday, October 28, 2008 6:19 PM
Subject: RE: [delphi-en] updating through ADOquery
Mauro,
Have you tried running SQL Server Profiler to check what your
application is /actually/ sending to the server?
----- Original Message -----
From: mauro russo
To: [email protected]
Sent: 28 October 2008 16:10
Subject: Re: [delphi-en] updating through ADOquery
Yes, I do, and the value returned fit what I can see with
Microsoft SQL Server Management Studio Express.
----------
Questa email è stata verificata dal sistema centralizzato antivirus della
UniPlan Software
[Non-text portions of this message have been removed]
------------------------------------
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED] Groups Links
----------
Questa email è stata verificata dal sistema centralizzato antivirus della
UniPlan Software
[Non-text portions of this message have been removed]
------------------------------------
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED] Groups Links
***************************************************************************
This e-mail and any files transmitted with it are confidential. If you are not
the intended recipient, any reading, printing, storage, disclosure, copying or
any other action taken in respect of this e-mail is prohibited and may be
unlawful. If you are not the intended recipient, please notify the sender
immediately by using the reply function and then permanently delete what you
have received.
Content of emails received by this Trust will be subject to disclosure under
the Freedom of Information Act 2000, subject to the specified exemptions,
including the Data Protection Act 1998 and Caldicott Guardian principles.
This footnote also confirms that, unless otherwise stated, this email message
has been swept by Sophos Anti-virus for the presence of computer viruses.
***************************************************************************
