Report: the updates on the bit-type columns work only from 0 to 1, but not reverse. This problem exist with both cases: ftBoolean or ftInteger on the Parameter.DataType property.
About the 1 => 0, the SQL Server Profiler reports that the db received a parameter with value 1. But the update from 0 to 1 works if I use an hard-coded (using constants in the SQL.Text). I could not try to use ' = False' in the SQL.Text, because it does not recognize 'False' (reports: 'invalid column-name False'). However I have problems also with a string-type column. I am going to chose for a solution where I do not use parameters, but dynamically build an SQL.Text statement ahving constants according to the proper values. However, I would like to understand wjere is the problem. Any comment? Thanks for help, Mauro. ----- Original Message ----- From: Wilson, Stephen To: delphi-en@yahoogroups.com Sent: Tuesday, October 28, 2008 6:02 PM Subject: RE: [delphi-en] updating through ADOquery The next thing I would try is running the Update query using hard-coded values instead of parameters in your WHERE clause .... -----Original Message----- From: delphi-en@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of mauro russo Sent: 28 October 2008 16:10 To: delphi-en@yahoogroups.com 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. ----- Original Message ----- From: Wilson, Stephen To: delphi-en@yahoogroups.com Sent: Tuesday, October 28, 2008 5:02 PM Subject: RE: [delphi-en] updating through ADOquery If you run SELECT * FROM UB_INPUT_OPTIONS WHERE Board_Id = :Board_Id AND Classe = :Classe AND Indice = :Indice do you get rrecords returned? *************************************************************************** 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] ------------------------------------ ----------------------------------------------------- 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/
