Bill U da man, I didn't have any EEP's but you got me thinking and I forgot all about Break Points and that was my problem. Being Green, energy efficient or just plain Lazy, I copied this report from another table. So much for time saving ideas!
Thanks for jogging my RBrain Marc From: Bill Downall Sent: Monday, August 10, 2009 4:20 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Strange error Marc, In the designer, use Report/"Document Custom Eeps", and make sure there are no eeps that refer to spdate or use a LIKE operator. Also, on the "View" menu, open the "Toolbar" called "Object Tree", and look for any objects on the report that are not visible (either because they are outside the margins or behind other objects) Bill On Mon, Aug 10, 2009 at 5:09 PM, MDRD <[email protected]> wrote: I am working on a report and this error has me stumped. error invalid use of Escape character with Like operator 716 These are the report vars 1 : DATE : PH : vdatecon = date_con in tran_hist where (custnum = custnum and tr_date = txdate) 3 : TEXT : PH : vdiag1 = diagnum1 in ptdiag where (custnum = custnum and date_con = .vdatecon) 7 : ERROR : PH : vICDA1 = ICDAnum in Diagnos where (DIA_CODE = .vdiag1) The rows of data in the table fail the #1 var but I didn't think that would cause this? There are no Like operators anywhere I can find Also when I try to preview or run the report I get an error about spdate not found but I do not have that column located on the report on in the view. Anything else I should look for? Thanks Marc
