Thanks Razzak, but I don't have any commands like that, all right side comparisons have a value or a variable.
This automated routine worked as is for years (with occasional small changes), and then failed multiple times in one night causing a cascade of other failures based on the results of this routine. It creates an emailing queue of data, based on information written to our database by UPS Worldship and FedEx, that we email out each night. The results were customers receiving multiple copies of shipping notifications. It only seems to happen when run from an unmonitored automated task. I think I will put some error trapping that writes to a log file on all commands I might suspect. Kenny -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, June 20, 2013 1:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error code 2295 - missing right side ofcomparison At 01:41 PM 6/20/2013, Kenny Camp wrote: >List, > >What cause the error Error code 2295 - missing right side of comparison? > >I've tried recreating it with no luck. If variable is undefined 2515, >if not found 2059, if null 2059. Also tried in a sub-select. > >It happened in an automated routine and I haven't been able to find >which command caused it. > >As a work around, I have that message ( and all error messages) turn >off, but would like to discover what is causing it. Kenny, You have entered a command with a WHERE clause or a lookup expression for a form or report and omitted a comparison value on the right side of the operator. -- For example: SELECT ALL FRO Contact WHERE ContID >= Notice that there is no value after the operator. Hope that provides you with some blue's clues ... Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
