Datu avoti
This 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 browser
The commands for the data source browser are found on the Table Data bar and in context menus.
Selecting records
To 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:
|
Izvēlētais |
Darbība |
|
Ierakstīt |
Click the row header |
|
Several records or removing a selection |
Hold down CommandCtrl and click the row header |
|
Kolonna |
Click the column header |
|
Datu lauks |
Click in the data field |
|
Visa tabula |
Click the row header of the column headings |
Table Data toolbar (editing table data)
Allows you to edit, add, or delete records from the database table.
Datu izgriešana, kopēšana un ielīmēšana
You can cut, copy, and paste records in Data Source view. The Data Source browser also supports the dragging and dropping of records, or text and numbers from other LibreOffice 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 Browser
Use the Form Navigation bar at the bottom of the Data Source view to navigate between different records.
Pirmais ieraksts
Iepriekšējais ieraksts
Ieraksta numurs
Type the number of the record that you want to display, and then press Enter.
Nākamais ieraksts
Pēdējais ieraksts
Jauns ieraksts
Ierakstu skaits
Displays the number of records. 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.
Tabulu organizēšana
To access the commands for formatting the table, right-click a column header, or a row header.