You could change your WHERE clause to something like this:
WHERE CustNb = ?MyCustNb OR ?ShowAll = .T.
You could then get all customers records by initializing MyCustNb to the customer number and ShowAll to .F. To get all records, you set ShowAll to .T.
HTH
>I have created a parameterized view which is parameterized on a integer type field relating to customer table, so if I want to only show certian customers records I pass in the customer key. My question is how can I view all the customers records?