Thanks for everyones advice on my problem, I was able to, with your help, show the company a loss of about $75,000 in missed billings. You guys are great! ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, October 19, 2003 5:38 PM Subject: [RBASE-L] - Re: Quarterly Review
> 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) > > > > > > > > > > > > > >
