Subject Inserted record has wrong value
Author Edward
I have the following SQL in a DSQL object:

insert into KnownIncomeinfo
(KnownIncome_ID, CLIENT_ID, CLIENTSPOUSE_ID, COMPOUNDGROWTH)
values
(:KnownIncomeID, :ClientID, 0, 'T')

where COMPOUNDGROWTH is defined as the domain DM_TM, which is VALUE IN ('F', 'T')

But the COMPOUNDGROWTH is 'F'

When I run the SQL (followed by the select), the following TibMonitor messages:

/*---
PREPARE STATEMENT
TR_HANDLE = 3649344
STMT_HANDLE = 88380260

insert into KnownIncomeinfo (KnownIncome_ID, CLIENT_ID, CLIENTSPOUSE_ID, COMPOUNDGROWTH)
values (? /* KnownIncomeID */ , ? /* ClientID */ , 0, 'T')

FIELDS = [ Version 1 SQLd 0 SQLn 142 ]
----*/

/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 88380112
----*/

/*---
PREPARE STATEMENT
TR_HANDLE = 88380112
STMT_HANDLE = 88379924

SELECT GEN_ID ( GEN_KNOWNINCOME_ID, 1 )
FROM RDB$DATABASE
PLAN (RDB$DATABASE NATURAL)

FIELDS = [ Version 1 SQLd 1 SQLn 1
GEN_ID = 5 ]
----*/

/*---
EXECUTE2 DSQL
TR_HANDLE = 88380112
STMT_HANDLE = 88379924
PARAMS = [ ]
FIELDS = [ Version 1 SQLd 1 SQLn 1
GEN_ID = 14 ]

SELECT COUNT: 1
----*/

/*---
EXECUTE STATEMENT
TR_HANDLE = 3649344
STMT_HANDLE = 88380260
PARAMS = [ Version 1 SQLd 2 SQLn 2
[KNOWNINCOMEID] = 14
[CLIENTID] = 221 ]

INSERT COUNT: 1
----*/

/*---
COMMIT RETAINING
TR_HANDLE = 3649344

SECONDS = 0.031
----*/

********************************************************

And then I turn around and immidately re-read the record:

/*---
PREPARE STATEMENT
TR_HANDLE = 3649344
STMT_HANDLE = 88379924

update KnownIncomeInfo set
KNOWNSAVIGNS_NAME = ? /* KNOWNSAVIGNS_NAME */ , PAYPERYEAR = ? /* PAYPERYEAR */ , PAYVALUE = ? /* PAYVALUE */ ,
GROWTHPRERETIRE = ? /* GROWTHPRERETIRE */ , GROWTHPOSTRETIRE = ? /* GROWTHPOSTRETIRE */ ,
COMPOUNDGROWTH = ? /* COMPOUNDGROWTH */ , STARTING_ID = ? /* STARTING_ID */ ,
STARTING_VALUE = ? /* STARTING_VALUE */ , ENDING_ID = ? /* ENDING_ID */ , ENDING_VALUE = ? /* ENDING_VALUE */ ,
PRERETIREINCOME_ID = ? /* PRERETIREINCOME_ID */ , CLIENTSPOUSE_ID = ? /* CLIENTSPOUSE_ID */ , TAXMETHOD_ID = ? /* TAXMETHOD_ID */ ,
TAXMODEL_ID = ? /* TAXMODEL_ID */ , TAXCOSTBASIS = ? /* TAXCOSTBASIS */ , TAXTIERPRIORITYMETHOD_ID = ? /* TAXTIERPRIORITYMETHOD_ID */
where KNOWNINCOME_ID = ? /* KNOWNINCOME_ID */

PLAN (KNOWNINCOMEINFO INDEX (KNOWNINCOMEINFO_PK))

FIELDS = [ Version 1 SQLd 0 SQLn 142 ]
----*/

/*---
EXECUTE STATEMENT
TR_HANDLE = 3649344
STMT_HANDLE = 88366176
PARAMS = [ Version 1 SQLd 1 SQLn 1
[TABLENAME] = 'KNOWNINCOMEINFO ' ]
----*/

/*---
EXECUTE STATEMENT
TR_HANDLE = 3649344
STMT_HANDLE = 88379924
PARAMS = [ Version 1 SQLd 17 SQLn 17
[KNOWNSAVIGNS_NAME] = 'New Known Income Account'
[PAYPERYEAR] = 12
[PAYVALUE] = 0
[GROWTHPRERETIRE] = 0
[GROWTHPOSTRETIRE] = 0
[COMPOUNDGROWTH] = 'F'
[STARTING_ID] = 0
[STARTING_VALUE] = 0
[ENDING_ID] = 0
[ENDING_VALUE] = 0
[PRERETIREINCOME_ID] = 0
[CLIENTSPOUSE_ID] = 0
[TAXMETHOD_ID] = 0
[TAXMODEL_ID] = 0
[TAXCOSTBASIS] = 0
[TAXTIERPRIORITYMETHOD_ID] = 0
[KNOWNINCOME_ID] = 14 ]

SELECT COUNT: 1
UPDATE COUNT: 1
----*/

Why is CompoundGrowth false?