Atrix, You're right, in the INSERT syntax, the doubled quoting cause Oterro/R:Base to gag.
This works fine, but that doesn't help you from a direct DBMS action in WiTango: SET VAR vJunk TEXT = + ',''1'',''2'',''3'',''4'',''5'',''6'',''7'',''8'',''9'')' insert into AcctPriv + (UserAppno,approval,Clause) + values + ( 1245, 'N', .vjunk ) And if you look at the variable vJunk, the doubled characters have all been shrunk down to the quotation characters you wanted. Again, no help with Oterro from a different front end. By the way, if there's any chance that the data being extracted by your where clause would not have spaces in it, Oterro will let you get away without the quote marks: ',1,2,3,4,5,6,7,8,9)' Bill Bill On Fri, 8 Aug 2003 09:52:20 -0700, Atrix Wolfe wrote: >thanks for the work around (: >its not mission critical so im not real worried about it at the moment. >just wanted to share so it could be resolved in case it became mission >critical for myself or anyone else.
