How to pass a parameter list into the "where" cause of a select query

[BenjaminLim]

How to pass a parameter list into the "where" cause of a select query on Oracle Forms 4.5?

The parameter list allows the user to tick off the company code that they need but it could be left blank to indicate the selection of all company codes.

The parameter list will be invoked with the press of a button which will display company code & description.

Please help & do provide example.

Thanks in advance.

Regards
Benjamin

 

[sem]

You may set where clause by setting default_where block property to anything you need. You may also use a LOV on base table item and display it in enter-query mode.

 

[BenjaminLim]

Sem
Could you demonstrate with an example.
Regards
Benjamin

 

[BenjaminLim]

Sem,

Is it possible to provide email so that I could send the query and printscreen for further discussion.

Thanks.