Hi Bill, Thanks again for the help but im not hard coding any single quotes.
in the place of Clause in the insert statement, im actualy putting something like: '<@var local$myvar encoding=sql>' which that above should produce propperly sql encoded text no matter what is in the variable, right? If not, how could we rely on it at all? Thanks again, but im just goign to submit this as a bug and see what comes of it. ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, August 08, 2003 9:27 AM Subject: [RBASE-L] - Re: SQL problem > On Fri, 8 Aug 2003 09:10:08 -0700, Atrix Wolfe wrote: > > >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>. > > Atrix, > > The SQL you get after Witango is done with it almost always runs exactly > the same at the R>. The "not enough memory" error is almost always a > result of a mismatch in either quotation characters or parentheses. > > Try this: In your direct DBMS, don't "hard-code" any single or double > quotes. Use the meta tag <@SQ> for your single quotes, and the meta tag > <@DQ> for your double quotes. (When I use @DQ, for some reason, I > always get hungry for soft-serve ice cream.) > > Bill >
