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
>
>
>
