| in Operator [message #21441] |
Sat, 03 August 2002 06:04  |
A Rahim
Messages: 2
Registered: August 2002
|
Junior Member |
|
|
When I use <in> operator in forms to update, I am getting invalid number error. Actually query is like this
:TEXT_BOX = '7,8,9';
UPDATE TABLE SET ABC_NO = 234 WHERE EFG_NO IN
(:TEXT_BOX);
Any Help.
|
|
|
|
| Re: in Operator [message #21443 is a reply to message #21441] |
Sat, 03 August 2002 06:18  |
Su
Messages: 154
Registered: April 2002
|
Senior Member |
|
|
You can not give a single string, consists of values seperated by comma, for the IN operator's use and let it go. You should give a list of values and then process it. Better you extract the values first from the string and then put them in the IN list. You could use INSTR() and SUBSTR() for this extaction, looking for a comma character and extracting the letters or numbers.
Good luck :)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
