Creating an SQL Query

See Also

After you connect a database to the IDE, you can access the database tables in the database connection. By default, the IDE retrieves all data in a given database table. To retrieve a specific part of the data, create an SQL query in the Visual SQL Editor. An SQL query determines which data to retrieve from or write back to the table in the database connection. A typical SQL query might be a SELECT statement that determines which rows to retrieve based on restrictions in the WHERE clause.

To create an SQL query:

  1. Add a database table to a page.
  2. In the , right-click the table-nameRowSet item and choose Edit SQL Statement.
  3. In the Visual SQL Editor, edit the query.

    You can create the query graphically by using the top two panes or type and edit the SQL code in the third pane.

  4. When you finish editing the SQL query, click the page-name tab to return to the Visual Designer.
See Also
About the Visual SQL Editor
Add Query Criteria Dialog Box
Supported SQL Queries
Working with Databases with Visual Web JSF Applications
About Components and Data
About Binding Components to Data

Legal Notices