HI,
I am using Powerbuilder 6.5 and MS SQL Server 7.0
I am calling stored procedure with an argument of decimal data type.
Decimal ldc_hours
ldc_hours = dw_1.GetItemDecimal(1,"hours"
sp_hours(ldc_hours)
In Sql Server
Procedure <name>
hours decimal(6,1) AS
<etc.,>
Now the real problem: If I send 3.9 from PB; SQL SERVER is accepting 3 (ignoring the decimal position)
I tried using numeric(6,1) in sql server too.
I am using Powerbuilder 6.5 and MS SQL Server 7.0
I am calling stored procedure with an argument of decimal data type.
Decimal ldc_hours
ldc_hours = dw_1.GetItemDecimal(1,"hours"
sp_hours(ldc_hours)
In Sql Server
Procedure <name>
hours decimal(6,1) AS
<etc.,>
Now the real problem: If I send 3.9 from PB; SQL SERVER is accepting 3 (ignoring the decimal position)
I tried using numeric(6,1) in sql server too.