Home » Infrastructure » Windows » Oracle number format in VB
Oracle number format in VB [message #100629] Tue, 18 March 2003 23:52 Go to next message
lalitha
Messages: 39
Registered: June 2002
Member
I have connected Oracle8i and VB6 using ADODC.When I created the table in Oracle ,I gave the format for a field EmpNo as NUMBER(4).When I displayed this field in VB6 using MS Data Grid Control only zeros were displayed.However if I give the format in Oracle as just NUMBER ,the correct values are displayed in VB.Please tell me what I can do to display formatted numbers in VB.
Re: Oracle number format in VB [message #100677 is a reply to message #100629] Wed, 30 April 2003 10:09 Go to previous messageGo to next message
Daniel Tsai
Messages: 8
Registered: November 2001
Junior Member
I have two Os system:Win98 and Win2000 running the same program(vb6 application connect Oracle 9). It is working fine in Win2000, but the same problem happens in Win98. Does that mean that ADO library file in Win98 is the too old and need to be updated?
Re: Oracle number format in VB [message #100678 is a reply to message #100629] Mon, 05 May 2003 13:07 Go to previous message
Daniel Tsai
Messages: 8
Registered: November 2001
Junior Member
Finally, I know what happen here. Try to update ODBC driver to 8.17 or newer, it should be working.

Daniel
Previous Topic: Interception of SQL statements.
Next Topic: Error messages : ORA-12560
Goto Forum:
  


Current Time: Mon Nov 25 16:41:10 CST 2024