1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
|
<?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
*
* - GNU Lesser General Public License Version 2.1
* - Sun Industry Standards Source License Version 1.1
*
* Sun Microsystems Inc., October, 2000
*
* GNU Lesser General Public License Version 2.1
* =============================================
* Copyright 2000 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.
*
* 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
*
*
* 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): _______________________________________
*
*
************************************************************************-->
<helpdocument version="1.0">
<meta>
<topic id="textsharedexplorerdatabase05010000xml" indexer="exclude" status="PUBLISH">
<title id="tit" xml-lang="en-US">Table Design</title>
<filename>/text/shared/explorer/database/05010000.xhp</filename>
</topic>
<history>
<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
<lastedited date="2006-01-17T14:54:32">converted from old format - fpe</lastedited>
</history>
</meta>
<body>
<section id="tabellenentwurf">
<paragraph role="heading" id="hd_id3154228" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/shared/explorer/database/05010000.xhp" name="Table Design">Table Design</link></paragraph>
<paragraph role="paragraph" id="par_id3152363" xml-lang="en-US" l10n="U" oldref="2">In the <emph>Table Design</emph> window you define new tables or edit the structure of a table.</paragraph>
</section>
<paragraph role="paragraph" id="par_id3156136" xml-lang="en-US" l10n="E" localize="false"><link href="text/shared/00/00000450.xhp#tabellenentwurf"><embedvar href="text/shared/00/00000004.xhp#wie"/></link></paragraph>
<embed href="text/shared/guide/database_main.xhp#database_main"/>
<embed href="text/shared/guide/data_tabledefine.xhp#data_tabledefine"/>
<paragraph role="paragraph" id="par_id3146957" xml-lang="en-US" l10n="U" oldref="3">The window has its own menu bar. It also contains the following new command: <link href="text/shared/explorer/database/05010100.xhp" name="Index Design"><emph>Index Design</emph></link></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_TABDESIGN_BACKGROUND" id="bm_id3147088" localize="false"/>
<paragraph role="heading" id="hd_id3152551" xml-lang="en-US" level="2" l10n="U" oldref="4">Table definition area</paragraph>
<paragraph role="paragraph" id="par_id3153681" xml-lang="en-US" l10n="U" oldref="5"><ahelp hid="HID_TABDESIGN_BACKGROUND">This area is where you define the table structure.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_TABDESIGN_NAMECELL" id="bm_id3145382" localize="false"/>
<paragraph role="heading" id="hd_id3153031" xml-lang="en-US" level="3" l10n="U" oldref="6">Field Name</paragraph>
<paragraph role="paragraph" id="par_id3156113" xml-lang="en-US" l10n="U" oldref="7"><ahelp hid="HID_TABDESIGN_NAMECELL">Specifies the name of the data field. Note the database restrictions, such as the length of the name, special characters and spaces.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_TABDESIGN_TYPECELL" id="bm_id3148473" localize="false"/>
<paragraph role="heading" id="hd_id3147618" xml-lang="en-US" level="3" l10n="U" oldref="8">Field type</paragraph>
<paragraph role="paragraph" id="par_id3154897" xml-lang="en-US" l10n="U" oldref="9"><ahelp hid="HID_TABDESIGN_TYPECELL">Specifies the field type.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_TABDESIGN_COMMENTCELL" id="bm_id3149233" localize="false"/>
<paragraph role="heading" id="hd_id3156119" xml-lang="en-US" level="3" l10n="U" oldref="10">Description</paragraph>
<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="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="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="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>
<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>
<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>
<paragraph role="heading" id="hd_id3153104" xml-lang="en-US" level="2" l10n="U" oldref="25">Field properties</paragraph>
<paragraph role="paragraph" id="par_id3148922" xml-lang="en-US" l10n="U" oldref="26">Defines the field properties of the currently selected field.</paragraph>
<paragraph role="heading" id="hd_id3150767" xml-lang="en-US" level="3" l10n="U" oldref="27">Length</paragraph>
<paragraph role="paragraph" id="par_id3144761" xml-lang="en-US" l10n="U" oldref="28">Specifies the length of the data field.</paragraph>
<paragraph role="heading" id="hd_id3154948" xml-lang="en-US" level="3" l10n="U" oldref="29">Decimal places</paragraph>
<paragraph role="paragraph" id="par_id3149203" xml-lang="en-US" l10n="U" oldref="30">Specifies the number of decimal places for a numerical field or decimal field.</paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_DEFAULT" id="bm_id3158410" localize="false"/>
<paragraph role="heading" id="hd_id3156422" xml-lang="en-US" level="3" l10n="U" oldref="31">Default value</paragraph>
<paragraph role="paragraph" id="par_id3125863" xml-lang="en-US" l10n="U" oldref="32"><ahelp hid="HID_TAB_ENT_DEFAULT">Specifies the value that is the default in new data records.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_FORMAT_SAMPLE" id="bm_id3149562" localize="false"/>
<paragraph role="heading" id="hd_id3147289" xml-lang="en-US" level="3" l10n="U" oldref="33">Format example</paragraph>
<paragraph role="paragraph" id="par_id3155131" xml-lang="en-US" l10n="U" oldref="34"><ahelp hid="HID_TAB_ENT_FORMAT_SAMPLE">Displays the format code that you can select with the<emph> ... </emph>button.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_TAB_ENT_FORMAT" id="bm_id3147319" localize="false"/>
<paragraph role="heading" id="hd_id3154129" xml-lang="en-US" level="3" l10n="U" oldref="35">...</paragraph>
<paragraph role="paragraph" id="par_id3154146" xml-lang="en-US" l10n="U" oldref="36"><ahelp hid="HID_TAB_ENT_FORMAT">This button opens the <link href="text/shared/01/05340405.xhp" name="Field Format"><emph>Field Format</emph></link> dialog.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/HID_TABLE_DESIGN_HELP_WINDOW" id="bm_id3152941" localize="false"/>
<paragraph role="heading" id="hd_id3152576" xml-lang="en-US" level="2" l10n="U" oldref="37">Help area</paragraph>
<paragraph role="paragraph" id="par_id3150685" xml-lang="en-US" l10n="U" oldref="38"><ahelp hid="HID_TABLE_DESIGN_HELP_WINDOW">Displays help texts.</ahelp></paragraph>
</body>
</helpdocument>
|
