Happy Hump Day! (Wednesday) Do I understand correctly that it is not necessary/advisable to use an INDICATOR variable with aggregate functions such as SUM, COUNT, etc.?
The reason I'm asking is that in testing v9.1 - 64 some of my programs that use this scenario stops R:BASE in its tracks. Here's an example where R:BASE gets to this command and then just drops back to the R>. SELECT COUNT(*) INTO VCNT INDICATOR VIND FROM REJ_VIEW + WHERE DISPDATE = .VPREVIOUS AND IQL_SMRY = .VM AND IQL_FLAG = .VQ + AND SEQNUM NOT IN (SELECT RJCT_SEQNUM FROM REWIND_EXCL) + AND REJ_AREA = .VINT AND HOLDSTAT = .VI Taking the INDICATOR out makes R:BASE happy again. Any thoughts? Thanks Mike Ramsour Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
