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! --
