Thanks Razzak, I believe that might be it. R>set lightbulb on
I remember an insert command, that inserts columns and variables into another table, that gave me an error something like "incorrect number of columns" and when I enclosed the variables with parentheses it worked as expected. Kenny -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Thursday, June 20, 2013 1:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Error code 2295 - missing right sideofcomparison At 02:37 PM 6/20/2013, Kenny Camp wrote: >I think I will put some error trapping that writes to a log file on all >commands I might suspect. Kenny, That is the most appropriate thing to do. In addition, if the "value" for the right side of the operator is TEXT, and if there is a possibility of that value as NULL, you may want to enclose that value in parentheses. -- Example: -- When vPONumb (TEXT) is defined as global variable SET VAR vTotAmount CURRENCY = 0.00 SELECT (SUM(TotAmount)) INTO vTotAmount INDIC iv1 + FROM InvoiceHeader WHERE PONumb = (.vPONumb) In this particular example, if the vPONumb is NULL, R:BASE expression parser will not generate the -ERROR- 2295 regarding the missing right side of comparison. Hope that helps! 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! --
