Sending decimal data type to Sql Server

[siraj777]

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&quot

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.

 

[pullesj]

Can you change the stored procedure parameter to be data type 'real' or 'float'? Real and Float data types are approximate data types as opposed to decimal types which contain exact precision. You can use SQL Server 6.5/7 Online Books and read up on data types real, float, and decimal.

Also, you can test whether PB is not passing the parameter properly by invoking the stored procedure via MS Query Analyzer.

Good Luck

 

[siraj777]

Thanks for your reply.

The above problem was solved by sending string type data from PowerBuilder and converting back to decimal inside the stored procedure.

set @hoursdec = convert(decimal(6,1),@hours)