You are right. Active is false, but because I associate the Connection property at run-time. It is because I use this form in many projects and so I'd like to don't embed it (the TADOConnection object is on the main form, embedded for any project).
This info is what I still miss. Thanks for help. Mauro. ----- Original Message ----- From: Wilson, Stephen To: [email protected] Sent: Wednesday, October 29, 2008 7:29 PM Subject: RE: [delphi-en] updating through ADOquery >> 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. *************************************************************************** ---------- Questa email è stata verificata dal sistema centralizzato antivirus della UniPlan Software [Non-text portions of this message have been removed]
