>>Hello,
>>
>>I create a table in MsSQL with
>>
>>CREATE TABLE Test (test Decimal(10,0))
>>
>>
>>When I query from this table
>>
>>SQLEXEC(1,"SELECT * FROM Test","cuTest")
>>
>>Then the field Test.test is 12 decimals.
>>How can that be, and how can I avoid this inconsistency?
>
>see what your set(Decimals) is set to.
Decimals is set to 2. Changing it to 0 does not seem to have any effect on the result.
Christian Isberner
Software Consultant