how can i get All in my prompt

[system]

Hi,

how can i get all values in my prompt list other than available LOv’s

ex:L

ALL – i want disply this in my prompt
123
432
456

---

rao_marapatla (BOB member since 2008-08-06)

[system]

Hi,

Check this Designer’s FAQ:

FAQ: Designer

Now that my LOV lets me use ALL for all values, how do I get the ALL in the list? Author: Dwayne Hoffpauir There are two approaches - overriding the LOV SQL, and creating a universe object. Overriding the LOV SQL Press the SQL button in the query panel of the LOV Add the phrase UNION SELECT ‘ALL’ FROM DUAL or similar dummy table for your particular database. For SQL Server (if you don’t care if the object parses or not) add SELECT xx From xx UNION SELECT ‘ALL’ (You don’t need a FRO…

---

Marek Chladny (BOB member since 2003-11-27)

[system]

[Moderator Note: Moved to Universe Designer - Jansi]

---

Jansi (BOB member since 2008-05-12)