xref: /AOO41X/main/dbaccess/source/ui/tabledesign/table.src (revision 81d089ae0b6b164818efbaaff21440338527721c)
1/**************************************************************
2 *
3 * Licensed to the Apache Software Foundation (ASF) under one
4 * or more contributor license agreements.  See the NOTICE file
5 * distributed with this work for additional information
6 * regarding copyright ownership.  The ASF licenses this file
7 * to you under the Apache License, Version 2.0 (the
8 * "License"); you may not use this file except in compliance
9 * with the License.  You may obtain a copy of the License at
10 *
11 *   http://www.apache.org/licenses/LICENSE-2.0
12 *
13 * Unless required by applicable law or agreed to in writing,
14 * software distributed under the License is distributed on an
15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16 * KIND, either express or implied.  See the License for the
17 * specific language governing permissions and limitations
18 * under the License.
19 *
20 *************************************************************/
21
22
23
24#ifndef _DBU_TBL_HRC_
25#include "dbu_tbl.hrc"
26#endif
27#ifndef _DBA_DBACCESS_HELPID_HRC_
28#include "dbaccess_helpid.hrc"
29#endif
30#ifndef _DBACCESS_SLOTID_HRC_
31#include "dbaccess_slotid.hrc"
32#endif
33#ifndef DBACCESS_UI_BROWSER_ID_HXX
34#include "browserids.hxx"
35#endif
36#ifndef _GLOBLMN_HRC
37#include <svx/globlmn.hrc>
38#endif
39#ifndef DBAUI_TOOLBOX_HXX
40#include "toolbox.hrc"
41#endif
42
43#define MN_EDIT     20
44#define MN_VIEW     21
45#define MN_EXTRA    22
46#define MN_INDEX    23
47#define MN_WIN      30
48#define MN_HELP     31
49
50String STR_TABLEDESIGN_DBFIELDTYPES
51{
52    Text [ en-US ] = "Unknown;Text;Number;Date/Time;Date;Time;Yes/No;Currency;Memo;Counter;Image;Text (fix);Decimal;Binary (fix);Binary;BigInt;Double;Float;Real;Integer;Small Integer;Tiny Integer;SQL Null;Object;Distinct;Structure;Field;BLOB;CLOB;REF;OTHER;Bit (fix)";
53};
54
55String STR_TABLEDESIGN_UNDO_PRIMKEY
56{
57    Text [ en-US ] = "Insert/remove primary key" ;
58};
59
60String STR_VALUE_YES
61{
62    Text [ en-US ] = "Yes" ;
63};
64String STR_VALUE_NO
65{
66    Text [ en-US ] = "No" ;
67};
68String STR_VALUE_ASC
69{
70    Text [ en-US ] = "Ascending" ;
71};
72String STR_VALUE_DESC
73{
74    Text [ en-US ] = "Descending" ;
75};
76String STR_VALUE_NONE
77{
78    // Bemerkung : sollte auch in anderen Sprachen irgendwie zum Wort 'Wert' passen : Wert - keiner ....
79    Text [ en-US ] = "<none>";
80};
81
82String STR_TAB_FIELD_NAME
83{
84    Text [ en-US ] = "Field name" ;
85};
86String STR_TAB_FIELD_COLUMN_NAME
87{
88    Text [ en-US ] = "Field Name" ;
89};
90String STR_TAB_FIELD_DATATYPE
91{
92    Text [ en-US ] = "Field ~type" ;
93};
94String STR_TAB_FIELD_COLUMN_DATATYPE
95{
96    Text [ en-US ] = "Field Type" ;
97};
98String STR_TAB_FIELD_LENGTH
99{
100    Text [ en-US ] = "Field length" ;
101};
102String STR_TAB_HELP_TEXT
103{
104    Text [ en-US ] = "Description" ;
105};
106String STR_COLUMN_DESCRIPTION
107{
108    Text [ en-US ] = "Column Description" ;
109};
110String STR_TAB_FIELD_NULLABLE
111{
112    Text [ en-US ] = "Input required" ;
113};
114String STR_FIELD_AUTOINCREMENT
115{
116    Text [ en-US ] = "~AutoValue";
117};
118String STR_TAB_PROPERTIES
119{
120    Text [ en-US ] = "Field Properties" ;
121};
122String STR_TABPAGE_GENERAL
123{
124    Text [ en-US ] = "General" ;
125};
126String STR_TAB_TABLE_DESCRIPTION
127{
128    Text [ en-US ] = "Description:";
129};
130
131String STR_TAB_TABLE_PROPERTIES
132{
133    Text [ en-US ] = "Table properties";
134};
135
136Control RID_DB_TAB_EDITOR
137{
138    Pos = MAP_APPFONT ( 0 , 0 ) ;
139    Size = MAP_APPFONT ( 40 , 12 ) ;
140    TabStop = TRUE ;
141    SvLook = TRUE ;
142    Hide = TRUE ;
143    HelpId = HID_TABDESIGN_BACKGROUND ;
144};
145
146ErrorBox ERR_INVALID_LISTBOX_ENTRY
147{
148    Message [ en-US ] = "The text you entered is not a list element. " ;
149};
150
151Menu RID_TABLEDESIGNROWPOPUPMENU
152{
153    ItemList =
154    {
155    MenuItem
156    {
157        ITEM_EDIT_CUT
158    };
159    MenuItem
160    {
161        ITEM_EDIT_COPY
162    };
163    MenuItem
164    {
165        ITEM_EDIT_PASTE
166    };
167    MenuItem
168    {
169        ITEM_EDIT_DELETE
170    };
171    MenuItem
172    {
173        Identifier = SID_TABLEDESIGN_INSERTROWS ;
174        HelpID = HID_TABLEDESIGN_INSERTROWS ;
175        Text [ en-US ] = "Insert Rows" ;
176        };
177    MenuItem
178    {
179        Separator = TRUE ;
180    };
181    MenuItem
182    {
183        Identifier = SID_TABLEDESIGN_TABED_PRIMARYKEY ;
184        HelpID = HID_TABLEDESIGN_TABED_PRIMARYKEY ;
185        Checkable = TRUE ;
186        Text [ en-US ] = "Primary Key" ;
187        };
188    };
189};
190String STR_TABED_UNDO_CELLMODIFIED
191{
192    Text [ en-US ] = "Modify cell" ;
193};
194String STR_TABED_UNDO_ROWDELETED
195{
196    Text [ en-US ] = "Delete row" ;
197};
198String STR_TABED_UNDO_TYPE_CHANGED
199{
200    Text [ en-US ] = "Modify field type";
201};
202String STR_TABED_UNDO_ROWINSERTED
203{
204    Text [ en-US ] = "Insert row" ;
205};
206String STR_TABED_UNDO_NEWROWINSERTED
207{
208    Text [ en-US ] = "Insert new row" ;
209};
210String STR_TABED_UNDO_PRIMKEY
211{
212    Text [ en-US ] = "Insert/remove primary key" ;
213};
214
215String STR_DEFAULT_VALUE
216{
217    Text [ en-US ] = "~Default value" ;
218};
219String STR_FIELD_REQUIRED
220{
221    Text [ en-US ] = "~Entry required" ;
222};
223String STR_TEXT_LENGTH
224{
225    Text [ en-US ] = "~Length" ;
226};
227String STR_NUMERIC_TYPE
228{
229    Text [ en-US ] = "~Type" ;
230};
231String STR_LENGTH
232{
233    Text [ en-US ] = "~Length" ;
234};
235String STR_SCALE
236{
237    Text [ en-US ] = "Decimal ~places" ;
238};
239String STR_FORMAT
240{
241    Text [ en-US ] = "Format example";
242};
243String STR_HELP_BOOL_DEFAULT
244{
245    Text [ en-US ] = "Select a value that is to appear in all new records as default.\nIf the field is not to have a default value, select the empty string.";
246};
247String STR_HELP_DEFAULT_VALUE
248{
249    Text [ en-US ] = "Enter a default value for this field.\n\nWhen you later enter data in the table, this string will be used in each new record for the field selected. It should, therefore, correspond to the cell format that needs to be entered below." ;
250};
251String STR_HELP_FIELD_REQUIRED
252{
253    Text [ en-US ] = "Activate this option if this field cannot contain NULL values, i.e. the user must always enter data." ;
254};
255String STR_HELP_TEXT_LENGTH
256{
257    Text [ en-US ] = "Enter the maximum text length permitted." ;
258};
259String STR_HELP_NUMERIC_TYPE
260{
261    Text [ en-US ] = "Enter the number format." ;
262};
263String STR_HELP_LENGTH
264{
265    Text [ en-US ] = "Determine the length data can have in this field.\n\nIf decimal fields, then the maximum length of the number to be entered, if binary fields, then the length of the data block.\nThe value will be corrected accordingly when it exceeds the maximum for this database." ;
266};
267String STR_HELP_SCALE
268{
269    Text [ en-US ] = "Specify the number of decimal places permitted in this field." ;
270};
271String STR_HELP_FORMAT_CODE
272{
273    Text [ en-US ] = "This is where you see how the data would be displayed in the current format (use the button on the right to modify the format).";
274};
275String STR_HELP_FORMAT_BUTTON
276{
277    Text [ en-US ] = "This is where you determine the output format of the data.";
278};
279String STR_HELP_AUTOINCREMENT
280{
281    Text [ en-US ] = "Choose if this field should contain AutoIncrement values.\n\nYou can not enter data in fields of this type. An intrinsic value will be assigned to each new record automatically (resulting from the increment of the previous record)." ;
282};
283PushButton PB_FORMAT
284{
285    TabStop = TRUE ;
286    Text [ en-US ] = "~...";
287};
288String STR_TABLEDESIGN_DUPLICATE_NAME
289{
290    Text [ en-US ] = "The table cannot be saved because column name \"$column$\" was assigned twice.";
291};
292String STR_TBL_COLUMN_IS_KEYCOLUMN
293{
294    Text [ en-US ] = "The column \"$column$\" belongs to the primary key. If the column is deleted, the primary key will also be deleted. Do you really want to continue?";
295};
296String STR_TBL_COLUMN_IS_KEYCOLUMN_TITLE
297{
298    Text [ en-US ] = "Primary Key Affected";
299};
300String STR_COLUMN_NAME
301{
302    Text [ en-US ] = "Column";
303};
304String STR_QRY_CONTINUE
305{
306    Text [ en-US ] = "Continue anyway?" ;
307};
308String STR_STAT_WARNING
309{
310    Text [ en-US ] = "Warning!" ;
311};
312QueryBox TABLE_DESIGN_SAVEMODIFIED
313{
314    Buttons = WB_YES_NO_CANCEL ;
315    DefButton = WB_DEF_YES ;
316    Message [ en-US ] = "The table has been changed.\nDo you want to save the changes?" ;
317};
318QueryBox TABLE_QUERY_CONNECTION_LOST
319{
320    Buttons = WB_YES_NO ;
321    Message [ en-US ] = "The connection to the database was lost! The table design can only be used with limited functionality without a connection.\nReconnect?" ;
322};
323String STR_TABLEDESIGN_CONNECTION_MISSING
324{
325    Text [ en-US ] = "The table could not be saved due to problems connecting to the database.";
326};
327String STR_TABLEDESIGN_DATASOURCE_DELETED
328{
329    Text [ en-US ] = "The table filter could not be adjusted because the data source has been deleted.";
330};
331
332QueryBox QUERY_SAVE_TABLE_EDIT_INDEXES
333{
334    Message [ en-US ] = "Before you can edit the indexes of a table, you have to save it.\nDo you want to save the changes now?";
335
336    Buttons = WB_YES_NO ;
337};
338String STR_TABLEDESIGN_NO_PRIM_KEY_HEAD
339{
340    Text [ en-US ] = "No primary key" ;
341};
342String STR_TABLEDESIGN_NO_PRIM_KEY
343{
344    Text [ en-US ] = "A unique index or primary key is required for data record identification in this database.\nYou can only enter data into this table when one of these two structural conditions has been met.\n\nShould a primary key be created now?" ;
345};
346String STR_TABLEDESIGN_TITLE
347{
348    Text [ en-US ] = " - %PRODUCTNAME Base: Table Design";
349};
350
351/*
352  The menubar resource has become obsolete - you can now find the menubar definition at: <project>/uiconfig/dbtable/menubar/menubar.xml
353*/
354
355String STR_TABLEDESIGN_ALTER_ERROR
356{
357    Text [ en-US ] = "The column \"$column$\" could not be changed. Should the column instead be deleted and the new format appended?" ;
358};
359
360String STR_TABLEDESIGN_SAVE_ERROR
361{
362    Text [ en-US ] = "Error while saving the table design";
363};
364
365String STR_TABLEDESIGN_COULD_NOT_DROP_COL
366{
367    Text [ en-US ] = "The column $column$ could not be deleted.";
368};
369
370QueryBox TABLE_DESIGN_ALL_ROWS_DELETED
371{
372    Buttons = WB_YES_NO_CANCEL ;
373    DefButton = WB_DEF_YES ;
374    Message [ en-US ] = "You are trying to delete all the columns in the table. A table cannot exist without columns. Should the table be deleted from the database? If not, the table will remain unchanged.";
375};
376
377String STR_AUTOINCREMENT_VALUE
378{
379    Text [ en-US ] = "A~uto-increment statement";
380};
381String STR_HELP_AUTOINCREMENT_VALUE
382{
383    Text [ en-US ] = "Enter an SQL statement for the auto-increment field.\n\nThis statement will be directly transferred to the database when the table is created.";
384};
385
386String STR_NO_TYPE_INFO_AVAILABLE
387{
388    Text [ en-US ] = "No type information could be retrieved from the database.\nThe table design mode is not available for this data source.";
389};
390
391String STR_CHANGE_COLUMN_NAME
392{
393    Text [ en-US ] = "change field name";
394};
395
396String STR_CHANGE_COLUMN_TYPE
397{
398    Text [ en-US ] = "change field type";
399};
400
401String STR_CHANGE_COLUMN_DESCRIPTION
402{
403    Text [ en-US ] = "change field description";
404};
405
406String STR_CHANGE_COLUMN_ATTRIBUTE
407{
408    Text [ en-US ] = "change field attribute";
409};
410