Also, since you are using the "*" be sure the list of columns matches exactly and in the same relative order between the two tables. If they do not match exactly, type the exact list of columns.
Sami ----------------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 mailto:[EMAIL PROTECTED] 913-915-1971 ----- Original Message ----- From: "Bill Downall" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 1:26 PM Subject: [RBASE-L] - Re: Quarterly Review > Ron, > > Be sure your variables have the right data types for the data, and that none > of them is null. Just a guess. > > Bill > > On Fri, 17 Oct 2003 11:53:51 -0600, Plateautel.net wrote: > > >My question evidently got lost somewhere, so I'll ask again. > > > > > >Can someone tell me what is wrong with this code? > > >I get an error "Invalid use of escape character like operator(716) > > >Insert into no_150 + > >Sel * + > >from services + > >whe Unit = '102' and + > >Svc_begin_dte between .vstartqtr2 and .vstopqtr2 and + > >Case_no not in + > >(sel Case_no from services whe Svc_code = '150' and + > >Svc_begin_Dte between .vstartqtr and .vstopqtr) > > > > > > >
