flanapa_wipro

OLEDB upgrade causes change in number precision output

Discussion created by flanapa_wipro on Feb 26, 2013
Latest reply on Feb 26, 2013 by flanapa_wipro

Hi,

 

After a sequence of upgrades and migrations we have the following symptoms.

 

With PI-OLEDB version  3.1.0.0 numeric outputs were padded or chopped to give fixed width output.  eg. 12.3456789 becomes 12.3456 (7 chars) 12.34 becomes 12.3400 (7 chars)

 

With PI-OLEDB version 3.3.0.1 no padding or chopping 12.3456789 is written as 12.3456789 and 12.34 stays as 12.34

 

Is there some setting or config in the new PI-OLEDB which will allow output to be padded like above?

 

The code used to produce the outputs is from a 3rd party and we are told that it does no padding or chopping of its own.

 

Any ideas?

 

Thanks,

 

Paul

 

 

Outcomes