Dan
You can try this
SET VAR vserialt = ('(' + .vserialt + ')')
update orders99 set shipdate = .vshipdate where serial in &vserialt
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of Dan
Goldberg
Sent: Wednesday, March 30, 2011 9: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
