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";