Select 'ALL' in LOV

There are two parts to the issue. First part is getting ALL into the LOV query. Second part is properly handling the event when a user selects ALL in response to the prompt. The code you have does not handle ALL properly in the resulting SQL.

Handling ALL in a Prompt


Dave Rathbun :us: (BOB member since 2002-06-06)