Try: SET VAR custom_start_month INTEGER = null; SELECT COUNT(*) INTO vmaycount FROM ahl2 WHERE custom_start_month = 5
Sent using OWA for iPhone ________________________________ From: [email protected] <[email protected]> on behalf of lwilson <[email protected]> Sent: Sunday, July 9, 2017 7:57:29 PM To: RBASE-L Subject: [RBASE-L] - "Error - Invalid Text Value (2418)" message 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]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout<https://groups.google.com/d/optout>. ATTENTION: This message and all attachments are PRIVATE, and may contain information that is CONFIDENTIAL and PRIVILEGED. If you have received this message in error, please notify the sender by reply e-mail and delete the message immediately. To unsubscribe from marketing and sales emails, please click unsubscribe.<http://go.pardot.com/l/142011/2017-03-10/3gcm4q> -- 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.
