<< update orders99 set shipdate =.vshipdate where serial in (.vserialt) When I try the command it gives me the error: ERROR - Column Integer must be compared to Integer values (2042) >>
At some point R:Base was enhanced to allow the following: UPDATE Orders99 SET ShipDate = .vShipDate WHERE Serial IN ( &vSerialT ) Give that a try. (You didn't used to be able to put the ampersand after the left parenthesis, but you can in recent versions of 7.6, at least). -- Larry
