Numeric Problem
Posted: Tue 09 Nov 2004 01:42
hi all,
i try to create a decimal(3,2) Field, input 100 and save. it can save as 100 in SQL Server but it get '11' when i load it from SQL Server again. After i Alter the column to be decimal(4,2) and get the data again, it can show 100. What is the Problem ? (By using dbexpress driver for SQL Server)
Thx
Kevin
i try to create a decimal(3,2) Field, input 100 and save. it can save as 100 in SQL Server but it get '11' when i load it from SQL Server again. After i Alter the column to be decimal(4,2) and get the data again, it can show 100. What is the Problem ? (By using dbexpress driver for SQL Server)
Thx
Kevin