Assign a 4d Real to a SQL NUMERIC(19,5) Different in V11.3

Jacques Chatenay (11/21/08 5:43 PM)

<be167e940811211543n1bd28b97o49434bc69af74075@...

11.3 is driving me crazy :-)

In v11.2 the following would assign 70.7857 to CURRCOST in v 11.3 it

assigns 71 how can I get 11.3 to assign the real instead of the

rounded integer

C_TEXT(v_I_Part_No_T)

C_REAL(v_I_Unit_GP_Cost_R)

v_I_Part_No_T:="15FC0MPLETEC018"

v_I_Unit_GP_Cost_R:p.7857

SQL LOGIN("MSSQLDATABASE";"User";"Password";*) (Note in 11.2 this was

USE EXTERNAL DATABASE)

Begin SQL

     UPDATE IV00101

      SET CURRCOST = :v_I_Unit_GP_Cost_R

      FROM AMI02.dbo.IV00101 IV00101

      WHERE (IV00101.ITEMNMBR= :v_I_Part_No_T )

End SQL

SQL LOGOUT

Any help would help me keep what little sanity I have left:-)

Jacques Chatenay

Reply to this message

Summary created 11/22/08 at 2:05AM by Intellex Corporation

Comments welcome at: feedback@intellexcorp.com