You could keep your vserialnums in the report variable section Remove vtotalwgt from the variable definitions
In the appropriate before generate eep use this code; In the report before generate eep: Set var vtotalwgt integer In the appropriate before generate eep: Set var vTmp = (‘(‘ + (.vserialnums + ‘)’) Select (sum(wgtlbs)) into vtotalwgt from tmpconwgtvw where serial in &vTmp Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, August 09, 2012 1:21 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: RStumped 9.5 64 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 &vWhere Karen In a message dated 8/9/2012 1:01:20 PM Central Daylight Time, [email protected]<mailto:[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
