Hi!
I'm trying to add a value of 'All' to the LOV for a variable called site, and have All act to select all the values.
I've got a Site variable, a Site LOV variable (that successfully add's 'All' to the LOV using a union in the sql with sys.dual), and a Site Test variable I've been trying to work with in order to have it act like Site, but accept All as a valid choice.
right now, I have a select statement for Site Test with the followiing in it:
SITE in @Prompt('enter field','A','Site\Site LOV',MULTI,FREE) or 'ALL' in @Prompt('enter field','A','Site\Site LOV',MULTI,FREE)
i checked the sql for the SiteTest object and it looks like this:
SELECT DISTINCT
SITE.SITE
FROM
SITE
The error I'm getting is this:
ORA-00923: FROM keyword not found where expected :-923
Any ideas out there? Thanks everyone! Barrett
I'm trying to add a value of 'All' to the LOV for a variable called site, and have All act to select all the values.
I've got a Site variable, a Site LOV variable (that successfully add's 'All' to the LOV using a union in the sql with sys.dual), and a Site Test variable I've been trying to work with in order to have it act like Site, but accept All as a valid choice.
right now, I have a select statement for Site Test with the followiing in it:
SITE in @Prompt('enter field','A','Site\Site LOV',MULTI,FREE) or 'ALL' in @Prompt('enter field','A','Site\Site LOV',MULTI,FREE)
i checked the sql for the SiteTest object and it looks like this:
SELECT DISTINCT
SITE.SITE
FROM
SITE
The error I'm getting is this:
ORA-00923: FROM keyword not found where expected :-923
Any ideas out there? Thanks everyone! Barrett