Data Sources/text/shared/01/05340400.xhpSun Microsystems, Inc.converted from old format - fpedatabase tables; data source browserdata source browsertables in databases; data source browserdatabases; editing tablesediting; database tablesediting; queriesqueries; editing in data source viewData SourcesThis section contains information on browsing and editing database tables.You cannot use the data source browser on a database table that is open in Design view.Data source browserThe commands for the data source browser are found on the Table Data bar and in context menus.Selecting recordsTo select a record in a database table, click the row header, or click a row header, and then use the Up or Down arrow keys.The following table describes how to select individual elements in the data source browser:
SelectionActionRecordClick the row headerSeveral records or removing a selectionHold down Ctrl and click the row headerColumnClick the column headerData fieldClick in the data fieldEntire tableClick the row header of the column headings
Table Data Bar (editing database tables)
IconAllows you to edit, add, or delete records from the database table.To change the layout of a database table, right-click the table in Data Source view, and then choose Edit - Table.When you edit a query for the current database table in Data Source view, the changes are immediately displayed. To edit a query that requires access to more than one table, right-click the query in Data Source view, and then choose Edit - Query.
You cannot edit a database table that requires an index key or a primary key for identification of the data records, if the table definition does not contain an index key or a primary key.Cutting, copying and pasting dataYou can cut, copy, and paste table fields in Data Source view. The Data Source browser also supports the dragging and dropping of table fields, or simple text and numbers from other $[officename] files.You cannot drag and drop to Yes/No, binary, image, or counting table fields.Drag and drop only works in Edit mode.Navigating in the Data Source BrowserUse the Form Navigation bar at the bottom of the Data Source view to navigate between different records.First record
IconGo to the first record in the table.
Previous record
IconGo to the previous record in the table.
Record numberType the number of the record that you want to display, and then press Enter.Next record
IconGo to the next record in the table.
Last record
IconGo to the last record in the table.
New record
IconInserts a new record into the current table.To create a record, click the asterisk (*) button at the bottom of the table view. An empty row is added at the end of the table.
Number of recordsThe Form Navigation bar also displays information about the number of records in the current table. For example, "Record 7 of 9(2)" indicates that two records (2) are selected in a table containing 9 records, and that the cursor is in record number 7.Organizing tablesTo access the commands for formatting the table, right-click a column header, or a row header.Table FormatRow HeightColumn FormatColumn Width