i am using a direct DBMS yes. I pasted the sql that errored, (grabbed it from the debug output) and pasting that sql at the R> gives the error too.
I could paste or send the code but its not that simple code and has worked fine until now and while you would be combing over my tango code saying "this might be the problem" i found actual sql that should be working but isnt so im sure the problem isnt in the witango side, nor in the oterro side (alone) since its reproduceable at the R>. make sense? you shouldnt need to see the tango code that generated this sql that SHOULD be working. doesnt matter how it was created, just that it doesnt work when it should IMO. If you really want i can send the .taf though (; ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 9:04 AM Subject: [RBASE-L] - Re: SQL problem > Atrix, > > Are you using a Direct DBMS? > > Can you copy and paste your tango code into a message? > > Bill > > On Fri, 8 Aug 2003 08:58:27 -0700, Atrix Wolfe wrote: > > >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). > >
