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>

 

[MikeLacey]

so what does a &quot;describe&quot; on the table - in both environments - return? <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>

 

[mixc]

NUMBER