Re: String to varchar2
Date: Fri, 21 Feb 2003 16:30:38 GMT
Message-ID: <Ous5a.11604$FF4.632148_at_newsb.telia.net>
Try with a
fields("serie").value = "test"
"lil_gd" <member24947_at_dbforums.com> skrev i meddelandet
news: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 21 2003 - 17:30:38 CET