numeric data in 7.3 and 8i

[mixc]

I'm working with a client/server VB app. Our production server is 7.3.3.0.0<br>and our test server is Oracle8i Enterprise Edition Release 8.1.5.0.0 . <br>Here is my problem. The app works fine off the production server (7). But on<br>the test server(8), it doesn't. <br>Here is the code that crashes:<br>adoRSExample!ExampleField = CDbl(Format(intExample, &quot;####.#&quot) <br>It works if there are no decimal places. 43 works but 43.3 crashes. <br>This field in the database is NUMBER with no size,decimal formatting.<br><br>

 

[listener22]

&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;What is the data type declaration for intExample?&nbsp;&nbsp;Should it <br>take a value like 43.3, given its data type? <p>Jim Carlson<br><a href=mailto:nx56@inetarena.com>nx56@inetarena.com</a><br><a href= > </a><br>oracle, vb, some javascript