Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Productivity Tools > WHERE Builder

Prompting the User for WHERE Conditions

Scroll Prev Top Next More

When you assign actions to menu options in the Application Designer, you can specify WHERE clauses to limit the rows of data for that action. You can also use a feature that allows you to prompt the user for WHERE conditions by entering the following line in a WHERE clause: @'prompt'.

 

For example, you want to prompt the user for a customer ID number from the Customer table. In the "Where Builder" dialog box, select the custid column and use: = @'Enter Customer ID:'

 

WHERE clause examples