Sun
ONE Active Server Pages Product Home Page Developer Site Version
 

ContentsPreviousNextIndex



Executing SQL Statements


Use the following procedure to execute SQL statements.

To execute SQL statements

  1. Open DBMS using the URL provided by your Sun ONE ASP administrator.

  2. Do one of the following:

    • To execute an existing SQL statement, click the words SQL Statements in the left pane, and then click Execute in the right pane in line with the SQL statement you want to execute.

    • You can also click a specific SQL statement in the left pane, and then click Execute in the right pane.

      - or -

    • To add and execute a new SQL statement at the same time, perform the procedure described in Adding SQL Statements.

    • After clicking Execute to run the query, results are returned to the Query result box in the right pane as either a recordset or a message.

      If the query returns a recordset, the result is listed by pages. Otherwise, a message of some type displays. If the query is unsuccessful, an error message displays.

      Note icon Note The #shown box displayed with query results specifies how many records should be displayed. This number is set to 20 by default. To see a different number of records, change the number in the box and then click Refresh. If the total number of records exceeds the number shown, use the navigation buttons (< > symbols) in the lower right corner to navigate through the records. Clicking << or >> takes you to the first or last set of records. Records are displayed in increments of the number in the #shown box.

See also:

Working with SQL Statements



ContentsPreviousNextIndex