Hmm..


Try:

ACP.IMPRESSO=BOOLEAN='S,N';REQUIRED

And try also without table name as:

IMPRESSO=BOOLEAN='S,N';REQUIRED

(use renaming of field in SQL query if “IMPRESSO” present in several tables)


WBR, Dmitry Beloshistov AKA [-=BDS=-]

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, December 01, 2014 3:12 PM
To: IBObjects@yahoogroups.com
Subject: Re: RES: RES: RES: [IBO] TIB_Query + TIB_Grid and ColumnAttibutes Boolean Field problems !


Have you tried this:

ACP.IMPRESSO=BOOLEAN=S,N

(without the quotes around the values)

On Mon, Dec 1, 2014 at 1:55 PM, toninhonunes@...<mailto:toninhonunes@...> [IBObjects] <IBObjects@yahoogroups.com<mailto:IBObjects@yahoogroups.com>> wrote:


Hi Dmitry,

DDL of Domain

CREATE DOMAIN D_BOOLEANO AS
CHAR(1) CHARACTER SET ISO8859_1
DEFAULT 'N'
NOT NULL
CHECK ((VALUE = 'S') OR (VALUE = 'N'))
COLLATE ISO8859_1;

DDL of Table

*****************************************************************************/



CREATE TABLE ASSOCIADO_CONTRATO_PARCELA (
NUMERO_CONTRATO D_NUM_DOCUMENTO NOT NULL /* D_NUM_DOCUMENTO = INTEGER NOT NULL CHECK (VALUE >0) */,
MATRICULA D_MATRICULA_ENTIDADE NOT NULL /* D_MATRICULA_ENTIDADE = INTEGER NOT NULL */,
PARCELA D_QUANTIDADE NOT NULL /* D_QUANTIDADE = INTEGER DEFAULT 0 NOT NULL CHECK (VALUE >= 0) */,
DATA_VENCIMENTO D_DATA_DIA /* D_DATA_DIA = DATE DEFAULT CURRENT_DATE NOT NULL */,
VALOR_PARCELA D_MOEDA /* D_MOEDA = NUMERIC(15,2) DEFAULT 0.00 CHECK (VALUE >= 0) */,
VALOR_PAGO D_MOEDA /* D_MOEDA = NUMERIC(15,2) DEFAULT 0.00 CHECK (VALUE >= 0) */,
CODIGO_FINALIZADORA INTEGER,
NUMERO_DOCUMENTO INTEGER,
EMITE_RECIBO D_BOOLEANO /* D_BOOLEANO = CHAR(1) DEFAULT 'N' NOT NULL CHECK ((VALUE = 'S') OR (VALUE = 'N')) */,
DATA_VIGENCIA_PARCELA D_DATA_DIA /* D_DATA_DIA = DATE DEFAULT CURRENT_DATE NOT NULL */,
DATA_PAGAMENTO DATE,
IMPRESSO D_BOOLEANO /* D_BOOLEANO = CHAR(1) DEFAULT 'N' NOT NULL CHECK ((VALUE = 'S') OR (VALUE = 'N')) */,
NOSSO_NUMERO VARCHAR(20),
CODIGO_CEDENTE INTEGER,
NUMERO_RECIBO INTEGER
);

Property of TIB_Query ColumnAttributes

CODIGO_DOCUMENTO=NOTREQUIRED;BLANKISNULL
DATA_INCLUSAO=BLANKISNULL
HORA_INCLUSAO=BLANKISNULL
NUMERO_CONTRATO=NOTREQUIRED
ACP.IMPRESSO=BOOLEAN='S,N' <===== Error in this boolean

Follow image below


ERROR-BOOLEAN.JPG - Google Drive<https://drive.google.com/file/d/0B3gf5_gur0EBN1dVeFIyZWZVbXM/view?usp=sharing>


ERROR-BOOLEAN.JPG - Google Drive <https://drive.google.com/file/d/0B3gf5_gur0EBN1dVeFIyZWZVbXM/view?usp=sharing>

View on drive.google.com <https://drive.google.com/file/d/0B3gf5_gur0EBN1dVeFIyZWZVbXM/view?usp=sharing>

Preview by Yahoo





Thanks in Advance!

Toninho Nunes


---In IBObjects@yahoogroups.com<mailto:IBObjects@yahoogroups.com>, <torin@...> wrote :
Hi!

Please show DDL for table, domain declaration and table triggers (if exists). And TIB_Query.FieldAttributes property (as text) too.

WBR, Dmitry Beloshistov AKA [-=BDS=-]

From: IBObjects@yahoogroups.com<mailto:IBObjects@yahoogroups.com> [mailto:IBObjects@yahoogroups.com<mailto:IBObjects@yahoogroups.com>]
Sent: Friday, November 28, 2014 10:40 PM
To: IBObjects@yahoogroups.com<mailto:IBObjects@yahoogroups.com>
Subject: Re: RES: RES: RES: [IBO] TIB_Query + TIB_Grid and ColumnAttibutes Boolean Field problems !



No, The domain does not accept other value, S or N and the default value is N, if I change the domain to accept T or F the problem disappears.

Toninho Nunes



[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]