I'm trying to set up an interface text file between 2 systems. I'm reading an SQL database with fields defined as
REAL, therefore values like 7.0, 12.5, 8.28, 41.999 etc with a maximum of 3 decimal places.
The target system needs these values put in the interface
file into a field 18 characters long with 15 characters for
the pre-decimal, 3 for the post-decimal, but NO decimal point. i.e,
7.0 becomes " 7000"
8.28 becomes " 8280"
41.999 becomes " 41999" etc.
Could anyone explain to me how best to use the various
conversion functions etc in VB5 to do this.