diff options
| author | Oliver Bolte <obo@openoffice.org> | 2006-03-28 12:29:35 +0000 |
|---|---|---|
| committer | Oliver Bolte <obo@openoffice.org> | 2006-03-28 12:29:35 +0000 |
| commit | 8a30248adfe986c1a9f0d5220a35a0d52c2a5d16 (patch) | |
| tree | 91ca25cd8bc83a6a92b2fbeeedfbf05d536c8906 /helpcontent2/source/text/shared/explorer/database | |
| parent | 94a99848ee5c5b8fc8f126b787f7e8e1afbd792e (diff) | |
#i10000# Undo CWS integration hc680fin
Diffstat (limited to 'helpcontent2/source/text/shared/explorer/database')
21 files changed, 569 insertions, 949 deletions
diff --git a/helpcontent2/source/text/shared/explorer/database/02010100.xhp b/helpcontent2/source/text/shared/explorer/database/02010100.xhp index f9955d0c0f..74f944e5da 100755 --- a/helpcontent2/source/text/shared/explorer/database/02010100.xhp +++ b/helpcontent2/source/text/shared/explorer/database/02010100.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 02010100.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.8 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:17 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,7 +42,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-10-17T09:47:00">FPE: Switched Adabas content to be displayed for SO only (#i10510#)</lastedited> +<lastedited date="2005-09-13T15:11:08">FPE: Switched Adabas content to be displayed for SO only (#i10510#)</lastedited> </history> </meta> <body> @@ -70,7 +50,7 @@ <bookmark_value>queries; creating in design view</bookmark_value> <bookmark_value>designing; queries</bookmark_value> <bookmark_value>design view; queries/views</bookmark_value> -<bookmark_value>joining;tables in databases</bookmark_value> +<bookmark_value>joining;tables</bookmark_value> <bookmark_value>tables in databases; joining for queries</bookmark_value> <bookmark_value>queries; joining tables</bookmark_value> <bookmark_value>tables in databases; relations</bookmark_value> @@ -83,7 +63,6 @@ <bookmark_value>queries; parameter queries</bookmark_value> <bookmark_value>SQL; queries</bookmark_value> <bookmark_value>native SQL</bookmark_value> -<bookmark_value>operators;in Base (SQL)</bookmark_value> </bookmark> <paragraph role="paragraph" id="par_id3153323" xml-lang="en-US" l10n="E" oldref="2" localize="false"/> <paragraph role="heading" id="hd_id3153394" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/02010100.xhp" name="Query Design">Query Design</link></paragraph> diff --git a/helpcontent2/source/text/shared/explorer/database/02010101.xhp b/helpcontent2/source/text/shared/explorer/database/02010101.xhp index f69b77d5dc..b76d06b964 100755 --- a/helpcontent2/source/text/shared/explorer/database/02010101.xhp +++ b/helpcontent2/source/text/shared/explorer/database/02010101.xhp @@ -2,34 +2,36 @@ <!-- *********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 + * $RCSfile: 02010101.xhp,v $ * + * $Revision: 1.7 $ * - * Sun Microsystems Inc., October, 2000 + * last change: $Author: obo $ $Date: 2006-03-28 13:29:17 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************ --> @@ -46,13 +48,13 @@ </history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3154015"><bookmark_value>join properties in relational databases</bookmark_value> +<bookmark xml-lang="en-US" branch="index" id="bm_id3154015"><bookmark_value>join properties</bookmark_value> <bookmark_value>link properties in relational databases</bookmark_value> -<bookmark_value>inner joins in relational databases</bookmark_value> +<bookmark_value>inner joins</bookmark_value> <bookmark_value>joins in databases</bookmark_value> -<bookmark_value>left joins in relational databases</bookmark_value> -<bookmark_value>right joins in relational databases</bookmark_value> -<bookmark_value>full joins in relational databases</bookmark_value> +<bookmark_value>left joins</bookmark_value> +<bookmark_value>right joins</bookmark_value> +<bookmark_value>full joins</bookmark_value> </bookmark> <paragraph role="heading" id="hd_id3154015" xml-lang="en-US" level="1" l10n="U" oldref="1">Relations</paragraph> <paragraph role="paragraph" id="par_id3151205" xml-lang="en-US" l10n="U" oldref="2">If you double-click a connection between two linked fields in the query design, or if you choose <emph>Insert - New Relation</emph>, the <emph>Relations</emph> dialog appears. These properties will be used in all queries created in the future.</paragraph> diff --git a/helpcontent2/source/text/shared/explorer/database/04000000.xhp b/helpcontent2/source/text/shared/explorer/database/04000000.xhp index ffe76c6f1d..c5f8a3118b 100644 --- a/helpcontent2/source/text/shared/explorer/database/04000000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/04000000.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 04000000.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.6 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:17 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,7 +42,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-10-28T09:51:21">converted from old format - fpe</lastedited> +<lastedited date="2005-02-10T16:34:07">converted from old format - fpe</lastedited> </history> </meta> <body> @@ -81,12 +61,13 @@ <embed href="text/shared/02/12100200.xhp#suchentext"/> <paragraph role="heading" id="hd_id3149784" xml-lang="en-US" level="2" l10n="U" oldref="30"><link href="text/shared/main0213.xhp" name="Sorting and Filtering Data">Sorting and Filtering Data</link></paragraph> <paragraph role="paragraph" id="par_id3151384" xml-lang="en-US" l10n="CHG" oldref="28">You will find the sorting and filter functions in the toolbar when you open a form in user mode.</paragraph> +<paragraph role="heading" id="hd_id3148944" xml-lang="en-US" level="2" l10n="U" oldref="29"><switchinline select="sys"><caseinline select="MAC"> +</caseinline><caseinline select="OS2"> +</caseinline><defaultinline><link href="text/shared/02/01170203.xhp" name="Subforms">Subforms</link></defaultinline></switchinline></paragraph> <switch select="sys"> <case select="MAC"> </case> -<default> -<paragraph role="heading" id="hd_id3148944" xml-lang="en-US" level="2" l10n="U" oldref="29"><link href="text/shared/02/01170203.xhp" name="Subforms">Subforms</link></paragraph> -<embed href="text/shared/02/01170203.xhp#wozu"/> +<default><embed href="text/shared/02/01170203.xhp#wozu"/> </default> </switch> </body> diff --git a/helpcontent2/source/text/shared/explorer/database/05010000.xhp b/helpcontent2/source/text/shared/explorer/database/05010000.xhp index a9931e822a..621f5eb27f 100644 --- a/helpcontent2/source/text/shared/explorer/database/05010000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05010000.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 05010000.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.6 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:17 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,7 +42,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-01T11:34:23">converted from old format - fpe</lastedited> +<lastedited date="2004-12-17T13:34:00">converted from old format - fpe</lastedited> </history> </meta> <body> @@ -88,16 +68,16 @@ <paragraph role="paragraph" id="par_id3145315" xml-lang="en-US" l10n="U" oldref="11"><ahelp hid="HID_TABDESIGN_COMMENTCELL">Specifies an optional description.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3155630" xml-lang="en-US" l10n="U" oldref="12">The row headers contain the following context menu commands:</paragraph> <paragraph role="heading" id="hd_id3156330" xml-lang="en-US" level="3" l10n="U" oldref="13">Cut</paragraph> -<paragraph role="paragraph" id="par_id3159157" xml-lang="en-US" l10n="U" oldref="14">Cuts the selected row to the clipboard.</paragraph> +<paragraph role="paragraph" id="par_id3159157" xml-lang="en-US" l10n="U" oldref="14">Cuts the selected row(s) to the clipboard.</paragraph> <paragraph role="heading" id="hd_id3159177" xml-lang="en-US" level="3" l10n="U" oldref="15">Copy</paragraph> -<paragraph role="paragraph" id="par_id3148685" xml-lang="en-US" l10n="U" oldref="16">Copies the selected row to the clipboard.</paragraph> +<paragraph role="paragraph" id="par_id3148685" xml-lang="en-US" l10n="U" oldref="16">Copies the selected row(s) to the clipboard.</paragraph> <paragraph role="heading" id="hd_id3156327" xml-lang="en-US" level="3" l10n="U" oldref="17">Paste</paragraph> -<paragraph role="paragraph" id="par_id3152472" xml-lang="en-US" l10n="U" oldref="18">Pastes the content of the clipboard.</paragraph> +<paragraph role="paragraph" id="par_id3152472" xml-lang="en-US" l10n="U" oldref="18">Pastes the content of the clipboard</paragraph> <paragraph role="heading" id="hd_id3144511" xml-lang="en-US" level="3" l10n="U" oldref="19">Delete</paragraph> -<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid=".uno:Delete">Deletes the selected row.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3148550" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid=".uno:Delete">Deletes the selected row(s)</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/SID_TABLEDESIGN_INSERTROWS" id="bm_id3159414" localize="false"/> <paragraph role="heading" id="hd_id3147303" xml-lang="en-US" level="3" l10n="U" oldref="21">Insert Rows</paragraph> -<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US" l10n="CHG" oldref="22"><ahelp hid="SID_TABLEDESIGN_INSERTROWS">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has been saved.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US" l10n="U" oldref="22"><ahelp hid="SID_TABLEDESIGN_INSERTROWS">Inserts rows in front of the marked cells.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/SID_TABLEDESIGN_TABED_PRIMARYKEY" id="bm_id3150791" localize="false"/> <paragraph role="heading" id="hd_id3153524" xml-lang="en-US" level="3" l10n="U" oldref="23">Primary Key</paragraph> <paragraph role="paragraph" id="par_id3150398" xml-lang="en-US" l10n="U" oldref="24"><ahelp hid="SID_TABLEDESIGN_TABED_PRIMARYKEY">If this command has a check mark, the data field in this line is a primary key.</ahelp> By clicking the command you activate/deactivate the status. The command is only visible if the data source supports primary keys.</paragraph> diff --git a/helpcontent2/source/text/shared/explorer/database/05020000.xhp b/helpcontent2/source/text/shared/explorer/database/05020000.xhp index d9be177d37..48ee802e3b 100644 --- a/helpcontent2/source/text/shared/explorer/database/05020000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05020000.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 05020000.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.6 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:17 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,13 +42,13 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-22T09:51:36">converted from old format - fpe</lastedited> +<lastedited date="2005-05-30T16:18:57">converted from old format - fpe</lastedited> </history> </meta> <body> <section id="relationen"> <bookmark xml-lang="en-US" branch="hid/HID_CTL_RELATIONTAB" id="bm_id3153345" localize="false"/> -<paragraph role="heading" id="hd_id3153323" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05020000.xhp" name="Relations">Relationships</link></paragraph> +<paragraph role="heading" id="hd_id3153323" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05020000.xhp" name="Relations">Relations</link></paragraph> <bookmark xml-lang="en-US" branch="index" id="bm_id3146957"><bookmark_value>relational databases</bookmark_value> </bookmark> <paragraph role="paragraph" id="par_id3146957" xml-lang="en-US" l10n="U" oldref="2">This command opens the <emph>Relation Design </emph>window, which allows you to define relationships between various database tables.</paragraph> @@ -76,14 +56,14 @@ <paragraph role="paragraph" id="par_id3154823" xml-lang="en-US" l10n="CHG" oldref="19"><ahelp hid="HID_CTL_RELATIONTAB">Here you can link together tables from the current database through common data fields.</ahelp> Click the <emph>New Relation</emph> icon to create the relationships, or simply drag-and-drop with the mouse.</paragraph> <paragraph role="paragraph" id="par_id3166460" xml-lang="en-US" l10n="E" localize="false"><link href="text/shared/00/00000450.xhp#relationen"><embedvar href="text/shared/00/00000004.xhp#wie"/></link></paragraph> <paragraph role="note" id="par_id3145316" xml-lang="en-US" l10n="U" oldref="3">This function is only available if you are working with a relational database.</paragraph> -<paragraph role="paragraph" id="par_id3149235" xml-lang="en-US" l10n="CHG" oldref="4">When you choose <emph>Tools - Relationships</emph>, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click the <emph>Add Tables</emph> icon. The <link href="text/shared/02/14020100.xhp" name="Add Tables">Add Tables</link> dialog opens in which you can select the tables that you want.</paragraph> +<paragraph role="paragraph" id="par_id3149235" xml-lang="en-US" l10n="U" oldref="4">If you click the <emph>Relation Design</emph> command in the context menu of the table container, a window opens in which all the existing relationships between the tables of the current database are shown. If no relationships have been defined, or if you want to relate other tables of the database to each other, then click the <emph>Add Tables</emph> icon. The <link href="text/shared/02/14020100.xhp" name="Add Tables">Add Tables</link> dialog opens in which you can select the tables that you want.</paragraph> <embed href="text/shared/00/00000450.xhp#sytabelle"/> -<paragraph role="note" id="par_id3152812" xml-lang="en-US" l10n="U" oldref="17">If the <emph>Relation Design</emph> window is open, the selected tables cannot be modified, even in Table Design mode. This ensures that tables are not changed while the relations are being created.</paragraph> +<paragraph role="note" id="par_id3152812" xml-lang="en-US" l10n="U" oldref="17">If the <emph>Relation Design</emph> window is open, the selected tables cannot be modified, even in table Design Mode. This ensures that tables are not changed while the relations are being created.</paragraph> <paragraph role="paragraph" id="par_id3150541" xml-lang="en-US" l10n="U" oldref="5">The selected tables are shown in the top area of the design view. You can close a table window through the context menu or with the Delete key.</paragraph> <embed href="text/shared/explorer/database/02010100.xhp#darstellungaendern"/> <bookmark xml-lang="en-US" branch="index" id="bm_id3148922"><bookmark_value>primary keys;inserting</bookmark_value> <bookmark_value>keys;primary keys</bookmark_value> -<bookmark_value>external keys in relational databases</bookmark_value> +<bookmark_value>external keys</bookmark_value> </bookmark> <paragraph role="heading" id="hd_id3148922" xml-lang="en-US" level="2" l10n="U" oldref="6">Primary key and other key</paragraph> <paragraph role="paragraph" id="par_id3149168" xml-lang="en-US" l10n="U" oldref="7">If you want to define a relation among the different tables, you should enter a <link href="text/shared/00/00000005.xhp#primaerschluessel" name="primary key">primary key</link> that clearly identifies a data field of the existing table. You can refer to the primary key from other tables to access the data of this table. All data fields referring to this primary key will be identified as an external key.</paragraph> diff --git a/helpcontent2/source/text/shared/explorer/database/05030000.xhp b/helpcontent2/source/text/shared/explorer/database/05030000.xhp index 85a394bf11..32c5eac042 100755 --- a/helpcontent2/source/text/shared/explorer/database/05030000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05030000.xhp @@ -1,87 +1,71 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 05030000.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.5 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:17 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> <helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase05030000xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Copy a Table by Drag-and-Drop</title> +<title id="tit" xml-lang="en-US">Copy Query or Table by Drag-and-Drop</title> <filename>/text/shared/explorer/database/05030000.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-18T12:51:21">converted from old format - fpe</lastedited> +<lastedited date="2004-08-10T15:09:38">converted from old format - fpe</lastedited> </history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3155535"><bookmark_value>tables in databases; copying database tables </bookmark_value> +<paragraph role="heading" id="hd_id3154894" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05030000.xhp" name="Copy Query or Table by Drag-and-Drop">Copy Query or Table by Drag-and-Drop</link></paragraph> +<bookmark xml-lang="en-US" branch="index" id="bm_id3155535"><bookmark_value>queries; copying</bookmark_value> +<bookmark_value>tables in databases; copying database tables </bookmark_value> <bookmark_value>database tables; copying</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3154894" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05030000.xhp" name="Copy a Table by Drag-and-Drop">Copy a Table by Drag-and-Drop</link></paragraph> -<paragraph role="paragraph" id="par_id3155535" xml-lang="en-US" l10n="CHG" oldref="2"><comment>UFI: fix to #i18395#</comment>Dragging-and-dropping a table into the "table" area of a database file window opens the <emph>Copy Table </emph>dialog. Here you can define the options for copying a table.</paragraph> +<paragraph role="paragraph" id="par_id3155535" xml-lang="en-US" l10n="CHG" oldref="2"><comment>UFI: fix to #i18395#</comment>Dragging-and-dropping a query or table opens the <emph>Copy Table </emph>dialog, which allows you to define the options for copying a query or a table.</paragraph> <paragraph role="paragraph" id="par_id3147209" xml-lang="en-US" l10n="E" localize="false"><link href="text/shared/00/00000450.xhp#tabellecopy"><embedvar href="text/shared/00/00000004.xhp#wie"/></link></paragraph> <paragraph role="paragraph" id="par_id3148539" xml-lang="en-US" l10n="U" oldref="16">With the <emph>Copy Table </emph>dialog you can:</paragraph> <list type="unordered"> <listitem> -<paragraph role="listitem" id="par_id3153147" xml-lang="en-US" l10n="U" oldref="18">copy the data from the table into another table,</paragraph> +<paragraph role="listitem" id="par_id3149233" xml-lang="en-US" l10n="U" oldref="17">create a query copy,</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3153147" xml-lang="en-US" l10n="U" oldref="18">copy the data from the query into another query,</paragraph> </listitem> <listitem> <paragraph role="listitem" id="par_id3150504" xml-lang="en-US" l10n="U" oldref="19">use the structure of the table as the basis for creating a new table.</paragraph> </listitem> </list> -<paragraph role="paragraph" id="par_id3155628" xml-lang="en-US" l10n="U" oldref="20">You can copy within the same database or between different databases.</paragraph> +<paragraph role="paragraph" id="par_id3155628" xml-lang="en-US" l10n="U" oldref="20">You can copy within the same database or between different databases. Select the query and drag it into the table container of the desired database.</paragraph> <embed href="text/shared/explorer/database/05030100.xhp#tabkop"/> <embed href="text/shared/explorer/database/05030200.xhp#tabkop2"/> <embed href="text/shared/explorer/database/05030300.xhp#tabkop3"/> diff --git a/helpcontent2/source/text/shared/explorer/database/05030100.xhp b/helpcontent2/source/text/shared/explorer/database/05030100.xhp index dc2897ac34..5d6a447406 100644 --- a/helpcontent2/source/text/shared/explorer/database/05030100.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05030100.xhp @@ -1,59 +1,38 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 05030100.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.4 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:17 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> - <helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase05030100xml" indexer="include" status="PUBLISH"> @@ -62,13 +41,13 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-18T12:56:46">FPE: Switched for Adabas in So only (#i10510#)</lastedited> +<lastedited date="2004-04-27T17:28:53">FPE: Switched for Adabas in So only (#i10510#)</lastedited> </history> </meta> <body> <section id="tabkop"> <paragraph role="heading" id="hd_id3085157" xml-lang="en-US" level="1" l10n="U" oldref="28"><link href="text/shared/explorer/database/05030100.xhp" name="Copy Table">Copy Table</link></paragraph> -<paragraph role="paragraph" id="par_id3149264" xml-lang="en-US" l10n="CHG" oldref="29">You can copy a table by dragging and dropping the table onto the table area of a database file window. The <emph>Copy table </emph>dialog appears.</paragraph> +<paragraph role="paragraph" id="par_id3149264" xml-lang="en-US" l10n="U" oldref="29">If you copy a query or table in the data source view by dragging and dropping to a table container, the Copy<emph> Table</emph> dialog appears.</paragraph> </section> <bookmark xml-lang="en-US" branch="hid/HID_TAB_WIZ_TABLENAME_EDIT" id="bm_id3154840" localize="false"/> <paragraph role="heading" id="hd_id3154926" xml-lang="en-US" level="2" l10n="U" oldref="3">Table name</paragraph> @@ -86,15 +65,17 @@ <bookmark xml-lang="en-US" branch="hid/DBACCESS_RADIOBUTTON_TAB_WIZ_COPYTABLE_RB_APPENDDATA" id="bm_id3156347" localize="false"/> <paragraph role="heading" id="hd_id3155535" xml-lang="en-US" level="3" l10n="U" oldref="11">Attach data</paragraph> <paragraph role="paragraph" id="par_id3166410" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="DBACCESS_RADIOBUTTON_TAB_WIZ_COPYTABLE_RB_APPENDDATA">Appends the data of the table to be copied to an existing table.</ahelp></paragraph> -<paragraph role="paragraph" id="par_id3147275" xml-lang="en-US" l10n="U" oldref="13">The table definition must be exactly the same so that data can be copied. Data cannot be copied if a data field in the target table has another format than the data field in the source table.</paragraph> +<paragraph role="paragraph" id="par_id3147275" xml-lang="en-US" l10n="U" oldref="13">The table definition must be exactly the same so that data can be copied. Data cannot be copied if a data field in the target table has another format than the datafield in the source table.</paragraph> <paragraph role="paragraph" id="par_id3156117" xml-lang="en-US" l10n="U" oldref="31">Match the data field names in the<emph> Copy Table</emph> dialog on the <link href="text/shared/explorer/database/05030400.xhp" name="Apply Columns">Apply Columns</link> page.</paragraph> <paragraph role="paragraph" id="par_id3153252" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid="DBACCESS_RADIOBUTTON_TAB_WIZ_COPYTABLE_RB_APPENDDATA">If the data cannot be attached, you will see a list of fields in the <emph>Column Info</emph> dialog whose data cannot be copied.</ahelp> If you confirm this dialog with OK, only the data that does not appear in the list will be attached.</paragraph> <paragraph role="note" id="par_id3158430" xml-lang="en-US" l10n="U" oldref="15">If the fields of the target table have a smaller field length than in the source table when data is being attached, the source data fields will automatically be truncated to match the field lengths in the target table.</paragraph> + <bookmark xml-lang="en-US" branch="index" id="bm_id3149164"><bookmark_value>primary keys; defining</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/DBACCESS_CHECKBOX_TAB_WIZ_COPYTABLE_CB_PRIMARY_COLUMN" id="bm_id3148564" localize="false"/> <paragraph role="heading" id="hd_id3149164" xml-lang="en-US" level="3" l10n="U" oldref="24">Create primary key</paragraph> -<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US" l10n="U" oldref="25"><ahelp hid="DBACCESS_CHECKBOX_TAB_WIZ_COPYTABLE_CB_PRIMARY_COLUMN"> Automatically generates a primary key data field and fills it with values.</ahelp><switchinline select="distrib"><caseinline select="COMMERCIAL">You should use this field if you copy a dBase table to the Adabas format, since in the Adabas format a primary key must always be available in order to edit the table. +<paragraph role="paragraph" id="par_id3155922" xml-lang="en-US" l10n="U" oldref="25"><ahelp hid="DBACCESS_CHECKBOX_TAB_WIZ_COPYTABLE_CB_PRIMARY_COLUMN"> Automatically generates a primary key data field and fills it with values.</ahelp><switchinline select="distrib"> +<caseinline select="COMMERCIAL">You should use this field if you copy a dBase table to the Adabas format, since in the Adabas format a primary key must always be available in order to edit the table. </caseinline></switchinline></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_EDIT_TAB_WIZ_COPYTABLE_ET_KEYNAME" id="bm_id3147303" localize="false"/> <paragraph role="heading" id="hd_id3146794" xml-lang="en-US" level="3" l10n="U" oldref="26">Name</paragraph> diff --git a/helpcontent2/source/text/shared/explorer/database/05030200.xhp b/helpcontent2/source/text/shared/explorer/database/05030200.xhp index acbd311ea0..08a9e2eaf3 100755 --- a/helpcontent2/source/text/shared/explorer/database/05030200.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05030200.xhp @@ -1,88 +1,62 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 05030200.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.4 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:18 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ - * - * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************--><helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase05030200xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Apply columns</title> +<title xml-lang="en-US" id="tit">Apply columns</title> <filename>/text/shared/explorer/database/05030200.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-18T12:56:53">converted from old format - fpe</lastedited> +<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> </history> </meta> <body> -<section id="tabkop2"> -<paragraph role="heading" id="hd_id3150445" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05030200.xhp" name="Apply columns">Apply columns</link></paragraph> -<paragraph role="paragraph" id="par_id3147143" xml-lang="en-US" l10n="CHG" oldref="2">You can copy a table by dragging and dropping the table into the table area of a database file window. The <emph>Apply columns </emph>dialog is the second window of the <emph>Copy table</emph> dialog.</paragraph> -</section> -<paragraph role="heading" id="hd_id3155552" xml-lang="en-US" level="2" l10n="U" oldref="3">Existing columns</paragraph> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_MULTILISTBOX_TAB_WIZ_COLUMN_SELECT_LB_ORG_COLUMN_NAMES" id="bm_id3155805" localize="false"/> -<paragraph role="heading" id="hd_id3154751" xml-lang="en-US" level="3" l10n="U" oldref="4">Left list box</paragraph> -<paragraph role="paragraph" id="par_id3147088" xml-lang="en-US" l10n="U" oldref="5"><ahelp hid="DBACCESS_MULTILISTBOX_TAB_WIZ_COLUMN_SELECT_LB_ORG_COLUMN_NAMES">Lists the available data fields that you can include in the copied table. To copy a data field, click its name, and then click > button. To copy all of the fields, click the <emph>>></emph> button.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_MULTILISTBOX_TAB_WIZ_COLUMN_SELECT_LB_NEW_COLUMN_NAMES" id="bm_id3149827" localize="false"/> -<paragraph role="heading" id="hd_id3154823" xml-lang="en-US" level="3" l10n="U" oldref="6">Right list box</paragraph> -<paragraph role="paragraph" id="par_id3156426" xml-lang="en-US" l10n="U" oldref="7"><ahelp hid="DBACCESS_MULTILISTBOX_TAB_WIZ_COLUMN_SELECT_LB_NEW_COLUMN_NAMES">Lists the fields that you want to include in the copied table.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMN_RH" id="bm_id3152781" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMNS_RH" id="bm_id3147653" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMN_LH" id="bm_id3151110" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMNS_LH" id="bm_id3152996" localize="false"/> -<paragraph role="heading" id="hd_id3147242" xml-lang="en-US" level="3" l10n="U" oldref="8">Buttons</paragraph> -<paragraph role="paragraph" id="par_id3146797" xml-lang="en-US" l10n="U" oldref="9"><ahelp hid="DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMNS_LH">Adds or removes the selected field (<emph>> or < </emph>button) or all of the fields (<< or <emph>>> </emph>button).</ahelp></paragraph> -<paragraph role="paragraph" id="par_id3153561" xml-lang="en-US" l10n="U" oldref="10"><link href="text/shared/explorer/database/05030300.xhp" name="Next page">Next page</link></paragraph> -</body> + + + <section id="tabkop2"> + <paragraph id="hd_id3150445" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/shared/explorer/database/05030200.xhp" name="Apply columns">Apply columns</link></paragraph> + <paragraph xml-lang="en-US" oldref="2" role="paragraph" id="par_id3147143" l10n="U">In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The <emph>Apply columns </emph>dialog is the second window of the <emph>Copy table</emph> dialog.</paragraph> + </section> + <paragraph role="heading" level="2" id="hd_id3155552" l10n="U" xml-lang="en-US" oldref="3">Existing columns</paragraph> + <bookmark branch="hid/DBACCESS_MULTILISTBOX_TAB_WIZ_COLUMN_SELECT_LB_ORG_COLUMN_NAMES" xml-lang="en-US" id="bm_id3155805"/><paragraph role="heading" level="3" id="hd_id3154751" l10n="U" xml-lang="en-US" oldref="4">Left list box</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3147088" xml-lang="en-US" oldref="5"><ahelp visibility="visible" hid="DBACCESS_MULTILISTBOX_TAB_WIZ_COLUMN_SELECT_LB_ORG_COLUMN_NAMES">Lists the available data fields that you can include in the copied table. To copy a data field, click its name, and then click > button. To copy all of the fields, click the <emph>>></emph> button.</ahelp></paragraph> + <bookmark branch="hid/DBACCESS_MULTILISTBOX_TAB_WIZ_COLUMN_SELECT_LB_NEW_COLUMN_NAMES" xml-lang="en-US" id="bm_id3149827"/><paragraph role="heading" level="3" id="hd_id3154823" l10n="U" xml-lang="en-US" oldref="6">Right list box</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3156426" xml-lang="en-US" oldref="7"><ahelp hid="DBACCESS_MULTILISTBOX_TAB_WIZ_COLUMN_SELECT_LB_NEW_COLUMN_NAMES" visibility="visible">Lists the fields that you want to include in the copied table.</ahelp></paragraph> + <bookmark branch="hid/DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMN_RH" xml-lang="en-US" id="bm_id3152781"/><bookmark branch="hid/DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMNS_RH" xml-lang="en-US" id="bm_id3147653"/><bookmark branch="hid/DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMN_LH" xml-lang="en-US" id="bm_id3151110"/><bookmark branch="hid/DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMNS_LH" xml-lang="en-US" id="bm_id3152996"/><paragraph role="heading" level="3" id="hd_id3147242" l10n="U" xml-lang="en-US" oldref="8">Buttons</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3146797" xml-lang="en-US" oldref="9"><ahelp visibility="visible" hid="DBACCESS_IMAGEBUTTON_TAB_WIZ_COLUMN_SELECT_IB_COLUMNS_LH">Adds or removes the selected field (<emph>> or < </emph>button) or all of the fields (<< or <emph>>> </emph>button).</ahelp></paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3153561" xml-lang="en-US" oldref="10"><link href="text/shared/explorer/database/05030300.xhp" name="Next page">Next page</link></paragraph> + </body> </helpdocument> diff --git a/helpcontent2/source/text/shared/explorer/database/05030300.xhp b/helpcontent2/source/text/shared/explorer/database/05030300.xhp index 75317c4119..96ac751b2a 100755 --- a/helpcontent2/source/text/shared/explorer/database/05030300.xhp +++ b/helpcontent2/source/text/shared/explorer/database/05030300.xhp @@ -1,102 +1,73 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 05030300.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.4 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:18 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ - * - * - ************************************************************************--> - -<helpdocument version="1.0"> + ************************************************************************--><helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase05030300xml" indexer="include" status="PUBLISH"> -<title id="tit" xml-lang="en-US">Type formatting</title> +<title xml-lang="en-US" id="tit">Type formatting</title> <filename>/text/shared/explorer/database/05030300.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-18T12:56:58">converted from old format - fpe</lastedited> +<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> </history> </meta> <body> -<section id="tabkop3"> -<paragraph role="heading" id="hd_id3163829" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05030300.xhp" name="Type formatting">Type formatting</link></paragraph> -<paragraph role="paragraph" id="par_id3150247" xml-lang="en-US" l10n="CHG" oldref="2">You can copy a table by dragging and dropping the table into the table area of a database file window. The<emph> Type formatting </emph>dialog is the third page of the <emph>Copy table</emph> dialog.</paragraph> -</section> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_MULTILISTBOX_TAB_WIZ_TYPE_SELECT_LB_NEW_COLUMN_NAMES" id="bm_id3147291" localize="false"/> -<paragraph role="heading" id="hd_id3152801" xml-lang="en-US" level="2" l10n="U" oldref="3">List box</paragraph> -<paragraph role="paragraph" id="par_id3145313" xml-lang="en-US" l10n="U" oldref="4"><ahelp hid="DBACCESS_MULTILISTBOX_TAB_WIZ_TYPE_SELECT_LB_NEW_COLUMN_NAMES">Lists the data fields that will be included in to the copied table.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3155535" xml-lang="en-US" level="2" l10n="U" oldref="5">Column information</paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_COLUMNNAME" id="bm_id3153311" localize="false"/> -<paragraph role="heading" id="hd_id3156426" xml-lang="en-US" level="3" l10n="U" oldref="7">Field name</paragraph> -<paragraph role="paragraph" id="par_id3153681" xml-lang="en-US" l10n="U" oldref="8"><ahelp hid="HID_TAB_ENT_COLUMNNAME">Displays the name of the selected data field. If you want, you can enter a new name.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_TYPE" id="bm_id3154749" localize="false"/> -<paragraph role="heading" id="hd_id3156113" xml-lang="en-US" level="3" l10n="U" oldref="9">Field type</paragraph> -<paragraph role="paragraph" id="par_id3149811" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="HID_TAB_ENT_TYPE">Select a field type.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_TEXT_LEN" id="bm_id3149795" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_LEN" id="bm_id3149516" localize="false"/> -<paragraph role="heading" id="hd_id3149763" xml-lang="en-US" level="3" l10n="U" oldref="11">Length</paragraph> -<paragraph role="paragraph" id="par_id3155449" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="HID_TAB_ENT_LEN">Enter the number of characters for the data field.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_SCALE" id="bm_id3154285" localize="false"/> -<paragraph role="heading" id="hd_id3159176" xml-lang="en-US" level="3" l10n="U" oldref="13">Decimal places</paragraph> -<paragraph role="paragraph" id="par_id3153666" xml-lang="en-US" l10n="U" oldref="14"><ahelp hid="HID_TAB_ENT_SCALE">Enter the number of decimal places for the data field. This option is only available for numerical or decimal data fields.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_BOOL_DEFAULT" id="bm_id3156155" localize="false"/> -<paragraph role="heading" id="hd_id3150276" xml-lang="en-US" level="3" l10n="U" oldref="15">Default value</paragraph> -<paragraph role="paragraph" id="par_id3147620" xml-lang="en-US" l10n="U" oldref="16"><ahelp hid="HID_TAB_ENT_BOOL_DEFAULT">Select the default value for a Yes/No field.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3153087" xml-lang="en-US" level="2" l10n="U" oldref="17">Automatic type recognition</paragraph> -<paragraph role="paragraph" id="par_id3153561" xml-lang="en-US" l10n="U" oldref="18">$[officename] can automatically recognize field contents when you copy database tables by drag and drop.</paragraph> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_NUMERICFIELD_TAB_WIZ_TYPE_SELECT_ET_AUTO" id="bm_id3153061" localize="false"/> -<paragraph role="heading" id="hd_id3156023" xml-lang="en-US" level="3" l10n="U" oldref="19">(max.) lines</paragraph> -<paragraph role="paragraph" id="par_id3155923" xml-lang="en-US" l10n="U" oldref="20"><ahelp hid="DBACCESS_NUMERICFIELD_TAB_WIZ_TYPE_SELECT_ET_AUTO">Enter the number of lines to use for automatic type recognition.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_PUSHBUTTON_TAB_WIZ_TYPE_SELECT_PB_AUTO" id="bm_id3148946" localize="false"/> -<paragraph role="heading" id="hd_id3154347" xml-lang="en-US" level="3" l10n="U" oldref="21">Auto</paragraph> -<paragraph role="paragraph" id="par_id3152361" xml-lang="en-US" l10n="U" oldref="22"><ahelp hid="DBACCESS_PUSHBUTTON_TAB_WIZ_TYPE_SELECT_PB_AUTO">Enables automatic type recognition.</ahelp></paragraph> -</body> + + + <section id="tabkop3"> + <paragraph id="hd_id3163829" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/shared/explorer/database/05030300.xhp" name="Type formatting">Type formatting</link></paragraph> + <paragraph xml-lang="en-US" oldref="2" role="paragraph" id="par_id3150247" l10n="U">In the data source explorer, you can copy a table by dragging and dropping the table onto the table container. The<emph> Type formatting </emph>dialog is the third window of the <emph>Copy table</emph> dialog.</paragraph> + </section> + <bookmark branch="hid/DBACCESS_MULTILISTBOX_TAB_WIZ_TYPE_SELECT_LB_NEW_COLUMN_NAMES" xml-lang="en-US" id="bm_id3147291"/><paragraph role="heading" level="2" id="hd_id3152801" l10n="U" xml-lang="en-US" oldref="3">List box</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3145313" xml-lang="en-US" oldref="4"><ahelp hid="DBACCESS_MULTILISTBOX_TAB_WIZ_TYPE_SELECT_LB_NEW_COLUMN_NAMES" visibility="visible">Lists the data fields that will be included in to the copied table.</ahelp></paragraph> + <paragraph role="heading" level="2" id="hd_id3155535" l10n="U" xml-lang="en-US" oldref="5">Column information</paragraph> + <bookmark branch="hid/HID_TAB_ENT_COLUMNNAME" xml-lang="en-US" id="bm_id3153311"/><paragraph role="heading" level="3" id="hd_id3156426" l10n="U" xml-lang="en-US" oldref="7">Field name</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3153681" xml-lang="en-US" oldref="8"><ahelp hid="HID_TAB_ENT_COLUMNNAME" visibility="visible">Displays the name of the selected data field. If you want, you can enter a new name.</ahelp></paragraph> + <bookmark branch="hid/HID_TAB_ENT_TYPE" xml-lang="en-US" id="bm_id3154749"/><paragraph role="heading" level="3" id="hd_id3156113" l10n="U" xml-lang="en-US" oldref="9">Field type</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3149811" xml-lang="en-US" oldref="10"><ahelp hid="HID_TAB_ENT_TYPE" visibility="visible">Select a field type.</ahelp></paragraph> + <bookmark branch="hid/HID_TAB_ENT_TEXT_LEN" xml-lang="en-US" id="bm_id3149795"/><bookmark branch="hid/HID_TAB_ENT_LEN" xml-lang="en-US" id="bm_id3149516"/><paragraph role="heading" level="3" id="hd_id3149763" l10n="U" xml-lang="en-US" oldref="11">Length</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3155449" xml-lang="en-US" oldref="12"><ahelp hid="HID_TAB_ENT_LEN" visibility="visible">Enter the number of characters for the data field.</ahelp></paragraph> + <bookmark branch="hid/HID_TAB_ENT_SCALE" xml-lang="en-US" id="bm_id3154285"/><paragraph role="heading" level="3" id="hd_id3159176" l10n="U" xml-lang="en-US" oldref="13">Decimal places</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3153666" xml-lang="en-US" oldref="14"><ahelp hid="HID_TAB_ENT_SCALE" visibility="visible">Enter the number of decimal places for the data field. This option is only available for numerical or decimal data fields.</ahelp></paragraph> + <bookmark branch="hid/HID_TAB_ENT_BOOL_DEFAULT" xml-lang="en-US" id="bm_id3156155"/><paragraph role="heading" level="3" id="hd_id3150276" l10n="U" xml-lang="en-US" oldref="15">Default value</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3147620" xml-lang="en-US" oldref="16"><ahelp hid="HID_TAB_ENT_BOOL_DEFAULT" visibility="visible">Select the default value for a Yes/No field.</ahelp></paragraph> + <paragraph role="heading" level="2" id="hd_id3153087" l10n="U" xml-lang="en-US" oldref="17">Automatic type recognition</paragraph> + <paragraph role="paragraph" id="par_id3153561" l10n="U" xml-lang="en-US" oldref="18">$[officename] can automatically recognize field contents when you copy database tables by drag and drop.</paragraph> + <bookmark branch="hid/DBACCESS_NUMERICFIELD_TAB_WIZ_TYPE_SELECT_ET_AUTO" xml-lang="en-US" id="bm_id3153061"/><paragraph role="heading" level="3" id="hd_id3156023" l10n="U" xml-lang="en-US" oldref="19">(max.) lines</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3155923" xml-lang="en-US" oldref="20"><ahelp hid="DBACCESS_NUMERICFIELD_TAB_WIZ_TYPE_SELECT_ET_AUTO" visibility="visible">Enter the number of lines to use for automatic type recognition.</ahelp></paragraph> + <bookmark branch="hid/DBACCESS_PUSHBUTTON_TAB_WIZ_TYPE_SELECT_PB_AUTO" xml-lang="en-US" id="bm_id3148946"/><paragraph role="heading" level="3" id="hd_id3154347" l10n="U" xml-lang="en-US" oldref="21">Auto</paragraph> + <paragraph l10n="U" role="paragraph" id="par_id3152361" xml-lang="en-US" oldref="22"><ahelp hid="DBACCESS_PUSHBUTTON_TAB_WIZ_TYPE_SELECT_PB_AUTO" visibility="visible">Enables automatic type recognition.</ahelp></paragraph> + </body> </helpdocument> diff --git a/helpcontent2/source/text/shared/explorer/database/11000002.xhp b/helpcontent2/source/text/shared/explorer/database/11000002.xhp index 8bfe581540..0aa58c1178 100644 --- a/helpcontent2/source/text/shared/explorer/database/11000002.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11000002.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 11000002.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.5 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:18 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,24 +42,29 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-18T15:43:09">FPE: Removed mentioning of Adabas (#i10510#)</lastedited> +<lastedited date="2005-05-30T14:41:34">FPE: Removed mentioning of Adabas (#i10510#)</lastedited> </history> </meta> <body> +<bookmark xml-lang="en-US" branch="index" id="bm_id3155449"><bookmark_value>databases;drag and drop</bookmark_value> +</bookmark> <paragraph role="heading" id="hd_id3151299" xml-lang="en-US" level="1" l10n="U" oldref="93"><link href="text/shared/explorer/database/11000002.xhp" name="Data sources in $[officename]">Data sources in $[officename]</link></paragraph> +<paragraph role="paragraph" id="par_id3150445" xml-lang="en-US" l10n="U" oldref="94">You can register a database with $[officename] and then insert records from the database into a document.</paragraph> <section id="adressbuch"> <paragraph role="heading" id="hd_id3150616" xml-lang="en-US" level="2" l10n="U" oldref="49">Selecting the Address Book</paragraph> <embed href="text/shared/guide/data_addressbook.xhp#adressbuch"/> <paragraph role="paragraph" id="par_id3153049" xml-lang="en-US" l10n="CHG" oldref="101">To select the address book that you want to use, choose <link href="text/shared/01/01110101.xhp" name="File - Templates - Address Book Source"><emph>File - Templates - Address Book Source</emph></link>.</paragraph> </section> <paragraph role="heading" id="hd_id3147275" xml-lang="en-US" level="2" l10n="U" oldref="26">Opening a Data Source</paragraph> -<list type="unordered"> -<listitem> <paragraph role="paragraph" id="par_id3154143" xml-lang="en-US" l10n="U" oldref="102">To open the data source view, press F4 in a text, spreadsheet or form document.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3154046" xml-lang="en-US" l10n="CHG" oldref="11">To view the contents of a database, click the plus sign (+) in front of the name in the data source view.</paragraph> -</listitem> -</list> +<paragraph role="paragraph" id="par_id3154046" xml-lang="en-US" l10n="U" oldref="11">To view the contents of a database, click the plus sign (+) in front it name in the data source view.</paragraph> +<paragraph role="heading" id="hd_id3155449" xml-lang="en-US" level="3" l10n="U" oldref="28">Copying and Moving Database Objects</paragraph> +<paragraph role="paragraph" id="par_id3149164" xml-lang="en-US" l10n="U" oldref="14">In the data source view, you can copy database objects by drag and drop, even within the same database.</paragraph> +<paragraph role="paragraph" id="par_id3154897" xml-lang="en-US" l10n="U" oldref="100">To quickly add a record from a table cell in a $[officename] Writer document, an HTML document or from $[officename] Calc, select the cell, and then drag it into a database table in data source view. You can also drag a record from a database table into a document.</paragraph> +<paragraph role="paragraph" id="par_id3153561" xml-lang="en-US" l10n="U" oldref="52">To move a database object, hold down Shift while you drag.</paragraph> +<paragraph role="note" id="par_id3147559" xml-lang="en-US" l10n="CHG" oldref="53">Field naming conventions are different for different database types. For example, in dBase tables, field names can only be 10 characters long.</paragraph> +<paragraph role="heading" id="hd_id3145069" xml-lang="en-US" level="3" l10n="U" oldref="40">Copying database queries</paragraph> +<paragraph role="paragraph" id="par_id3151056" xml-lang="en-US" l10n="U" oldref="31">To create a new query that is similar to an existing one, simply drag the existing query onto the Queries container in the data source view.</paragraph> +<paragraph role="paragraph" id="par_id3150085" xml-lang="en-US" l10n="U" oldref="34">If you drag the query onto a table container, the query is treated as a table.</paragraph> </body> </helpdocument> diff --git a/helpcontent2/source/text/shared/explorer/database/11020000.xhp b/helpcontent2/source/text/shared/explorer/database/11020000.xhp index c65d1d003e..c9d6dea7ca 100644 --- a/helpcontent2/source/text/shared/explorer/database/11020000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11020000.xhp @@ -1,72 +1,55 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 11020000.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.6 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:18 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> <helpdocument version="1.0"> <meta> -<topic id="textsharedexplorerdatabase11020000xml" indexer="exclude" status="PUBLISH"> +<topic id="textsharedexplorerdatabase11020000xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">ODBC</title> <filename>/text/shared/explorer/database/11020000.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-23T15:50:22">converted from old format - fpe</lastedited> +<lastedited date="2004-10-08T15:24:01">converted from old format - fpe</lastedited> </history> </meta> <body> <section id="odbc"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3149031"><bookmark_value>ODBC;database</bookmark_value> +<bookmark_value>databases;ODBC</bookmark_value> +</bookmark> <paragraph role="heading" id="hd_id3149031" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/11020000.xhp" name="ODBC">ODBC</link></paragraph> <paragraph role="paragraph" id="par_id3150499" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="">Specifies the settings for <link href="text/shared/00/00000005.xhp#odbc" name="ODBC">ODBC</link> databases. This includes your user access data, driver settings, and font definitions.</ahelp></paragraph> </section> diff --git a/helpcontent2/source/text/shared/explorer/database/11080000.xhp b/helpcontent2/source/text/shared/explorer/database/11080000.xhp index 550e41c41a..765cbf6c8e 100644 --- a/helpcontent2/source/text/shared/explorer/database/11080000.xhp +++ b/helpcontent2/source/text/shared/explorer/database/11080000.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: 11080000.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.6 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:18 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,7 +42,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-11-14T11:00:47">converted from old format - fpe</lastedited> +<lastedited date="2004-10-18T16:07:36">converted from old format - fpe</lastedited> </history> </meta> <body> @@ -70,12 +50,10 @@ <bookmark_value>databases; administration through SQL</bookmark_value> </bookmark> <paragraph role="paragraph" id="par_id3148983" xml-lang="en-US" l10n="E" oldref="22" localize="false"/> -<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="exe"><link href="text/shared/explorer/database/11080000.xhp" name="Execute SQL statement">Execute SQL statement</link> -</variable></paragraph> +<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/11080000.xhp" name="Execute SQL statement">Execute SQL statement</link></paragraph> <paragraph role="paragraph" id="par_id3154288" xml-lang="en-US" l10n="CHG" oldref="2"><variable id="sqltext"><ahelp hid="">Opens a dialog where you can enter an SQL command for administering a database.</ahelp> </variable></paragraph> <paragraph role="paragraph" id="par_id3153748" xml-lang="en-US" l10n="E" localize="false"><link href="text/shared/00/00000450.xhp#SQLStatement"><embedvar href="text/shared/00/00000004.xhp#wie"/></link></paragraph> -<embed href="text/shared/guide/data_enter_sql.xhp#data_enter_sql"/> <paragraph role="paragraph" id="par_id3147275" xml-lang="en-US" l10n="U" oldref="23">You can only enter administration commands in this dialog, such as Grant, Create Table, or Drop Table, and not filter commands. The commands that you can enter depend on the data source, for example, dBase can only run some of the SQL commands list here.</paragraph> <paragraph role="note" id="par_id3154860" xml-lang="en-US" l10n="U" oldref="10">To run an SQL query for filtering data in the database, use the <link href="text/shared/explorer/database/02010100.xhp" name="Query Design">Query Design</link>.</paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_MULTILINEEDIT_DLG_DIRECTSQL_ME_SQL" id="bm_id3150772" localize="false"/> diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz00.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz00.xhp index 67aea875c0..166c12a4c5 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz00.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz00.xhp @@ -2,33 +2,36 @@ <!-- *********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 + * $RCSfile: dabawiz00.xhp,v $ * + * $Revision: 1.8 $ * - * Sun Microsystems Inc., October, 2000 + * last change: $Author: obo $ $Date: 2006-03-28 13:29:18 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************ --> @@ -49,9 +52,8 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id2026429"><bookmark_value>wizards;databases</bookmark_value> <bookmark_value>Database Wizard</bookmark_value> </bookmark> -<bookmark xml-lang="en-US" branch="hid/HID_DLG_DATABASE_WIZARD" id="bm_id2611468" localize="false"/> <paragraph role="heading" id="par_idN105B4" xml-lang="en-US" level="1" l10n="NEW"><link href="text/shared/explorer/database/dabawiz00.xhp">Database Wizard</link></paragraph> -<paragraph role="paragraph" id="par_idN105C4" xml-lang="en-US" l10n="NEW"><ahelp hid=".">The Database Wizard creates a database file that contains information about a database.</ahelp></paragraph> +<paragraph role="paragraph" id="par_idN105C4" xml-lang="en-US" l10n="NEW"><ahelp hid=".">The Database Wizard creates a <link href="text/shared/explorer/database/dabadoc.xhp">database file</link> that contains information about a database.</ahelp></paragraph> </section> <paragraph role="paragraph" id="par_idN105D5" xml-lang="en-US" l10n="NEW">Depending on the type of operation and the type of database, the Database Wizard consists of a varying number of steps.</paragraph> <list type="unordered"> diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz02ado.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz02ado.xhp index d4d6c44b42..b3f7d365d9 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz02ado.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz02ado.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: dabawiz02ado.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.8 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:19 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,17 +42,11 @@ </topic> <history> <created date="2004-07-28T15:45:26">UFI: Database Wizard ADO page</created> -<lastedited date="2005-11-28T15:16:05">YJ: checked</lastedited> +<lastedited date="2005-02-07T13:21:05">YJ: checked</lastedited> </history> </meta> <body> <paragraph role="heading" id="par_idN1054C" xml-lang="en-US" level="1" l10n="NEW">ADO Connection</paragraph> -<switch select="sys"> -<case select="WIN"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3155934"><bookmark_value>ADO databases</bookmark_value> -<bookmark_value>MS ADO interface</bookmark_value> -<bookmark_value>databases;ADO</bookmark_value> -</bookmark> <paragraph role="paragraph" id="par_idN10550" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specifies the options for adding an ADO (Microsoft ActiveX Data Objects) database.</ahelp><comment>UFI: copied text from shared\explorer\database\11160000</comment></paragraph> <paragraph role="note" id="par_idN10565" xml-lang="en-US" l10n="NEW">The ADO interface is a Microsoft Windows proprietary container for connecting to databases.</paragraph> <paragraph role="tip" id="par_idN10568" xml-lang="en-US" l10n="NEW">$[officename] requires the Microsoft Data Access Components (MDAC) to use the ADO interface. Microsoft Windows 2000 and XP include these components by default. For earlier visions of Windows, you need to install MDAC separately. You can download MDAC from the Microsoft web site.</paragraph> @@ -93,10 +67,5 @@ <paragraph role="note" id="par_idN10596" xml-lang="en-US" l10n="NEW">A user name can have a maximum of 18 characters.</paragraph> <paragraph role="note" id="par_idN10599" xml-lang="en-US" l10n="NEW">A password must contain 3 to 18 characters.</paragraph> <paragraph role="paragraph" id="par_idN1059C" xml-lang="en-US" l10n="NEW"><link href="text/shared/explorer/database/dabawiz00.xhp">Database Wizard</link></paragraph> -</case> -<default> -<paragraph role="paragraph" id="par_id523697" xml-lang="en-US" l10n="NEW">ADO connection is only available for Windows systems.</paragraph> -</default> -</switch> </body> </helpdocument> diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz02jdbc.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz02jdbc.xhp index e8d6bf5602..36ca0543b5 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz02jdbc.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz02jdbc.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: dabawiz02jdbc.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.8 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:19 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,13 +42,10 @@ </topic> <history> <created date="2004-07-28T15:55:36">UFI: Database Wizard JDBC page</created> -<lastedited date="2005-11-23T15:48:40">DEDR: reviewed</lastedited> +<lastedited date="2005-02-07T13:46:15">DEDR: reviewed</lastedited> </history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3148522"><bookmark_value>JDBC; databases</bookmark_value> -<bookmark_value>databases; JDBC</bookmark_value> -</bookmark> <paragraph role="heading" id="par_idN105FC" xml-lang="en-US" level="1" l10n="NEW">JDBC Connection</paragraph> <paragraph role="paragraph" id="par_idN10600" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specifies the options to access a <link href="text/shared/00/00000005.xhp#jdbc" name="JDBC">JDBC</link> database.</ahelp><comment>copied text from shared\explorer\database\11110000</comment></paragraph> <paragraph role="heading" id="par_idN10623" xml-lang="en-US" level="2" l10n="NEW">JDBC Examples</paragraph> diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp index 2ffb3487cd..c49cecbde0 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz02ldap.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: dabawiz02ldap.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.8 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:19 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,14 +42,10 @@ </topic> <history> <created date="2004-07-28T15:24:27">UFI: Database Wizard LDAP page</created> -<lastedited date="2005-11-23T15:46:48">YJ: checked</lastedited> +<lastedited date="2005-02-07T13:30:45">YJ: checked</lastedited> </history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3155150"><bookmark_value>LDAP server; address books</bookmark_value> -<bookmark_value>address books; LDAP server</bookmark_value> -<bookmark_value>data sources; LDAP server</bookmark_value> -</bookmark> <paragraph role="heading" id="par_idN10554" xml-lang="en-US" level="1" l10n="NEW">LDAP Connection</paragraph> <paragraph role="paragraph" id="par_idN10558" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specifies the settings for importing a database using LDAP</ahelp> (<emph>Lightweight Directory Access Protocol)</emph>. This page is only available if you registered an LDAP server as an address database.<comment>UFI: copied text from shared\explorer\database\11190000</comment></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DSADMIN_LDAP_HOSTNAME" id="bm_id3147275" localize="false"/> diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz02odbc.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz02odbc.xhp index 0b01267ded..165b179470 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz02odbc.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz02odbc.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: dabawiz02odbc.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.7 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:19 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,13 +42,10 @@ </topic> <history> <created date="2004-07-28T16:27:31">UFI: Database Wizard ODBC page</created> -<lastedited date="2005-11-23T15:50:05">YJ: checked</lastedited> +<lastedited date="2005-02-07T13:45:09">YJ: checked</lastedited> </history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3149031"><bookmark_value>ODBC;database</bookmark_value> -<bookmark_value>databases;ODBC</bookmark_value> -</bookmark> <paragraph role="heading" id="par_idN1053D" xml-lang="en-US" level="1" l10n="NEW">ODBC Connection</paragraph> <paragraph role="paragraph" id="par_idN10541" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specifies the settings for <link href="text/shared/00/00000005.xhp#odbc" name="ODBC">ODBC</link> databases.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_PAGE_DBWIZARD_ODBC_ET_NAMEOFODBCDATASOURCE" id="bm_id9201025" localize="false"/> diff --git a/helpcontent2/source/text/shared/explorer/database/dabawiz02text.xhp b/helpcontent2/source/text/shared/explorer/database/dabawiz02text.xhp index 300e11f10c..08a075d29d 100755 --- a/helpcontent2/source/text/shared/explorer/database/dabawiz02text.xhp +++ b/helpcontent2/source/text/shared/explorer/database/dabawiz02text.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: dabawiz02text.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.7 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:19 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,12 +42,10 @@ </topic> <history> <created date="2004-07-28T15:03:00">UFI: Database Wizard text file</created> -<lastedited date="2005-11-24T12:59:26">YJ: checked</lastedited> +<lastedited date="2005-02-07T13:57:42">YJ: checked</lastedited> </history> </meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3156211"><bookmark_value>editing; text format database tables</bookmark_value> -</bookmark> <paragraph role="heading" id="par_idN1054F" xml-lang="en-US" level="1" l10n="NEW">Text File Connection</paragraph> <paragraph role="paragraph" id="par_idN10553" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Specifies the settings for importing a database in text format.</ahelp><comment>UFI: most text copied without editing from shared\explorer\database\11040000</comment></paragraph> <paragraph role="paragraph" id="par_idN10568" xml-lang="en-US" l10n="NEW">In a text format database, data is stored in an unformatted ASCII file, where each record comprises a row. The data fields are divided by separators. Text in the data fields is divided by quotation marks.</paragraph> diff --git a/helpcontent2/source/text/shared/explorer/database/querywizard00.xhp b/helpcontent2/source/text/shared/explorer/database/querywizard00.xhp index 421becf526..aed7e39c28 100755 --- a/helpcontent2/source/text/shared/explorer/database/querywizard00.xhp +++ b/helpcontent2/source/text/shared/explorer/database/querywizard00.xhp @@ -2,34 +2,37 @@ <!-- *********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 + * $RCSfile: querywizard00.xhp,v $ * + * $Revision: 1.7 $ * - * Sun Microsystems Inc., October, 2000 + * last change: $Author: obo $ $Date: 2006-03-28 13:29:19 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * - ** ************************************************************************ --> @@ -46,6 +49,9 @@ </meta> <body> <section id="querywizard"> +<bookmark xml-lang="en-US" branch="index" id="bm_id5757316"><bookmark_value>wizards;database queries</bookmark_value> +<bookmark_value>Query Wizard</bookmark_value> +</bookmark> <paragraph role="heading" id="par_idN1054C" xml-lang="en-US" level="1" l10n="NEW"><link href="text/shared/explorer/database/querywizard00.xhp">Query Wizard</link></paragraph> <paragraph role="paragraph" id="par_idN1055C" xml-lang="en-US" l10n="NEW"><ahelp hid=".">The Query Wizard helps you to design a database query.</ahelp> The saved query can be called later, either from the graphical user interface, or using the automatically created SQL language command.</paragraph> </section> diff --git a/helpcontent2/source/text/shared/explorer/database/tablewizard02.xhp b/helpcontent2/source/text/shared/explorer/database/tablewizard02.xhp index c02f67697e..cd3225a88a 100755 --- a/helpcontent2/source/text/shared/explorer/database/tablewizard02.xhp +++ b/helpcontent2/source/text/shared/explorer/database/tablewizard02.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: tablewizard02.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.6 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:19 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,7 +42,7 @@ </topic> <history> <created date="2004-07-06T15:06:41">UFI: new Table Wizard page 2</created> -<lastedited date="2005-11-18T09:43:04">YJ: checked</lastedited> +<lastedited date="2004-12-17T12:57:21">YJ: checked</lastedited> </history> </meta> <body> @@ -79,16 +59,13 @@ <paragraph role="paragraph" id="par_idN10578" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Remove the selected field from the list box.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_CMDPLUS" id="bm_id7230140" localize="false"/> <paragraph role="heading" id="par_idN1057B" xml-lang="en-US" level="3" l10n="NEW">+</paragraph> -<paragraph role="paragraph" id="par_idN1057F" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Add a new data field to the list box.</ahelp></paragraph> +<paragraph role="paragraph" id="par_idN1057F" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Add a new text field to the list box.</ahelp></paragraph> <paragraph role="heading" id="par_idN10582" xml-lang="en-US" level="2" l10n="NEW">Field information</paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_COLNAME" id="bm_id1665089" localize="false"/> <paragraph role="heading" id="par_idN10586" xml-lang="en-US" level="3" l10n="NEW">Field name</paragraph> <paragraph role="paragraph" id="par_idN1058A" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Displays the name of the selected data field. If you want, you can enter a new name.</ahelp></paragraph> <paragraph role="heading" id="par_idN1058D" xml-lang="en-US" level="3" l10n="NEW">Field type</paragraph> <paragraph role="paragraph" id="par_idN10591" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select a field type.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_AUTOINCREMENT" id="bm_id1055330" localize="false"/> -<paragraph role="heading" id="hd_id5486922" xml-lang="en-US" level="3" l10n="NEW">AutoValue</paragraph> -<paragraph role="paragraph" id="par_id4198736" xml-lang="en-US" l10n="NEW"><ahelp hid=".">If set to Yes, the values for this data field are generated by the database engine.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_REQUIRED" id="bm_id3498336" localize="false"/> <paragraph role="heading" id="par_idN106A0" xml-lang="en-US" level="3" l10n="NEW">Entry required</paragraph> <paragraph role="paragraph" id="par_idN106A6" xml-lang="en-US" l10n="NEW"><ahelp hid=".">If set to Yes, this field must not be empty.</ahelp><comment>not in spec doc</comment></paragraph> diff --git a/helpcontent2/source/text/shared/explorer/database/tablewizard03.xhp b/helpcontent2/source/text/shared/explorer/database/tablewizard03.xhp index 015ae58b7d..891d09f718 100755 --- a/helpcontent2/source/text/shared/explorer/database/tablewizard03.xhp +++ b/helpcontent2/source/text/shared/explorer/database/tablewizard03.xhp @@ -1,56 +1,36 @@ <?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * - * The Contents of this file are made available subject to the terms of - * either of the following licenses + * OpenOffice.org - a multi-platform office productivity suite * - * - GNU Lesser General Public License Version 2.1 - * - Sun Industry Standards Source License Version 1.1 + * $RCSfile: tablewizard03.xhp,v $ * - * Sun Microsystems Inc., October, 2000 + * $Revision: 1.7 $ * - * GNU Lesser General Public License Version 2.1 - * ============================================= - * Copyright 2000 by Sun Microsystems, Inc. - * 901 San Antonio Road, Palo Alto, CA 94303, USA + * last change: $Author: obo $ $Date: 2006-03-28 13:29:19 $ * - * This library is free software; you can redistribute it and/or - * modify it under the terms of the GNU Lesser General Public - * License version 2.1, as published by the Free Software Foundation. + * The Contents of this file are made available subject to + * the terms of GNU Lesser General Public License Version 2.1. * - * This library is distributed in the hope that it will be useful, - * but WITHOUT ANY WARRANTY; without even the implied warranty of - * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU - * Lesser General Public License for more details. * - * You should have received a copy of the GNU Lesser General Public - * License along with this library; if not, write to the Free Software - * Foundation, Inc., 59 Temple Place, Suite 330, Boston, - * MA 02111-1307 USA + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2005 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. * - * Sun Industry Standards Source License Version 1.1 - * ================================================= - * The contents of this file are subject to the Sun Industry Standards - * Source License Version 1.1 (the "License"); You may not use this file - * except in compliance with the License. You may obtain a copy of the - * License at http://www.openoffice.org/license.html. - * - * Software provided under this License is provided on an "AS IS" basis, - * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, - * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, - * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. - * See the License for the specific provisions governing your rights and - * obligations concerning the Software. - * - * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. - * - * Copyright: 2000 by Sun Microsystems, Inc. - * - * All Rights Reserved. - * - * Contributor(s): _______________________________________ + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA * ************************************************************************--> @@ -62,7 +42,7 @@ </topic> <history> <created date="2004-07-06T15:25:35">UFI: new Table Wizard page 3</created> -<lastedited date="2005-11-18T09:50:11">YJ: checked</lastedited> +<lastedited date="2005-03-02T09:26:33">YJ: checked</lastedited> </history> </meta> <body> @@ -73,22 +53,22 @@ <bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_CHK_USEPRIMEKEY" id="bm_id2796411" localize="false"/> <paragraph role="heading" id="par_idN10559" xml-lang="en-US" level="2" l10n="NEW">Create a primary key</paragraph> <paragraph role="paragraph" id="par_idN1055D" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select to create a primary key. Add a primary key to every database table to uniquely identify each record. For some database systems within %PRODUCTNAME, a primary key is mandatory for editing the tables.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_OPT_PK_AUTOMATIC" id="bm_id1500289" localize="false"/> -<paragraph role="heading" id="par_idN10560" xml-lang="en-US" level="3" l10n="NEW">Automatically add a primary key</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_OPT_PK_SINGLE" id="bm_id1240577" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_CK_PK_AUTOVALUE_AUTOMATIC" id="bm_id4537491" localize="false"/> +<paragraph role="heading" id="par_idN10560" xml-lang="en-US" level="3" l10n="NEW">Add a primary key automatically</paragraph> <paragraph role="paragraph" id="par_idN10564" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select to automatically add a primary key as an additional field.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_OPT_PK_SINGLE" id="bm_id9485152.00000001" localize="false"/> -<paragraph role="heading" id="par_idN10567" xml-lang="en-US" level="3" l10n="NEW">Use an existing field as a primary key</paragraph> +<bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_OPT_PK_AUTOMATIC" id="bm_id198370" localize="false"/> +<paragraph role="heading" id="par_idN10567" xml-lang="en-US" level="3" l10n="NEW">Use an existing field as primary key</paragraph> <paragraph role="paragraph" id="par_idN1056B" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select to use an existing field with unique values as a primary key.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_LB_PK_FIELDNAME" id="bm_id6801049" localize="false"/> <paragraph role="heading" id="par_idN1056E" xml-lang="en-US" level="4" l10n="NEW">Field name</paragraph> <paragraph role="paragraph" id="par_idN10572" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select the field name.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_CK_PK_AUTOVALUE" id="bm_id8796349" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_CK_PK_AUTOVALUE_AUTOMATIC" id="bm_id1406292" localize="false"/> <paragraph role="heading" id="par_idN10575" xml-lang="en-US" level="4" l10n="NEW">Auto value</paragraph> <paragraph role="paragraph" id="par_idN10579" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select to automatically insert a value and increment the field's value for each new record. The database must support automatic incrementation in order to use the <emph>Auto value</emph> feature.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_OPT_PK_SEVERAL" id="bm_id130008" localize="false"/> <paragraph role="heading" id="par_idN1057C" xml-lang="en-US" level="3" l10n="NEW">Define primary key by several fields</paragraph> -<paragraph role="paragraph" id="par_idN10580" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select to create a primary key from a combination of several existing fields.</ahelp></paragraph> +<paragraph role="paragraph" id="par_idN10580" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select to create a primary key from a concatenation of several existing fields.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/HID_DLGTABLE_FIELDS_PK_AVAILABLE" id="bm_id2555009" localize="false"/> <paragraph role="heading" id="par_idN10583" xml-lang="en-US" level="4" l10n="NEW">Available fields</paragraph> <paragraph role="paragraph" id="par_idN10587" xml-lang="en-US" l10n="NEW"><ahelp hid=".">Select a field and click > to add it to the list of primary key fields.</ahelp></paragraph> |