How to Link Tables Using SQL Named Parameters

Short Description
And see the How-to ‘OpenOffice.org 1.0, unixODBC, and mySQL’ mentioned …. http://dba.openoffice.org/howto/param_subst.html It is included below, …

Website: documentation.openoffice.org | Filesize: 958kb

Content
How to Link Tables Using
SQL Named Parameters
Distributed by
The OpenOffice.org Documentation ProjectOpenOffice.org Documentation Project How-To
Table of Contents
Introduction………………………………………………………………………………………………………………………………. 3
Creating the Database, Tables, and Data Source………………………………………………………………………………5
Adding Data to Tables ……………………………………………………………………………………………………………….10
Enabling Use of Named Parameters for the Data Source…………………………………………………………………12
The Macro………………………………………………………………………………………………………………………………. 13
Creating a Form for the Data Source…………………………………………………………………………………………….16
Adding a Subform……………………………………………………………………………………………………………………. 19
Linking the Subform to the Main Form……………………………………………………………………………………….. 24
Formatting Data Fields………………………………………………………………………………………………………………29
More Examples…………………………………………………………………………………………………………………………33
Summary………………………………………………………………………………………………………………………………….38
Credits……………………………………………………………………………………………………………………………………. 39
License…………………………………………………………………………………………………………………………………….40
http://documentation.openoffice.org 2…