0 votes
54 views
in Toolkits by (500 points)
Hi,

I have an MS SQL application database. I have a stored procedure with decimal input (18,6).

The stored procedure works correctly when called from   "Microsoft SL Server Management Studies".

When the stored  procedure is called by BPM, the number is rounded to 4 digits. Why?

I use SQL Call Stored Procedure" with this input:

tw.local.sql = " " + "WIDC_SP_AGGIORNACOMP ?

SQL Parameter:

tw.local.parameters[0] = new tw.object.SQLParameter()

tw.local.parameters[0].value = "0.123456";

tw.local.parameters[0].mode = "IN";

tw.local.parameters[0].type = "DECIMAL";

1 Answer

0 votes
by (13.5k points)
can you try with parameters[0].type = VARCHAR

Related questions

+1 vote
1 answer 110 views
0 votes
0 answers 83 views
0 votes
0 answers 21 views
0 votes
1 answer 461 views
0 votes
0 answers 25 views
0 votes
2 answers 376 views
0 votes
1 answer 54 views
0 votes
1 answer 95 views
0 votes
0 answers 42 views
...