diff options
| author | Lionel Elie Mamane <lionel@mamane.lu> | 2012-01-31 21:32:55 +0100 |
|---|---|---|
| committer | Petr Mladek <pmladek@suse.cz> | 2012-02-01 11:51:12 +0100 |
| commit | 7f0a631e043c2133af9463f3e22d33b502ef5b92 (patch) | |
| tree | d145a46ef01e0624232c9f55cc5ba77b36cb0332 | |
| parent | clone token in ScFormulaResult copy-ctor instead of referring (diff) | |
| download | core-7f0a631e043c2133af9463f3e22d33b502ef5b92.tar.gz core-7f0a631e043c2133af9463f3e22d33b502ef5b92.zip | |
fdo#45453: use integers rather than booleans
for always-true and always-false tests.
Some databases have poor or no support for booleans.
Signed-off-by: Jan Holesovsky <kendy@suse.cz>
Signed-off-by: Noel Power <nopower@suse.com>
Signed-off-by: Muthu Subramanian K <sumuthu@suse.com>
Signed-off-by: Petr Mladek <pmladek@suse.cz>
| -rw-r--r-- | dbaccess/source/core/api/KeySet.cxx | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/dbaccess/source/core/api/KeySet.cxx b/dbaccess/source/core/api/KeySet.cxx index b41e68b4b82d..8e42b30000cb 100644 --- a/dbaccess/source/core/api/KeySet.cxx +++ b/dbaccess/source/core/api/KeySet.cxx @@ -228,8 +228,8 @@ namespace void appendOneKeyColumnClause( const ::rtl::OUString &tblName, const ::rtl::OUString &colName, ::rtl::OUStringBuffer &o_buf ) { static ::rtl::OUString s_sDot(RTL_CONSTASCII_USTRINGPARAM(".")); - static ::rtl::OUString s_sParam0(RTL_CONSTASCII_USTRINGPARAM(" ( TRUE = ? AND ")); - static ::rtl::OUString s_sParam1(RTL_CONSTASCII_USTRINGPARAM(" = ? OR TRUE = ? AND ")); + static ::rtl::OUString s_sParam0(RTL_CONSTASCII_USTRINGPARAM(" ( 1 = ? AND ")); + static ::rtl::OUString s_sParam1(RTL_CONSTASCII_USTRINGPARAM(" = ? OR 1 = ? AND ")); static ::rtl::OUString s_sParam2(RTL_CONSTASCII_USTRINGPARAM(" IS NULL ) ")); o_buf.append(s_sParam0); o_buf.append(tblName); @@ -247,16 +247,16 @@ void OKeySet::setOneKeyColumnParameter( sal_Int32 &nPos, const Reference< XParam { if ( _rValue.isNull() ) { - _xParameter->setBoolean( nPos++, false ); + _xParameter->setByte( nPos++, 0 ); // We do the full call so that the right sqlType is passed to setNull setParameter( nPos++, _xParameter, _rValue, _nType, _nScale ); - _xParameter->setBoolean( nPos++, true ); + _xParameter->setByte( nPos++, 1 ); } else { - _xParameter->setBoolean( nPos++, true ); + _xParameter->setByte( nPos++, 1 ); setParameter( nPos++, _xParameter, _rValue, _nType, _nScale ); - _xParameter->setBoolean( nPos++, false ); + _xParameter->setByte( nPos++, 0 ); } } |