Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,306 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+<HTML>
+<HEAD>
+ <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
+ <TITLE></TITLE>
+ <META NAME="GENERATOR" CONTENT="StarOffice 6.0 (Win32)">
+ <META NAME="AUTHOR" CONTENT="Ocke Janssen">
+ <META NAME="CREATED" CONTENT="20020710;8345700">
+ <META NAME="CHANGEDBY" CONTENT="Ocke Janssen">
+ <META NAME="CHANGED" CONTENT="20020729;8060399">
+ <STYLE>
+ <!--
+ @page { margin: 2cm }
+ TD P { margin-bottom: 0.21cm }
+ H1 { margin-bottom: 0.21cm }
+ H1.western { font-family: "Albany", sans-serif; font-size: 16pt }
+ H1.cjk { font-size: 16pt }
+ H1.ctl { font-size: 16pt }
+ P { margin-bottom: 0.21cm }
+ H2 { margin-bottom: 0.21cm }
+ H2.western { font-family: "Albany", sans-serif; font-size: 14pt; font-style: italic }
+ H2.cjk { font-size: 14pt; font-style: italic }
+ H2.ctl { font-size: 14pt; font-style: italic }
+ H3 { margin-bottom: 0.21cm }
+ H3.western { font-family: "Albany", sans-serif }
+ H4 { margin-bottom: 0.21cm }
+ H4.western { font-family: "Albany", sans-serif; font-size: 11pt; font-style: italic }
+ H4.cjk { font-size: 11pt; font-style: italic }
+ H4.ctl { font-size: 11pt; font-style: italic }
+ TH P { margin-bottom: 0.21cm; font-style: italic }
+ -->
+ </STYLE>
+</HEAD>
+<BODY LANG="en-US">
+<H1 CLASS="western" ALIGN=CENTER>The creation and retrieving of auto
+increment values</H1>
+<P><BR><BR>
+</P>
+<P>Version History</P>
+<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
+ <COL WIDTH=128*>
+ <COL WIDTH=128*>
+ <THEAD>
+ <TR VALIGN=TOP>
+ <TH WIDTH=50%>
+ <P>What/When</P>
+ </TH>
+ <TH WIDTH=50%>
+ <P>Who</P>
+ </TH>
+ </TR>
+ </THEAD>
+ <TBODY>
+ <TR VALIGN=TOP>
+ <TD WIDTH=50%>
+ <P>Draft---July 18, 2002</P>
+ </TD>
+ <TD WIDTH=50%>
+ <P>Ocke Janssen</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=50%>
+ <P>GUI string review---July 25, 2002</P>
+ </TD>
+ <TD WIDTH=50%>
+ <P>Elizabeth Matthis</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=50%>
+ <P>GUI change---July 26, 2002</P>
+ </TD>
+ <TD WIDTH=50%>
+ <P>Ocke Janssen</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=50%>
+ <P>Final--- July 26, 2002fill in date
+ </P>
+ </TD>
+ <TD WIDTH=50%>
+ <P>Ocke Janssen</P>
+ </TD>
+ </TR>
+ </TBODY>
+</TABLE>
+<H1 CLASS="western"><BR><BR>
+</H1>
+<H2 CLASS="western">Problem description</H2>
+<P>At the moment it is not possible to create auto increment columns
+and to retrieve the value of an auto increment column when a new row
+was inserted.
+</P>
+<H4 CLASS="western">Creation of auto increment columns</H4>
+<P>Due to the fact that there exists no standard way on defining auto
+increment columns when creating a new table, a general approach is
+not possible. For example: MySQL identifies an auto increment
+definition of a column with the key word “auto_increment”,
+the MS SQL Server on the other side uses the keyword “increment(1,1)”
+to identify the auto increment column.
+</P>
+<H4 CLASS="western">Retrieving of auto increment column's values</H4>
+<P>The retrieving of an auto increment column's value, when inserting
+a new row, is already defined in the JDBC API 3.0. There the
+statement supports an additional method which returns a result set to
+access the new inserted auto increment column's value. This result
+set also supports meta data. To check if the statement supports this
+mechanism, the database meta data is extended by new support method
+which simply returns true or false.</P>
+<H2 CLASS="western">Solution</H2>
+<P>To allow a general approach of defining/retrieving auto increment
+columns/values, the user must have the possibility to define a
+statement which should be appended at the column definition when
+creating a table or should be called when fetching the new value of
+the auto increment column.</P>
+<H4 CLASS="western">Creation of auto increment columns</H4>
+<P>When creating tables for any kind of database, the current
+handling at the moment is that we use a general SDBCX layer for all
+database drivers which do not support the layer by their self. In
+other words the user has to take no action when the database driver
+supports already the SDBCX layer. For the case that the driver
+doesn't support the SDBCX layer and the user creates a new table, the
+generated SQL statement may look like this:</P>
+<P>CREATE TABLE “table1” (“id” INTEGER)</P>
+<P>The “CREATE TABLE” statement doesn't support any auto
+increment features, so that it isn't possible to create such columns.
+For MySQL this statement for an auto increment column looks like
+this:</P>
+<P>CREATE TABLE “table1” (“id” INTEGER
+AUTO_INCREMENT)</P>
+<P>Like this examples shows the user must have the opportunity to add
+the missing part of the statement to the “CREATE TABLE”
+statement. This can be done in two different ways which mustn't
+exclude each other.</P>
+<OL>
+ <LI><P>The data source stores in their info property an additional
+ string which should be appended to the column part when creating an
+ auto increment column. To allow the user to insert this string the
+ data source administration dialog could be extended by a simple text
+ field and may be an additional checkbox which enables this text
+ field.</P>
+ <LI><P>The table design offers an additional field on the column
+ properties area when an auto increment type was selected. This field
+ can be used by the user to define a string which should be appended
+ to the “CREATE TABLE” statement.
+ </P>
+ <LI><P>The points 1. and 2. are both used and under point 2, the
+ string which the user inserted under point 1 will be displayed in
+ the extra field.</P>
+</OL>
+<P>The 3<SUP>rd</SUP> approach would be the one which allows the user
+the most flexibility to get a predefined string which he could change
+if necessary. The best place to store the value for the data source
+would be the data source administration dialog. To be more precise
+this would be implemented for the JDBC and the ODBC drivers (they
+don't support the SDBCX layer). All other drivers support the SDBCX
+layer.</P>
+<H4 CLASS="western">Retrieving of auto increment column's values</H4>
+<P>As mentioned in the problem description JDBC 3.0 already defines
+methods to accomplish the task but it is not possible just to forward
+this to the used drivers. Many drivers as also APIs like ODBC don't
+support this feature. To fit near all databases, a method has to be
+implemented that allows to fetch the new inserted auto increment
+value. Many databases support a special SQL statement which allows to
+fetch this value. Mostly these statements are database specific and
+not SQL conform. So a similar approach as for the creation of auto
+increment columns should be chosen. The data source should also store
+a SQL string which allows to fetch the auto increment values. This
+string will then be executed by the statement when asked for the auto
+increment values after inserting a new row. To be compatible as
+possible to any kind of database the SQL string, stored in the data
+source, must fulfill some additional specifications to be valid for
+different tables. In other words, the SQL string must contain some
+keywords like $column1 or $table1 which will be replaced with the
+auto increment column name or with the used table. A general string
+could already be inserted into the data source dialog which is not
+the best solution but works for a lot of drivers:</P>
+<P>“select count($column1)+1 from $table1”</P>
+<P>If the supporting of this feature should be disabled the string
+could be cleared by the user or an additional checkbox must be
+inserted into to the dialog to enable or disable this feature. When
+this feature is enabled the database meta data object implemented by
+the driver will return false when asking the general support method
+for the feature “AutoRetrievingEnabled” otherwise true.
+When true was returned the statement object implemented by the driver
+allows the creation of a result set to fetch the auto increment
+values.</P>
+<H2 CLASS="western" STYLE="page-break-before: always">Data source
+administration dialog</H2>
+<P><IMG SRC="AutoIncrementValues_html_m243b4459.gif" NAME="Graphic1" ALIGN=LEFT WIDTH=643 HEIGHT=391 BORDER=0><BR CLEAR=LEFT><BR><BR>
+</P>
+<P><BR><BR>
+</P>
+<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
+ <COL WIDTH=85*>
+ <COL WIDTH=85*>
+ <COL WIDTH=85*>
+ <THEAD>
+ <TR VALIGN=TOP>
+ <TH WIDTH=33%>
+ <P>English</P>
+ </TH>
+ <TH WIDTH=33%>
+ <P>German</P>
+ </TH>
+ <TH WIDTH=33%>
+ <P>Comment</P>
+ </TH>
+ </TR>
+ </THEAD>
+ <TBODY>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>~Retrieve generated values</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Generierte Werte ~berücksichtigen</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Checkbox to enable this feature</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>~Auto-increment statement</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>~Auto-Increment-Ausdruck</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>FixedText which contains the statement which should be
+ appended after each column definition</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>~Query of generated values</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Abfrage der generierten ~Werte</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>FixedText which contains the statement which will be called
+ after an “INSERT” statement</P>
+ </TD>
+ </TR>
+ </TBODY>
+</TABLE>
+<P><BR><BR>
+</P>
+<H3 CLASS="western">Table design</H3>
+<P><IMG SRC="AutoIncrementValues_html_2f28066b.gif" NAME="Graphic2" ALIGN=LEFT WIDTH=642 HEIGHT=372 BORDER=0><BR CLEAR=LEFT><BR><BR>
+</P>
+<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
+ <COL WIDTH=85*>
+ <COL WIDTH=85*>
+ <COL WIDTH=85*>
+ <THEAD>
+ <TR VALIGN=TOP>
+ <TH WIDTH=33%>
+ <P>English</P>
+ </TH>
+ <TH WIDTH=33%>
+ <P>German</P>
+ </TH>
+ <TH WIDTH=33%>
+ <P>Comment</P>
+ </TH>
+ </TR>
+ </THEAD>
+ <TBODY>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>Auto-increment statement</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>~Auto-Increment-Ausdruck</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>FixedText which contains the same value as the 2<SUP>nd</SUP>
+ FixedText in data source administration dialog</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>Enter an SQL statement for the auto-increment field.\n\nThis
+ statement will be directly transferred to the database when the
+ table is created.</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Geben Sie hier einen SQL Ausdruck für das
+ Auto-Increment-Feld an.\n\nDieser Ausdruck wird beim Erzeugen der
+ Tabelle direkt an die Datenbank übertragen.</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>HelpText for this field which appears in the left side control</P>
+ </TD>
+ </TR>
+ </TBODY>
+</TABLE>
+<P><BR><BR>
+</P>
+</BODY>
+</HTML>
\ No newline at end of file
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_2f28066b.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_2f28066b.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_2f28066b.gif
------------------------------------------------------------------------------
svn:mime-type = image/gif
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_m243b4459.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_m243b4459.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/AutoIncrementValues_html_m243b4459.gif
------------------------------------------------------------------------------
svn:mime-type = image/gif
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Conditional Formatting.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Conditional%20Formatting.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Conditional Formatting.odt
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Data_Source_Property_Dialog.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Data_Source_Property_Dialog.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Data_Source_Property_Dialog.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_Registration.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_Registration.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_Registration.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_application.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_application.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Database_application.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_AssignAlias.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_AssignAlias.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_AssignAlias.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_FieldSelection.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_FieldSelection.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_FieldSelection.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Filtercriteria.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Filtercriteria.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Filtercriteria.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Sorting.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Sorting.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/DialogComponent_Sorting.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,137 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+<HTML>
+<HEAD>
+ <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
+ <TITLE></TITLE>
+ <META NAME="GENERATOR" CONTENT="StarOffice 6.0 (Win32)">
+ <META NAME="AUTHOR" CONTENT="Ocke Janssen">
+ <META NAME="CREATED" CONTENT="20020408;15591366">
+ <META NAME="CHANGEDBY" CONTENT="Ocke Janssen">
+ <META NAME="CHANGED" CONTENT="20020408;16013755">
+ <STYLE>
+ <!--
+ TH P { margin-bottom: 0.21cm; font-style: italic }
+ -->
+ </STYLE>
+</HEAD>
+<BODY LANG="de-DE">
+<H1>Drag and Drop in the Datasource Browser
+</H1>
+<P>This document shows what should be possible to drag and what
+should be happen when droped inside the datasource browser.
+</P>
+<TABLE WIDTH=100% BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
+ <COL WIDTH=85*>
+ <COL WIDTH=85*>
+ <COL WIDTH=85*>
+ <THEAD>
+ <TR VALIGN=TOP>
+ <TH WIDTH=33%>
+ <P>Source</P>
+ </TH>
+ <TH WIDTH=33%>
+ <P>Destination</P>
+ </TH>
+ <TH WIDTH=33%>
+ <P>Effect</P>
+ </TH>
+ </TR>
+ </THEAD>
+ <TBODY>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>Table object</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Table container</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Opens Wizard, whole table and data will be copied. See 1</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>Query object</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Table container</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Opens Wizard, whole query (as table or as view) and data will
+ be copied. See 2</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>Qurey object</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Query container</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Copies the query object</P>
+ </TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P>Grid-control</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Table container</P>
+ </TD>
+ <TD WIDTH=33%>
+ <P>Opens Wizard, only selection will be copied. See 3</P>
+ </TD>
+ </TR>
+ </TBODY>
+</TABLE>
+<P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid">
+<FONT FACE="Albany, sans-serif"><FONT SIZE=4>1 The table object as
+drag source</FONT></FONT></P>
+<P>Inside the datasorce browser, the table object can only be copied
+onto the table container. When copied all properties must also be
+copied. That means that the following properties have to look for if
+they are copied too.</P>
+<UL>
+ <LI><P>Columns</P>
+ <LI><P>Keys</P>
+ <LI><P>Indexes</P>
+ <LI><P>table settings, like color, filter and filter applied,
+ sorting
+ </P>
+ <LI><P>column settings, like number format</P>
+ <LI><P>and the data</P>
+</UL>
+<P>Outside the datasource browser, the table should be exported in
+HTML and RTF format. Additionally the writer should support extra
+functionality.</P>
+<P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid">
+<FONT FACE="Albany, sans-serif"><FONT SIZE=4>2 The query object as
+drag source</FONT></FONT></P>
+<P>The query object can be copied onto the query container. It should
+be a 1:1 copy. All properties have to be copied, the same as for the
+table object. When copied onto the table container, the user could
+choise between a table object to be created or an view object when
+the database supports it.</P>
+<UL>
+ <LI><P>the SQL statement</P>
+ <LI><P>the column settings as by a table</P>
+ <LI><P>the query settings, like color</P>
+</UL>
+<P STYLE="margin-top: 0.42cm; margin-bottom: 0.21cm; page-break-after: avoid">
+<FONT FACE="Albany, sans-serif"><FONT SIZE=4>4 The grid-control as
+drag source</FONT></FONT></P>
+<P>The grid control shows the current selection of the tree view.
+This view can be sorted and filtered. At this reason it is possible
+that the source contains a filter which has to be include when coping
+data. Additionally it is possible to do a multiselection on the rows.
+When this selection is copied on the table container, only the
+selected rows have to be copied and not the whole rows. Another point
+to mention is that the rows must also be dragable to other
+applications like the writer, this is also valid for the column
+header.
+</P>
+<P><BR><BR>
+</P>
+</BODY>
+</HTML>
\ No newline at end of file
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Drag_Drop_DSBrowser.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Embedded_Database.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Embedded_Database.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Embedded_Database.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,371 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+
+ <meta http-equiv="CONTENT-TYPE"
+ content="text/html; charset=windows-1252">
+ <title>Form Navigator Data Exchange Functional Spec</title>
+
+ <meta name="GENERATOR" content="StarOffice 6.0 (Win32)">
+
+ <meta name="CREATED" content="20020513;14164900">
+
+ <meta name="CHANGEDBY" content="Frank Schönheit">
+
+ <meta name="CHANGED" content="20020521;16011356">
+</head>
+<body lang="de-DE">
+<div id="Table of Contents1">
+<div style="text-align: center;"> </div>
+<div id="Table of Contents1_Head">
+<div style="text-align: center;"> <font size="+3"><span
+ style="font-weight: bold;">Data Exchange in the Form Navigator</span></font><br>
+<font size="+1"><span style="font-style: italic; font-weight: bold;">Functional
+specification</span></font><br>
+</div>
+<br>
+This document describes the data exchange functionality in the form
+navigator. This is the small floater which can be switched on when
+designing a form document, and visualizes the logical structure of the
+form components (forms, sub forms, control models). <br>
+<br>
+Data exchange means Drag and Drop functionality as well as Clipboard
+activities.
+<h2><a name="mozTocId51302" class="mozTocH2"></a>Table of Contents</h2>
+ </div>
+
+<ul id="mozToc">
+<!--mozToc h3 3 h4 4 h5 5--><li><a href="#mozTocId975628">1 Acceptance
+Rules</a></li>
+ <ul>
+ <li><a href="#mozTocId24028">1.1 Actions for different Component</a></li>
+ <li><a href="#mozTocId581363">1.2 Move</a></li>
+ <li><a href="#mozTocId244433">1.3 Copy</a></li>
+ </ul>
+ <li><a href="#mozTocId125168">2 Functionality</a>
+ <ul>
+ <li><a href="#mozTocId665767">2.1 Drag and Drop</a>
+ <ul>
+ <li><a href="#mozTocId134648">2.1.1 Activation</a><br></li>
+ <li><a href="#mozTocId658958">2.1.2 Mode selection</a></li>
+ </ul>
+ </li>
+ <li><a href="#mozTocId547415">2.2 Clipboard</a>
+ <ul>
+ <li><a href="#mozTocId4311">2.2.1 Activation</a></li>
+ <li><a href="#mozTocId14953">2.2.2 Cutting Entries</a></li>
+ </ul>
+ </li>
+ </ul>
+ </li>
+ <li><a href="#mozTocId620921">3 Clipboard formats</a>
+ <ul>
+ <li><a href="#mozTocId563632">3.1 Hidden controls</a></li>
+ <li><a href="#mozTocId166879">3.2 Control paths</a></li>
+ <li><a href="#mozTocId755191">3.3 Tree list entries</a></li>
+ </ul>
+ </li>
+ <li><a href="#mozTocId320803">4 Test cases</a>
+ <ul>
+ <li><a href="#mozTocId929325">4.1 Hidden controls</a></li>
+ <li><a href="#mozTocId985204">4.2 Non-Hidden Controls</a></li>
+ <li><a href="#mozTocId970357">4.3 More to come .....</a></li>
+ </ul>
+ </li>
+ </ul>
+</ul>
+<p style="margin-bottom: 0cm;"><br>
+</p>
+</div>
+<p class="western"><br>
+</p>
+<h3><a name="mozTocId975628" class="mozTocH3"></a>1 Acceptance Rules</h3>
+<p class="western">When doing a copy or move operation, given a set of
+source components (e.g. the drag source) and a target component (the
+drop target), the operation is rejected according to the rules below. If
+and only neither of the rules applies, the operation is accepted.<br>
+In general and by default, the source can be an arbitrary mixture of
+hidden controls, "normal" controls, and forms, while the destination can
+be any valid entry in the form navigator.</p>
+<h4><a name="mozTocId24028" class="mozTocH4"></a>1.1 Actions for
+different Component</h4>
+<p class="western">Allowed actions differ for the different types of
+components: (hidden/non-hidden controls, and forms). Additionally, there
+is a difference if the data exchange is in-place (within the same
+navigator instance) or if it crosses document boundaries.</p>
+<p class="western">The following table shows the acceptance matrix
+under these aspects.</p>
+<table width="642" border="1" bordercolor="#000000" cellpadding="4"
+ cellspacing="0">
+ <col width="126"> <col width="119"> <col width="119"> <col width="119">
+ <col width="118"> <thead> <tr valign="top">
+ <th width="126">
+ <p class="western" style="">control \ action</p>
+ </th>
+ <th width="119">
+ <p class="western" style="">copy, in-place</p>
+ </th>
+ <th width="119">
+ <p class="western" style="">move, in-place</p>
+ </th>
+ <th width="119">
+ <p class="western" style="">copy, crossing</p>
+ </th>
+ <th width="118">
+ <p class="western" style="">move, crossing</p>
+ </th>
+ </tr>
+ </thead> <tbody>
+ <tr valign="top">
+ <td width="126">
+ <p class="western">hidden control</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">+</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">+</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">+</p>
+ </td>
+ <td width="118">
+ <p class="western" align="center">-</p>
+ </td>
+ </tr>
+ <tr valign="top">
+ <td width="126">
+ <p class="western">non-hidden control</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">-</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">+</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">-</p>
+ </td>
+ <td width="118">
+ <p class="western" align="center">-</p>
+ </td>
+ </tr>
+ <tr valign="top">
+ <td width="126">
+ <p class="western">forms</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">-</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">+</p>
+ </td>
+ <td width="119">
+ <p class="western" align="center">-</p>
+ </td>
+ <td width="118">
+ <p class="western" align="center">-</p>
+ </td>
+ </tr>
+
+ </tbody>
+</table>
+<p class="western"><br>
+<br>
+</p>
+<p class="western">If the source of a data exchange operation contains
+a mixed set of different types, the weakest rules determine the result.
+Means if you mix for instance a hidden control with a form, then the
+acceptance rules for the form apply.</p>
+<p class="western">There are additional rules which may restrict the
+operation even further, they are explained in the next paragraphs.</p>
+<h4><a name="mozTocId581363" class="mozTocH4"></a>1.2 Move</h4>
+<p class="western">In addition to the rules from chapter 1.1, a move
+operation is rejected if one of the following points applies:</p>
+<ol>
+ <li>
+ <p class="western">The target does not exist, i.e. the components
+were dropped onto empty space.</p>
+ </li>
+ <li>
+ <p class="western">The root entry is part of the source components
+ you can't move the root</p>
+ </li>
+ <li>
+ <p class="western">One of the source components</p>
+
+ <ol type="a">
+ <li>
+ <p class="western">is a child of the target component</p>
+ </li>
+ <li>
+ <p class="western">equals the target component</p>
+ </li>
+ <li>
+ <p class="western">is a form, and at the same time an
+ancestor of the target</p>
+ </li>
+ <li>
+ <p class="western">is a control, and the target is the root
+component</p>
+ </li>
+ </ol>
+ </li>
+ <li>
+ <p class="western">The target component is a control</p>
+ </li>
+</ol>
+<h4><a name="mozTocId244433" class="mozTocH4"></a>1.3 Copy</h4>
+<p class="western">In addition to the rules from chapter 1.1, a copy
+operation is rejected if and only if one of the following points applies:</p>
+<ol>
+ <li>
+ <p class="western">The target does not exist, i.e. the components
+were dropped onto empty space.</p>
+ </li>
+ <li>
+ <p class="western">The target component is no form</p>
+ </li>
+</ol>
+<h3><a name="mozTocId125168" class="mozTocH3"></a>2 Functionality</h3>
+<h4><a name="mozTocId665767" class="mozTocH4"></a>2.1 Drag and Drop</h4>
+<h5><a name="mozTocId134648" class="mozTocH5"></a>2.1.1 Activation</h5>
+<p class="western">as usual: Select an arbitrary set of entries in the
+navigator, and start dragging them.</p>
+<h5><a name="mozTocId658958" class="mozTocH5"></a>2.1.2 Mode selection</h5>
+<p class="western">The default mode is "move", i.e. if you do a DnD
+operation without any modifier keys, a move will be triggered.<br>
+You can use the usual platform-dependent (e.g. on Windows: Ctrl)
+modifier key(s) to force copying</p>
+<h4><a name="mozTocId547415" class="mozTocH4"></a>2.2 Clipboard</h4>
+<h5><a name="mozTocId4311" class="mozTocH5"></a>2.2.1 Activation</h5>
+<p class="western">as usual: Select an arbitrary set of entries in the
+navigator, open the context menu (no matter if by mouse or keyboard),
+and choose "Copy" or "Cut" therein. Alternatively, press the usual,
+platform-dependent keyboard shortcuts (e.g. on Windows: Ctrl-C for copy,
+Ctrl-X for cut).</p>
+<p class="western" style="font-style: normal;">The Paste aka Insert
+functionality is reachable when via context menu and usual shortcut,
+too. It is not available if no entry is selected, if more than one entry
+is selected, or if the selected entry does not fullfill the acceptance
+rules from chapter 1.</p>
+<h5><a name="mozTocId14953" class="mozTocH5"></a>2.2.2 Cutting Entries</h5>
+<p class="western">If you started a cut, the entries in question will
+get a brighter icon, indicating that they are to be moved once the move
+operation is finished. This means they are not removed from the model
+when you do the cut, but only when you do the paste from the clipboard.</p>
+<h3><a name="mozTocId620921" class="mozTocH3"></a>3 Clipboard formats</h3>
+<p class="western">This chapter is for completeness. It describes the
+internal clipboard formats used.</p>
+<p class="western">The following formats are used for transfering data
+within one or more instances of the form navigator.</p>
+<h4><a name="mozTocId563632" class="mozTocH4"></a>3.1 Hidden controls</h4>
+<ul>
+ <li>
+ <p class="western">format name:
+ application/x-openoffice;windows_formatname="svxform.HiddenControlModelsExchange"</p>
+ </li>
+ <li>
+ <p class="western" style="font-style: normal;">content: a
+Sequence< XPropertySet >, denoting the models of the hidden
+ controls to transfer</p>
+ </li>
+</ul>
+<h4><a name="mozTocId166879" class="mozTocH4"></a>3.2 Control paths</h4>
+<ul>
+ <li>
+ <p class="western">format name:
+ application/x-openoffice;windows_formatname="svxform.ControlPathExchange"</p>
+ </li>
+ <li>
+ <p class="western" style="font-style: normal;"> content:
+Sequence< Any >, 2 elements</p>
+
+ <ul>
+ <li>
+ <p class="western" style="font-style: normal;"> first element:
+Reference< XNameContainer > which represents the collections of
+all forms</p>
+ </li>
+ <li>
+ <p class="western" style="font-style: normal;"> second
+element: Sequence< Sequence< int > >: Every element
+describes a "path to a control model, relative to the container in
+the container above.<br>
+ <br>
+E.g., if the sequence is "( ( 0, 2 ), (1, 3, 2) )", then two
+ elements with the paths "(0, 2)" and "(1, 3, 2)" are described.
+Means the first element is the third (2!) children of the first (0!)
+children of the container, and the second element is the third
+children of the forth children of the second children of the container.</p>
+ </li>
+ </ul>
+ </li>
+</ul>
+<h4><a name="mozTocId755191" class="mozTocH4"></a>3.3 Tree list entries</h4>
+<ul>
+ <li>
+ <p class="western">format name:
+ application/x-openoffice;windows_formatname="svxform.FieldNameExchange"</p>
+ </li>
+ <li> content: Virtually nothing :). This is not really transfered via
+the usual exchange mechanisms, it is just a shortcut for instances
+where the drag source is the same as the drop target; in this case the
+latter does not need to rebuild all the internal information from the
+ persistent format 2.<br>
+In particular, this means the format does not supply data, it acts as
+placeholder only. </li>
+</ul>
+<h3><a name="mozTocId320803" class="mozTocH3"></a>4 Test cases</h3>
+<h4><a name="mozTocId929325" class="mozTocH4"></a>4.1 Hidden controls</h4>
+<ul>
+ <li>
+ <p class="western">Create a form containing a hidden control.
+ Create a new sub form below the first form.</p>
+
+ <ul>
+ <li>
+ <p class="western">Try to DnD this control to itself, to it's
+ parent, to the sub form, to a free place in the navigator. Check
+ that moving is allowed (and works) on the sub form, and nowhere else.</p>
+ </li>
+ <li>
+ <p class="western">Try the same actions with the first modifier
+ key (Ctrl). This should be a copy operation, thus it should be
+ allowed (and work) on the forms, but nowhere else.</p>
+ </li>
+ </ul>
+ </li>
+ <li>
+ <p class="western">Create a second document, and a form therein</p>
+
+ <ul>
+ <li>
+ <p class="western">Try to DnD the hidden control from the first
+ document to the form in the second document. Only copying to a form
+ should work.</p>
+ </li>
+ </ul>
+ </li>
+</ul>
+<h4><a name="mozTocId985204" class="mozTocH4"></a>4.2 Non-Hidden
+Controls</h4>
+<ul>
+ <li>
+ <p class="western">Create a form with some controls (except than
+ hidden controls)</p>
+
+ <ul>
+ <li>
+ <p class="western">mark an arbitrary set of controls, and try
+ to DnD them in the navigator. Should be refused all times: Movement
+ is not allowed (as the only existent form is the parent of the
+ controls), and copy is not allowed in general for non-hidden
+ controls.</p>
+ </li>
+ </ul>
+ </li>
+</ul>
+<h4><a name="mozTocId970357" class="mozTocH4"></a>4.3 More to come .....</h4>
+</body>
+</html>
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Navigator_DnD.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Save_Dialog_Spec.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Save_Dialog_Spec.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Form_Save_Dialog_Spec.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Function_Property_Browser.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Function_Property_Browser.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Function_Property_Browser.odt
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Ldap_authentication.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Ldap_authentication.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Ldap_authentication.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Link_CSV_Text_files_into_HSQL_databases.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Link_CSV_Text_files_into_HSQL_databases.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Link_CSV_Text_files_into_HSQL_databases.odt
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html?rev=1204746&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html (added)
+++ incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html Mon Nov 21 23:15:57 2011
@@ -0,0 +1,245 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
+<HTML>
+<HEAD>
+ <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
+ <TITLE>MySQL driver page</TITLE>
+ <META NAME="GENERATOR" CONTENT="StarOffice 6.0 (Win32)">
+ <META NAME="AUTHOR" CONTENT="Ocke Janssen">
+ <META NAME="CREATED" CONTENT="20020306;7403200">
+ <META NAME="CHANGEDBY" CONTENT="Ocke Janssen">
+ <META NAME="CHANGED" CONTENT="20021122;10010893">
+</HEAD>
+<BODY LANG="en-US" LINK="#0000cc">
+<P ALIGN=CENTER><FONT FACE="Albany"><FONT SIZE=5><B>MySQL driver page</B></FONT></FONT></P>
+<P ALIGN=CENTER><FONT FACE="Albany"><FONT SIZE=3><I><SPAN LANG="en-US">applies</SPAN>
+to StarOffice 6.1 <BR>status: finished, last modified: <SDFIELD TYPE=DOCINFO SUBTYPE=CHANGE FORMAT=DATE SDNUM="1033;1033;D. MMM. YYYY">22. Nov. 2002</SDFIELD></I></FONT></FONT></P>
+<H1><FONT FACE="Albany"><FONT SIZE=4>Version History</FONT></FONT></H1>
+<TABLE WIDTH=586 BORDER=1 CELLPADDING=4 CELLSPACING=0 FRAME=HSIDES RULES=ROWS>
+ <COL WIDTH=99>
+ <COL WIDTH=32>
+ <COL WIDTH=129>
+ <COL WIDTH=294>
+ <THEAD>
+ <TR>
+ <TD WIDTH=99 VALIGN=BOTTOM SDVAL="37570" SDNUM="1033;0;MM/DD/YY">
+ <P ALIGN=RIGHT><FONT FACE="Albany"><FONT SIZE=2>11/10/02</FONT></FONT></TD>
+ <TD WIDTH=32 VALIGN=TOP>
+ <P ALIGN=LEFT><BR>
+ </TD>
+ <TD WIDTH=129 VALIGN=TOP>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Ocke Janssen</FONT></FONT></TD>
+ <TD WIDTH=294 VALIGN=TOP>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>first draft</FONT></FONT></TD>
+ </TR>
+ </THEAD>
+ <TBODY>
+ <TR>
+ <TD WIDTH=99 VALIGN=BOTTOM SDVAL="37581" SDNUM="1033;0;MM/DD/YY">
+ <P ALIGN=RIGHT><FONT FACE="Albany"><FONT SIZE=2>11/21/02</FONT></FONT></TD>
+ <TD WIDTH=32 VALIGN=TOP>
+ <P ALIGN=LEFT><BR>
+ </TD>
+ <TD WIDTH=129 VALIGN=TOP>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Elizabeth Matthis</FONT></FONT></TD>
+ <TD WIDTH=294 VALIGN=TOP>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>GUI string review</FONT></FONT></TD>
+ </TR>
+ </TBODY>
+</TABLE>
+<H1><FONT FACE="Albany"><FONT SIZE=4>Abstract</FONT></FONT></H1>
+<P ALIGN=JUSTIFY><FONT FACE="Thorndale">To create a new data source
+with the new MySQL driver, the data source administration dialog must
+be extended. A new page will be inserted where the user can fill in
+all necessary information which are needed to connect to a MySQL
+database.</FONT></P>
+<DIV ID="Table of Contents1">
+ <DIV ID="Table of Contents1_Head">
+ <H1><FONT FACE="Albany"><FONT SIZE=4>Contents</FONT></FONT></H1>
+ </DIV>
+ <DL>
+ <DT><FONT FACE="Albany"><FONT SIZE=2>1 MySQL driver page 1</FONT></FONT><DT>
+ <FONT FACE="Albany"><FONT SIZE=2>1.1 The driver page in detail 1</FONT></FONT><DT>
+ <FONT FACE="Albany"><FONT SIZE=2>1.2 String List 1</FONT></FONT></DL>
+</DIV>
+<H1><FONT FACE="Albany"><FONT SIZE=4>1 MySQL driver page</FONT></FONT></H1>
+<P ALIGN=JUSTIFY><FONT FACE="Thorndale">The new driver page fort
+MySQL allows the user to select between two different kinds of 'how
+to connect to the MySQL database'. The first possibility is to use an
+existing MyODBC<A CLASS="sdfootnoteanc" NAME="sdfootnote1anc" HREF="#sdfootnote1sym"><SUP>1</SUP></A>
+data source which must be defined in the used system. The second kind
+is to use the JDBC<A CLASS="sdfootnoteanc" NAME="sdfootnote2anc" HREF="#sdfootnote2sym"><SUP>2</SUP></A>
+version from MySQL named “connector/J”. </FONT>
+</P>
+<H2><FONT FACE="Albany"><FONT SIZE=4>1.1 The driver page in detail</FONT></FONT></H2>
+<P ALIGN=JUSTIFY><IMG SRC="./MySQL_data_source_page_html_17ee6536.gif" NAME="Rahmen1" ALT="Rahmen1" ALIGN=LEFT HSPACE=8 VSPACE=8><BR CLEAR=LEFT><FONT FACE="Thorndale">In
+the first group box the user can select which kind of connection he
+would like to use. Either an existing ODBC data source which must be
+defined in the used system or to connect to the database via the JDBC
+interface. To allow the user to specify different driver classes, an
+extra edit field is enabled when the JDBC was selected, where the
+name of the driver class can be inserted<A CLASS="sdfootnoteanc" NAME="sdfootnote3anc" HREF="#sdfootnote3sym"><SUP>3</SUP></A>.
+In the second group box information about the data source, the user
+name, if a password is required and which character set the MySQL
+server should use, can be defined. The URL field contains different
+meaning depending on the type of connection. In the case of ODBC, it
+contains the name of the ODBC data source; in the case of JDBC it
+contains the host name, a port number and the database name. To give
+the user a hint, the URL field will contain a default value for a
+JDBC kind of connection, where the user has to substitute only the
+fields in the brackets.</FONT></P>
+<H2><FONT FACE="Albany"><FONT SIZE=4>1.2 String List</FONT></FONT></H2>
+<TABLE WIDTH=100% BORDER=1 CELLPADDING=4 CELLSPACING=0>
+ <COL WIDTH=85*>
+ <COL WIDTH=85*>
+ <COL WIDTH=85*>
+ <THEAD>
+ <TR VALIGN=TOP>
+ <TH WIDTH=33%>
+ <P><FONT FACE="Albany"><FONT SIZE=2>String</FONT></FONT></TH>
+ <TH WIDTH=33%>
+ <P><FONT FACE="Albany"><FONT SIZE=2>German translation</FONT></FONT></TH>
+ <TH WIDTH=33%>
+ <P><FONT FACE="Albany"><FONT SIZE=2>comment</FONT></FONT></TH>
+ </TR>
+ </THEAD>
+ <TBODY>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Type of connection</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P><FONT FACE="Albany"><FONT SIZE=2>Art der Verbindung</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Fixed line;
+ Separates the kind of connection from the general information. No
+ mnemonic necessary.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Use existing
+ My~ODBC data source</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P><FONT FACE="Albany"><FONT SIZE=2>Existierende My~ODBC
+ Datenquelle verwenden</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Radio button
+ label; Will be marked by the user when he wants to use an
+ existing ODBC system data source. “MyODBC” is product
+ name and not to translate.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Use Connector/~J3</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Connector/~J3
+ verwenden</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Radio button
+ label; Connector/J3 is the JDBC driver from MySQL. Do not
+ translate or change “Connector/J3”-- it is a product
+ name.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>MySQL JDBC d~river
+ class</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>MySQL JDBC
+ ~Treiberklasse</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>The label for the
+ edit (text box), where the user can insert the JDBC driver class
+ for MySQL</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>General</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Allgemein</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Fixed line; A
+ separator. No mnemonic necessary.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Data source URL</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>D~atenquellen-URL</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label;
+ The url for the connection.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~User name</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Benutzername</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label;
+ The user name needed to connect to the database.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Password r~equired</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Kennwort
+ ~erforderlich</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Check box label;
+ Indicates that a password is needed to connect to the database.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Character set</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>~Zeichensatz</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Text box label;
+ The character set.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2><host>:<3306>/<DBNAME></FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2><Rechnername>:<3306>/<DBNAME></FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>String; will be
+ inserted into the URL field when choosing the Connector/J3 to
+ give the user a clue about what is needed.</FONT></FONT></TD>
+ </TR>
+ <TR VALIGN=TOP>
+ <TH WIDTH=33%>
+ <P><BR>
+ </TH>
+ <TH WIDTH=33%>
+ <P><FONT FACE="Albany"><FONT SIZE=2>General Page</FONT></FONT></TH>
+ <TH WIDTH=33%>
+ <P><BR>
+ </TH>
+ </TR>
+ <TR VALIGN=TOP>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>To adjust the
+ settings, go to the MySQL tab page.</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>Wechseln Sie zur
+ MySQL-Registerseite um die Einstellungen vorzunehmen.</FONT></FONT></TD>
+ <TD WIDTH=33%>
+ <P ALIGN=LEFT><FONT FACE="Albany"><FONT SIZE=2>This text will be
+ shown on the general page when the type MySQL is selected.</FONT></FONT></TD>
+ </TR>
+ </TBODY>
+</TABLE>
+<P ALIGN=JUSTIFY><BR><BR>
+</P>
+<DIV ID="sdfootnote1">
+ <P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote1sym" HREF="#sdfootnote1anc">1</A>Open
+ database connectivity</FONT></FONT></DIV>
+<DIV ID="sdfootnote2">
+ <P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote2sym" HREF="#sdfootnote2anc">2</A>Java
+ database connectivity</FONT></FONT></DIV>
+<DIV ID="sdfootnote3">
+ <P><FONT FACE="Thorndale"><FONT SIZE=2><A CLASS="sdfootnotesym" NAME="sdfootnote3sym" HREF="#sdfootnote3anc">3</A>The
+ driver class will be searched for in the jar files which can be
+ added under tools->options->Security.</FONT></FONT></DIV>
+</BODY>
+</HTML>
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page.html
------------------------------------------------------------------------------
svn:eol-style = native
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page_html_17ee6536.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page_html_17ee6536.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/MySQL_data_source_page_html_17ee6536.gif
------------------------------------------------------------------------------
svn:mime-type = image/gif
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/ProgressPanel.bmp
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/ProgressPanel.bmp?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/ProgressPanel.bmp
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Queries_in_Queries_.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Queries_in_Queries_.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Queries_in_Queries_.odt
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/ReportDesigner.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/ReportDesigner.odt?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/ReportDesigner.odt
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Thunderbird_ab.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Thunderbird_ab.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Thunderbird_ab.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Database.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Database.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Database.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Form.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Form.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Form.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Query.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Query.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Query.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Report.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Report.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Report.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Table.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Table.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Wizard_Table.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/Write_Access_To_AddressBooks.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/Write_Access_To_AddressBooks.sxw?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/Write_Access_To_AddressBooks.sxw
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
Added: incubator/ooo/ooo-site/trunk/content/dba/specifications/ab_architecture.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/dba/specifications/ab_architecture.gif?rev=1204746&view=auto
==============================================================================
Binary file - no diff available.
Propchange: incubator/ooo/ooo-site/trunk/content/dba/specifications/ab_architecture.gif
------------------------------------------------------------------------------
svn:mime-type = image/gif
|