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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/delphi-en/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
