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]
