Your Awesome!!

That did it. I would never think to put the ampersand there.

Thanks again

Dan
  From: Lawrence Lustig 
  Sent: Wednesday, March 30, 2011 6:55 AM
  To: RBASE-L Mailing List 
  Subject: [RBASE-L] - Re: Using update command


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


Reply via email to