I have

1. This domain.

create domain d_bool_yn as
char(1) character set none
check (value in ('Y', 'N'))
collate none;

describe domain d_bool_yn
'y or n';


2. This table:

create table program (
prg_id d_id not null /* d_id = integer */,
...
prg_consent d_bool_yn not null /* d_bool_yn = char(1) check
(value in ('Y', 'N')) */,);


3. This TIB_QUERY

select
, p.prg_id
......
, p.prg_consent

from program p


4. This column attribute

PRG_CONSENT=BOOLEAN=Y,N


Upon opening the dataset in the data tab of the the TIB_Query, I can
see the little checkbox for this required boolean and I can click the
checkbox either way and save. No problem.


However, if I qualify the column attributes as follows:

P.PRG_CONSENT=BOOLEAN=Y,N


Then, when I check the checkbox from unchecked to checked, and post, I
get this error:


ISC ERROR CODE:33554347

ISC ERROR MESSAGE:
Validation error for column PRG_CONSENT, value "T"


Note the the error message does not say P.PRG_CONSENT

Anyone know what is happening here?