A field is set to a Decimal data table (12, 8) type, I store 100.123456789, why is the data inventory of 100.12350000, should not be 100.12345679? I am using pb data window setitem, after save,

CodePudding user response:

Post code up to look at it?

CodePudding user response:

Take this column dw_1. The describe (" a.c oltype ") see

refer to the original poster yeyuqiong response:

data table a field is set to a Decimal (12, 8) type, I store 100.123456789, why is the data inventory of 100.12350000, should not be 100.12345679? I am using pb data window setitem, after save,

CodePudding user response:

Problems that could go in the front desk you write code, chances are you use the front desk of the variable precision is not enough