ONE Active Server Pages Product Home Page Developer Site Version


Editing Data

Use the following procedure to edit data (records) in an existing table.

Note icon Note TIME values in Sun ONE ASP DBMS are displayed in HH:MM:SS format ONLY. The -HHH:MM:SS to HHH:MM:SS formats supported in MySQL are not supported in DBMS. Therefore, if you are viewing a MySQL database that uses these unsupported TIME formats, the time will not display correctly in the DBMS tool. Likewise, TIME values cannot be entered in unsupported formats; HH:MM:SS must be used.

To edit data

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

  2. Do one of the following:

    • Expand the Tables node and click a specific table.

    • - or -

    • Click the word Tables under a database connection in the left pane, and then click Edit data in the right pane in line with the table you want to edit.

    • The table opens on the Edit data tab by default, displaying record rows. Each record row has an edit link.

  3. In line with the record you want to edit, click edit.

  4. In the form that displays, make changes as desired and then click Update to submit the selected changes (records with changes will be selected by default).

  5. The edited data displays on the Edit data tab and your changes will be saved (if the changes are not visible, you may need to refresh your browser by right-clicking in the pane and then clicking Refresh).

Note icon Note The Edit data tab also provides a navigation bar used to navigate records. When a table is open, the first 20 rows of records are displayed by default. To change the number of records displayed, change the number in the #Shown 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.