On Mon, Dec 1, 2014 at 1:55 PM, toninhonunes@... [IBObjects] <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

	ERROR-BOOLEAN.JPG - Google Drive
	View on drive.google.com	Preview by Yahoo

 

Thanks in Advance!

Toninho Nunes

---In 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]
Sent: Friday, November 28, 2014 10:40 PM
To: 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]