Use an SQL query menu item and have the string passed to an SQL function as in
select myfunc('$string-field$') from dual
Note that the Menu definition cannot use field names (as it is not attached to
a form) and so string-field will have to be the ID of that field and if you
were to use that same menu elsewhere, you would need to have the field id
contain the same sort of data.
You will need to create myfunc() which should be fairly trivial.
Cheers
Ben Chernys
>----- ------- Original Message ------- -----
>From: ramakanthvarma bhupathiraju
><[EMAIL PROTECTED]>
>To: [email protected]
>Sent: Tue, 12 Dec 2006 17:17:40
>
>Hi list,
>
>Require help on the below scenario:
>
>1) I have some data seperated by comma in a
>character field in a
>display only form.
>2) I should be able to get the data into a menu.
>
>Is there a possible workaround.
>
>EX:
>In a Display only form there are two fields
>1) test list (character field)
>2) test menu (character menu)
>
>I have typed some data like "john, mary, mike,
>demo" in the 'test list' field.
>I should be able to access the above values listed
>in the 'test list'
>field as menu items in 'test menu' field when I
>select the menu, like
>below
>john
>mary
>mike
>demo
>
>Note: the data is not available in the database
>yet.
>
>thanks and regards,
>Bh.Ramakanth Varma
>
>___________________________________________________
>____________________________
>UNSUBSCRIBE or access ARSlist Archives at
>www.arslist.org ARSlist:"Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
