I just tried that. It gives me the same error. Dan From: Jim Belisle Sent: Wednesday, March 30, 2011 6:51 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Using update command
Dan, I think you can use the NINT command to change the var back to Integer update orders99 set shipdate = .vshipdate where serial in (NINT(.vserialt)) James Belisle ------------------------------------------------------------------------------ From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, March 30, 2011 8:45 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Using update command I have a eep to update rows of data that are multi-selected from a variable list view. The serial is an integer that when selected is placed into a text variable called vserialt This is what is in the variable when multiples are selected: vserialt = 311124,311509,168050 I want to update the table based on the list selected: 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) If I change the variable to an integer it only stores one number selected because it cannot store the commas. The only other way I can think of is to use a cursor to update them one at a time but that does not seem very efficient. Has anybody ran into this and found a solution? TIA Dan Goldberg
