Martin Perrie 25.Sep.14 09:39 AM a Web browser Connector for OLE DB LC LSX - All Releases Windows
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.