Subject Re: [firebird-support] Re: Simple update statment gives error code -104
Author Mark Rotteveel
> Got it solved, with the update of the Char(1) field that I tried to set to
> 'N' I also updated a string field. The string field containd something
> like "A boolean field contains 'N' or 'Y'". It was this 'N' character it
> complaind about.
>
> So conclusion setString("N") on a char(1) database field works fine.
>
> Sorry for my mistake, thanks for the support.

If you are using parameterized queries (setString) to set that text, that should not have given you an error. The error then seems to indicate that you had that String hardcoded in the query string, without escaping the '-character.

Mark
--
Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir
belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de