String to varchar2

From: lil_gd <member24947_at_dbforums.com>
Date: Fri, 14 Feb 2003 07:26:00 +0000
Message-ID: <2528854.1045207560_at_dbforums.com>


hi!
i'm trying to convert a string to varchar2 in vb, i made a connection like this:

Set OraSession = CreateObject("OracleInProcServer.XOraSession")

Set OraDatabase = OraSession.DbOpenDatabase("ORANTSIN", "gerrit/jiggaman", CInt(1))

Set rst = OraDatabase.DbCreateDynaset("select * from archivesdocu2002", CInt(1))

and i'm trying to insert like this:
With rst
Addnew
fields("serie") = "test"
update
close
end with

serie is here a varchar2(4) and the result i get in the table is "??",

What must i do to get the right information in my oracle table?

--
Posted via http://dbforums.com
Received on Fri Feb 14 2003 - 08:26:00 CET

Original text of this message