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>
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.comReceived on Fri Feb 14 2003 - 08:26:00 CET