Thanks , will tray it now. LW
_________________________________________ Larry Wilson President & CEO Promesa Consulting Group, Inc. 1717 N Street NW, Suite 400 Washington, DC 20036 (O) 202-808-8836 (F) 202-808-8837 (C) 202-733-7006 [email protected] CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review; use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. > On Jul 9, 2017, at 9:08 PM, A. Razzak Memon <[email protected]> wrote: > > Larry, > > If the script worked last week, and now it doesn't work, what has changed? > > R:BASE doesn't change logic automatically on Sundays <g>. > > Did you change the Customer_Start_Month column from INTEGER to TEXT? > > If yes, you will need to enclose the value with quotes. > > If the Customer_Start_Month column is still INTEGER, then, FWIW .... > > Try the following syntax: > > SET VAR vMayCount INTEGER = 0 > SET VAR vJuneCount INTEGER = 0 > SET VAR vJulyCount INTEGER = 0 > SELECT COUNT(*) INTO vMayCount INDIC iv1 FROM AHL2 WHERE Customer_Start_Month > = 5 > SELECT COUNT(*) INTO vJuneCount INDIC iv1 FROM AHL2 WHERE > Customer_Start_Month = 6 > SELECT COUNT(*) INTO vJulyCount INDIC iv1 FROM AHL2 WHERE > Customer_Start_Month = 7 > > SHOW VARIABLES > > Try the exact example and see what you find. > > Hope that helps! > > Very Best R:egards, > > Razzak > > At 07:57 PM 7/9/2017, lwilson wrote: > >> Running this simple continues to give "Error - Invalid Text Value (2418)" >> message. >> I used this script last week, now it won't work. What am I doing wrong? >> >> >> COMPUTE vMaycount AS COUNT ALL from AHL2 where Customer_Start_Month = 5 >> COMPUTE VJunecount AS COUNT ALL from AHL2 where Customer_Start_Month = 6 >> COMPUTE vJulycount AS COUNT ALL from AHL2 where Customer_Start_Month = 7 >> >> I tried substituting ROWS for ALL as well as a valid column name. > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
