Intro to the Data Source View

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 00:29, 1 November 2007 (edit)
Lorinda (Talk | contribs)
(continue writing article--not finished yet!)
← Previous diff
Revision as of 01:01, 1 November 2007 (edit) (undo)
Lorinda (Talk | contribs)
(lay out sections I plan to write)
Next diff →
Line 13: Line 13:
#Click {{Button|OK}} in the {{Window|Create Database Link}} window. #Click {{Button|OK}} in the {{Window|Create Database Link}} window.
#Click {{Button|OK}} in the {{Window|Options-NeoOffice Base-Databases}} window. #Click {{Button|OK}} in the {{Window|Options-NeoOffice Base-Databases}} window.
- +<br>
==Accessing the Datasource== ==Accessing the Datasource==
#In an open Writer, document, click on the {{Button|Data Sources}} button on the Standard Toolbar, or go to the {{Menu|View}} menu and select {{Menu|DataSources}}. The Data Source View opens just below the toolbars, above your document. #In an open Writer, document, click on the {{Button|Data Sources}} button on the Standard Toolbar, or go to the {{Menu|View}} menu and select {{Menu|DataSources}}. The Data Source View opens just below the toolbars, above your document.
Line 23: Line 23:
#*:If this toolbar does not, appear, you will need to move or rename your preferences folder, as there does not seem to be any other way to turn it on from within the program. See the articles on [[Troubleshooting_Tips#Check_for_corrupted_user_preference_files|corrupted preferences]] and [[Salvaging_Settings_From_Corrupt_Preferences|Salvaging Settings from Preferences]] for directions. When I encountered this problem, I narrowed the troublesome spot down to the registry folder. Instead of moving the entire preferences folder, you might try moving/renaming just the registry folder. Note that you will lose data source registrations if you need to do this. See [[#Registering the Data Source|Registering the Data Source]]. #*:If this toolbar does not, appear, you will need to move or rename your preferences folder, as there does not seem to be any other way to turn it on from within the program. See the articles on [[Troubleshooting_Tips#Check_for_corrupted_user_preference_files|corrupted preferences]] and [[Salvaging_Settings_From_Corrupt_Preferences|Salvaging Settings from Preferences]] for directions. When I encountered this problem, I narrowed the troublesome spot down to the registry folder. Instead of moving the entire preferences folder, you might try moving/renaming just the registry folder. Note that you will lose data source registrations if you need to do this. See [[#Registering the Data Source|Registering the Data Source]].
#*:Due to the fact that this toolbar cannot be turned back on without moving preferences, '''DO NOT''' close the Table Data toolbar. #*:Due to the fact that this toolbar cannot be turned back on without moving preferences, '''DO NOT''' close the Table Data toolbar.
 +<br>
 +==Editing Data in Data Source View==
 +<br>
 +
 +==Filtering Data in Data Source View==
 +<br>
 +==Sorting Data in Data Source View==
 +<br>
 +==Inserting Fields from the Data Source==
 +<br>
 +===Adding Fields in the flow of your document===
 +<br>
 +===Quickly Creating a Writer Table===
 +<br>
 +===Using the Next Record Field===
 +<br>
 +===Issues with Image Fields===

Revision as of 01:01, 1 November 2007

This article is part of the To Base and Back Again tutorial series.

Reports and Forms are actually Writer documents stored within the odb file of your database. But you can also access the data in registered databases from Writer documents that are not stored within the odb file. This tutorial discusses some of the ways to access and use this data.

Contents

Registering The Database

In order to access data in from Writer, the database must be registered. When you create a new database, the Database Wizard asks if you want to register the new database. Under normal conditions, you want to check Yes. If you accidently checked No, or if you have received an odb file from someone else, here's how to register the database:

  1. In the NeoOffice menu, choose Preferences
  2. Double-click on NeoOffice Base to disclose the sub-categories
  3. Click on Databases. You will see a list of registered databases.
  4. Click the New... button. The Create Database Link window appears
  5. Click the Browse... button and navigate to the database file you want to register.
  6. If desired, you may give it a Registered name different than the file path.
  7. Click OK in the Create Database Link window.
  8. Click OK in the Options-NeoOffice Base-Databases window.


Accessing the Datasource

  1. In an open Writer, document, click on the Data Sources button on the Standard Toolbar, or go to the View menu and select DataSources. The Data Source View opens just below the toolbars, above your document.
  2. In the Data Explorer (the left column with a list of data sources), click on the disclosure triangle next to the name of the database file you want to work with.
  3. Now click on the disclosure triangle next to Queries or Tables under the seleted database name.
  4. Select the specific Query or Table you want to work with for this document. (e.g. the All Sightings query). wait while the data loads. Note that the more complex the query, the longer you will need to wait. (The wait time may also be affected by available memory, CPU load, and processor speed).
  5. Make sure that the Table Data Toolbar is visible at the top of the Data Source View. It is the toobar that is circled in the image below:
    Image:DataSources.png
    • If this toolbar does not, appear, you will need to move or rename your preferences folder, as there does not seem to be any other way to turn it on from within the program. See the articles on corrupted preferences and Salvaging Settings from Preferences for directions. When I encountered this problem, I narrowed the troublesome spot down to the registry folder. Instead of moving the entire preferences folder, you might try moving/renaming just the registry folder. Note that you will lose data source registrations if you need to do this. See Registering the Data Source.
      Due to the fact that this toolbar cannot be turned back on without moving preferences, DO NOT close the Table Data toolbar.


Editing Data in Data Source View


Filtering Data in Data Source View


Sorting Data in Data Source View


Inserting Fields from the Data Source


Adding Fields in the flow of your document


Quickly Creating a Writer Table


Using the Next Record Field


Issues with Image Fields

Personal tools