It works at the R> but the report throws an error. I will keep experimenting...
Dan From: [email protected] Sent: Thursday, August 09, 2012 11:32 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: RStumped 9.5 64 - CORRECTION I have never been able to successfully put a dotted variable inside parenthesis like you do in your 2nd variable. I always create a where clause, but I'm not sure you can do this within a report. For example: SET VAR vWhere = ( '(' + .vserialnums + ')' ) SELECT ALL FROM tablename WHERE serial IN &vWhere Karen In a message dated 8/9/2012 1:01:20 PM Central Daylight Time, [email protected] writes: I am working on a report and have a couple of variables. vserialnums text = (listof(serial)) in orders99 where shipdate = shipdate and shipdriver = shipdriver and model in (select model from basepric where typeofunit = .vetype) order by serial vtotalwgt integer = (sum(wgtlbs)) in tmpconwgtvw where serial in (.vserialnums) When I try to save the vtotalwgt it gives me the error “Error – Column SYS_INCREMENT must be compared to INTEGER VALUES(2042): I have never seen that error before. I try it at the R> and the variables work if I put in the serial as 164545 or ‘164545’ But it does not work if I reference the vserialnums variable. TIA Dan Goldberg
