This is a long shot, but have you checked this code with R:Code?
Syntactically it looks good assuming your variables are correctly declared
and typed.  I was just wondering if there's a possibility of a <Tab>
character or some other non-printing character embedded here somewhere.
I've had users who like to save their R:Base code in MS Word.  When they try
to run their code it gives R:Base a major case of heartburn because of the
embedded formatting characters.  When you check the code with
R:Code/R:Syntax it will strip out the hidden characters (if I understand
correctly).
 
If that's not the case, is there a possibility of any database corruption?
 
Just some thoughts.
 
Mike Ramsour
c/o AK Steel
740-829-4340

-----Original Message-----
From: Plateautel.net [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 1:54 PM
To: [EMAIL PROTECTED]
Subject: [RBASE-L] - Quarterly Review


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)

Reply via email to