Sun ONE Active Server Pages Product Home Page Developer Site Version
 

ContentsPreviousNextIndex



You are here: Using Database Tools > DBMS > Working with Tables > Updating Existing Tables > Adding Data

Adding Data

Use the following procedures to add data (records) to 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 add 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, and then click Edit data in the right pane in line with the table you want to change.

      • The table opens on the Edit data tab by default.

  3. Click new in the right pane to add a new record.

  4. In the form that displays, add record data. As you add data, columns will be selected by default (the box in the Change column will be selected).

  5. Click Insert to submit the selected information and add the new data.

    6. The new data displays on the Edit data tab and your changes will be saved (if the new data is 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 will be displayed in increments of the number in the #Shown box.

See also:

Changing Table Design


ContentsPreviousNextIndex



Copyright © 2003 Sun Microsystems, Inc. All rights reserved.