AnsweredAssumed Answered

vrf VEE and ORACLE

Question asked by fduenas on Feb 27, 2005
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META http-equiv=Content-Type content="text/html; charset=iso-8859-1"><META content="MSHTML 6.00.2800.1491" name=GENERATOR></HEAD><BODY><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005>Hi VRF,</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005>I'm developping a VEE 6.2 application to get data from an Oracle database.</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005>I+ALQ-m using ADODB (Microsoft Active Objects 2.7 Library).</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005>I can conect to the database, get records, get values from string fields (VARCHAR type) but I can't get values from numeric fields (INT, INTEGER, NUMBER types).</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005>The error appears  when I apply the property Value (which returns a variant) to a Fied object. </SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005>This kind of error does not appear with a MYSQL database.</SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005><SPAN lang=EN-GB style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Any Help would be appreciated.</SPAN></SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005><SPAN lang=EN-GB style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005><SPAN lang=EN-GB style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Best reagards</SPAN></SPAN></FONT></DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005><SPAN lang=EN-GB style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></SPAN></FONT> </DIV><DIV><FONT face=Arial size=2><SPAN class=132494610-28022005><SPAN lang=EN-GB style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">PAco</SPAN></SPAN></FONT></DIV>-------------------------------------------------------------------------------------------------------------------
Este correo electr+APM-nico y, en su caso, cualquier fichero anexo al mismo, contiene informaci+APM-n de car+AOE-cter confidencial exclusivamente dirigida a su destinatario o destinatarios. Queda prohibida su divulgaci+APM-n, copia o distribuci+APM-n a terceros sin la previa autorizaci+APM-n escrita de Indra. En el caso de haber recibido este correo electr+APM-nico por error, se ruega notificar inmediatamente esta circunstancia mediante reenv+AO0-o a la direcci+APM-n electr+APM-nica del remitente.

The information in this e-mail and in any attachments is confidential and solely for the attention and use of the named addressee(s). You are hereby notified that any dissemination, distribution or copy of this communication is prohibited without the prior written consent of Indra. If you have received this communication in error, please, notify the sender by reply e-mail---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>  

Outcomes