Martin Perrie 25.Sep.14 04:39 PM a Web browser Connector for OLE DBLC LSX - All ReleasesWindows
I have inherited an application that uses LC LSX to read data from SQL Server into Notes. All works fine with the exception of the read of a numeric value where the value is less than 1.
In this case the value is being truncated to one decimal place, so a value of 0.71 on SQL Server is being retrieved as 0.7.
If the value is greater than 1 then it is retrieved correctly with 2 decimal places and the value in Notes matches that on SQL Server.
The column on SQL Server is defined as numeric(15,2) and the record is being retrieved with a simple select statement. If the same SQL statement is executed from SQL Server Management Studio, then the correct value is retrieved (as one would expect).
Any ideas, thoughts, suggestions much appreciated.
Return to top
Numeric data from SQL Server gettin... (Martin Perrie 25.Sep.14)
. . 
Print this page
