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
