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.
