Maybee you found a bug in the Oterro driver. Make sure you have the latest version. Try doing an insert with your primary information and then update the field with the embedded quotes instead of inserting it.
One other route would be to write it out to a file and then load the file into the table. When I add blobs through tango, I insert the row w/o the blob, writ the file to the disk, and then update the row with the file. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Atrix Wolfe Sent: Friday, August 08, 2003 9:58 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL problem unfortunately thats not the problem the actual string im inserting into the database has single quotes in it so i have to sql encode it (meaning the single quotes double up becoming double single quotes). going through r:tango it created the error and i was thinking "what the heck?", so i pasted it into the R> prompt and got the same results (it errored again w/ same error message). ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 8:54 AM Subject: [RBASE-L] - Re: SQL problem > AHA! > > The Tango interface may be doubling your quotation characters, assuming it > is inside an SQL statement! Be sure you use ENCODING=NONE. > > Turn on debuggining in your TAF, and look at the SQL after it is processed by > tango. It sounds like it is encoding your string wrong, so that it ends up > without a termination, hence the insufficient memory error. > > Bill > > On Fri, 8 Aug 2003 08:46:14 -0700, Atrix Wolfe wrote: > > >I wish that would help but as im using r:tango i dont think i have that > >option ): > >
