Hi,

At October-09-09, 8:43 PM, Edward wrote:

> 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'


> Why is CompoundGrowth false?

You mention that when you re-read the record, that COMPOUNDGROWTH is
'F'. The log that you showed didn't show the SELECT, only the UPDATE,
after the insert was performed. Also, do you have any insert triggers
on that table, and if you do, can you show them?

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Solutions Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)