Where Clause Tab

You use the where clause to set conditions for the attributes in your database operation. To add a where clause, click the Add Where Clause button. After you add a column, you can click the column name and select a new name from the drop-down list box. To remove a where clause from your operation, select the attribute that you want to remove and then click the Remove Where Clause button. You change the condition (and/or) by clicking the condition in the row that you want and selecting a condition from the drop-down list box. You change the operator by clicking the operator in the row that you want to change and selecting an operation from the drop-down list box.

After you complete the specifications for your Update call, click Next to see a preview page. The preview page shows a conceptual SQL statement based on the specifications you have entered. You can use the Back button to return to a previous page and modify your specifications. When you are satisfied with the specifications you have entered, click Finish. The wizard creates an Update database operation call where your cursor is located, and it produces accompanying code. You must modify the Update call to include the appropriate value objects and you must complete the generated code.