Created attachment 2546 [details]
How to Link Tables Using SQL Named Parameters - OOo writer document

This is a good start, and much better than what we have at the moment.

 I have one 
niggle: the term "Beamer" sould be explained when it first appears. 

one more 
serious point: I think there ought to be an overview of what you're trying to do, 
perhaps after it has been done. The logic of linking forms and sub-forms and master and 
slave fields really isn't obvious from the documentation. You walk people through 
thes steps of it very well. But there ought to be an aerial view at the end, which shows 
the general principles involved. Something like:

"An SQL query where you're 
trying to get out information in table A according to a criterion in table B maps on to 
an Open Office form like this: The main form links to table B. Within it, you place a 
subform that's linked to table A. The "link master from" porperty ifnt eh subofrom is 
linked to table A. The Query you want to execute is written as SQL code in the main form. 
That's all the principle of it, which may make sense now you have done the practice." 


"If you get error xxx you need to run the macro above to tell the data source about 
known queries"


I am absoutely certain that the overview example I gave is 
wrong. But that's becaseu I am part of your target market. There ought to be a correct 
version at the end of the document, though

*** Issue 7134 has been marked as a duplicate of this issue. ***

Created attachment 2602 [details]
How to Link Tables Using SQL Named Parameters - revised - .sxw  (size = 834K)

Uploaded revised version of How-to
attachment id = 2602

Added an example linking three database tables.

Comments invited.

Created attachment 2702 [details]
How to Link Tables Using SQL Named Parameters - final - .sxw (size = 858K)

Uploaded final version of How-to
attachment id = 2702

Added an example linking two dBase tables.

Downloaded it again - seems OK.

Assigning to kcarr for processing, 
possible conversion to HTML,
and posting.

I'll look into this, and get back with you.

Created attachment 3176 [details]
How to Link Tables Using SQL Named Parameters - final - .sxw (size = 858K) (PDL license)

Changed the license to the Public Documentation License.

Uploaded the new version.

I have added this file as an SXW.  We will need to revisit this to add
HTML.

I have updated the site to make sure it is using the latest SXW, and I also
created a PDF as well.  Thanks for the great doc.

Two links in the introduction section of this document do not function well.

1. The link to MySQL has odd characters at the end of it, which sends the reader
to a search page. It should be adjusted to http://www.mysql.com/ to direct the
reader to the MySQL home page.

2. The link for the OOo to JDBC connection produces an error 404. The best link
replacement found so far is
http://dba.openoffice.org/FAQ/specific.html#connectmysql.

You can view the changes that have been incorporated into the existing HTML file
here:

http://documentation.openoffice.org/HOW_TO/data_source/link_tablehtml/link.html

The SXW default font in this document shows as Thorndale, which is a StarOffice
font that likely does not exist on machines that do not include the StarOffice
application. This means that font replacement will play into views of this file,
and possibly edits. I wonder if it would be best to use the Bitstream font which
comes with newer versions of OOo, to help provide a font that most systems
running OOo will contain. When a default font is not selected for the Writer
applications, font oddities can occur when this file is used on systems that do
not include Thorndale.

Removed the block on issue 38552, because it seems more practical to look at the
HTML file and the sxw file(s) as individual files.

checked and verified okay

closing