OK…I’ve searched here. I’ve searched the KB and KX. I’ve found a million possible causes for my problem, but nothing definitive.
I’ve created my custom prompt so that “ALL” (in one form or another!) is displayed at the top of my LOV. I set it as multi and constrained. It works beautifully in full client. It works in ZABO. It is a synchronous connection. I’ve set the LOV to be exported with the universe.
In Webi, there is no LOV…and I can enter anything I want! This worked correctly before I added the “ALL”. The one suggestion in the KB says that this can be caused by the @prompt LOV being based on the same objects as where the WHERE clause is located and that this creates a loop. I can’t imagine that’s the cause because then it shouldn’t work in full client either, right?
Here the code for my object. The object is in a Class called Prompts. This objects is called Prompt Location.
Here is my select…
@Select(Registered Users\Facility)
Here is my where…
(@Select(Registered Users\Facility) IN @Prompt('Select Location or ALL','a','Registered Users\Facility',multi,constrain) ) OR ('.ALL' in @Prompt('Select Location or ALL','a','Registered Users\Facility',multi,constrain) )
Here is the sql generated by the query in full client…
SELECT
( LOCATION.FACILITY )
FROM
LOCATION
WHERE
( (( LOCATION.FACILITY ) IN @Prompt('Select Location or ALL','a','Registered Users\Facility',multi,constrain) ) OR ('.ALL' in @Prompt('Select Location or ALL','a','Registered Users\Facility',multi,constrain) ) )
I’m so confused!!!
Eileen King (BOB member since 2002-07-10)