(incubating) | The Free and Open Productivity Suite

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.

:: com :: sun :: star :: sdb ::

unpublished constants group BooleanComparisonMode
Usage Restrictions
not published
Description
specifies different modi how boolean comparison predicates are to be generated by a SingleSelectQueryComposer.

Constants
EQUAL_INTEGER denotes the default comparison  
IS_LITERAL requires to use IS boolean_literal for boolean comparison.  
EQUAL_LITERAL requires to use = boolean_literal for boolean comparison.  
ACCESS_COMPAT requires to use an Microsoft Access compatible syntax for boolean comparison.  
Constants' Details
EQUAL_INTEGER
const long EQUAL_INTEGER = 0;
Description
denotes the default comparison

Most databases support comparing boolean expressions or column values directly with integer values: column = 0 respectively column = 1.

IS_LITERAL
const long IS_LITERAL = 1;
Description
requires to use IS boolean_literal for boolean comparison.

That is, the generated comparison predicates will be column IS TRUE resp. column IS FALSE.

EQUAL_LITERAL
const long EQUAL_LITERAL = 2;
Description
requires to use = boolean_literal for boolean comparison.

That is, the generated comparison predicates will be column = TRUE resp. column = FALSE.

ACCESS_COMPAT
const long ACCESS_COMPAT = 3;
Description
requires to use an Microsoft Access compatible syntax for boolean comparison.
Top of Page

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright & License
Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.