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
