1/*************************************************************************
2 *
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4 *
5 * Copyright 2000, 2010 Oracle and/or its affiliates.
6 *
7 * OpenOffice.org - a multi-platform office productivity suite
8 *
9 * This file is part of OpenOffice.org.
10 *
11 * OpenOffice.org is free software: you can redistribute it and/or modify
12 * it under the terms of the GNU Lesser General Public License version 3
13 * only, as published by the Free Software Foundation.
14 *
15 * OpenOffice.org is distributed in the hope that it will be useful,
16 * but WITHOUT ANY WARRANTY; without even the implied warranty of
17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18 * GNU Lesser General Public License version 3 for more details
19 * (a copy is included in the LICENSE file that accompanied this code).
20 *
21 * You should have received a copy of the GNU Lesser General Public License
22 * version 3 along with OpenOffice.org.  If not, see
23 * <http://www.openoffice.org/license.html>
24 * for a copy of the LGPLv3 License.
25 *
26 ************************************************************************/
27
28#ifndef _DBU_TBL_HRC_
29#include "dbu_tbl.hrc"
30#endif
31#ifndef _DBA_DBACCESS_HELPID_HRC_
32#include "dbaccess_helpid.hrc"
33#endif
34#ifndef _DBACCESS_SLOTID_HRC_
35#include "dbaccess_slotid.hrc"
36#endif
37#ifndef DBACCESS_UI_BROWSER_ID_HXX
38#include "browserids.hxx"
39#endif
40#ifndef _GLOBLMN_HRC
41#include <svx/globlmn.hrc>
42#endif
43#ifndef DBAUI_TOOLBOX_HXX
44#include "toolbox.hrc"
45#endif
46
47#define MN_EDIT		20
48#define MN_VIEW		21
49#define MN_EXTRA	22
50#define MN_INDEX	23
51#define MN_WIN		30
52#define MN_HELP		31
53
54String STR_TABLEDESIGN_DBFIELDTYPES
55{
56	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)";
57};
58
59String STR_TABLEDESIGN_UNDO_PRIMKEY
60{
61	Text [ en-US ] = "Insert/remove primary key" ;
62};
63
64String STR_VALUE_YES
65{
66	Text [ en-US ] = "Yes" ;
67};
68String STR_VALUE_NO
69{
70	Text [ en-US ] = "No" ;
71};
72String STR_VALUE_ASC
73{
74	Text [ en-US ] = "Ascending" ;
75};
76String STR_VALUE_DESC
77{
78	Text [ en-US ] = "Descending" ;
79};
80String STR_VALUE_NONE
81{
82	// Bemerkung : sollte auch in anderen Sprachen irgendwie zum Wort 'Wert' passen : Wert - keiner ....
83	Text [ en-US ] = "<none>";
84};
85
86String STR_TAB_FIELD_NAME
87{
88	Text [ en-US ] = "Field name" ;
89};
90String STR_TAB_FIELD_COLUMN_NAME
91{
92	Text [ en-US ] = "Field Name" ;
93};
94String STR_TAB_FIELD_DATATYPE
95{
96	Text [ en-US ] = "Field ~type" ;
97};
98String STR_TAB_FIELD_COLUMN_DATATYPE
99{
100	Text [ en-US ] = "Field Type" ;
101};
102String STR_TAB_FIELD_LENGTH
103{
104	Text [ en-US ] = "Field length" ;
105};
106String STR_TAB_HELP_TEXT
107{
108	Text [ en-US ] = "Description" ;
109};
110String STR_COLUMN_DESCRIPTION
111{
112	Text [ en-US ] = "Column Description" ;
113};
114String STR_TAB_FIELD_NULLABLE
115{
116	Text [ en-US ] = "Input required" ;
117};
118String STR_FIELD_AUTOINCREMENT
119{
120	Text [ en-US ] = "~AutoValue";
121};
122String STR_TAB_PROPERTIES
123{
124	Text [ en-US ] = "Field Properties" ;
125};
126String STR_TABPAGE_GENERAL
127{
128	Text [ en-US ] = "General" ;
129};
130String STR_TAB_TABLE_DESCRIPTION
131{
132	Text [ en-US ] = "Description:";
133};
134
135String STR_TAB_TABLE_PROPERTIES
136{
137	Text [ en-US ] = "Table properties";
138};
139
140Control RID_DB_TAB_EDITOR
141{
142	Pos = MAP_APPFONT ( 0 , 0 ) ;
143	Size = MAP_APPFONT ( 40 , 12 ) ;
144	TabStop = TRUE ;
145	SvLook = TRUE ;
146	Hide = TRUE ;
147	HelpId = HID_TABDESIGN_BACKGROUND ;
148};
149
150ErrorBox ERR_INVALID_LISTBOX_ENTRY
151{
152	Message [ en-US ] = "The text you entered is not a list element. " ;
153};
154
155Menu RID_TABLEDESIGNROWPOPUPMENU
156{
157	ItemList =
158	{
159	MenuItem
160	{
161		ITEM_EDIT_CUT
162	};
163	MenuItem
164	{
165		ITEM_EDIT_COPY
166	};
167	MenuItem
168	{
169		ITEM_EDIT_PASTE
170	};
171	MenuItem
172	{
173		ITEM_EDIT_DELETE
174	};
175	MenuItem
176	{
177		Identifier = SID_TABLEDESIGN_INSERTROWS ;
178		HelpID = HID_TABLEDESIGN_INSERTROWS ;
179		Text [ en-US ] = "Insert Rows" ;
180		};
181	MenuItem
182	{
183		Separator = TRUE ;
184	};
185	MenuItem
186	{
187		Identifier = SID_TABLEDESIGN_TABED_PRIMARYKEY ;
188		HelpID = HID_TABLEDESIGN_TABED_PRIMARYKEY ;
189		Checkable = TRUE ;
190		Text [ en-US ] = "Primary Key" ;
191		};
192	};
193};
194String STR_TABED_UNDO_CELLMODIFIED
195{
196	Text [ en-US ] = "Modify cell" ;
197};
198String STR_TABED_UNDO_ROWDELETED
199{
200	Text [ en-US ] = "Delete row" ;
201};
202String STR_TABED_UNDO_TYPE_CHANGED
203{
204	Text [ en-US ] = "Modify field type";
205};
206String STR_TABED_UNDO_ROWINSERTED
207{
208	Text [ en-US ] = "Insert row" ;
209};
210String STR_TABED_UNDO_NEWROWINSERTED
211{
212	Text [ en-US ] = "Insert new row" ;
213};
214String STR_TABED_UNDO_PRIMKEY
215{
216	Text [ en-US ] = "Insert/remove primary key" ;
217};
218
219String STR_DEFAULT_VALUE
220{
221	Text [ en-US ] = "~Default value" ;
222};
223String STR_FIELD_REQUIRED
224{
225	Text [ en-US ] = "~Entry required" ;
226};
227String STR_TEXT_LENGTH
228{
229	Text [ en-US ] = "~Length" ;
230};
231String STR_NUMERIC_TYPE
232{
233	Text [ en-US ] = "~Type" ;
234};
235String STR_LENGTH
236{
237	Text [ en-US ] = "~Length" ;
238};
239String STR_SCALE
240{
241	Text [ en-US ] = "Decimal ~places" ;
242};
243String STR_FORMAT
244{
245	Text [ en-US ] = "Format example";
246};
247String STR_HELP_BOOL_DEFAULT
248{
249	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.";
250};
251String STR_HELP_DEFAULT_VALUE
252{
253	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." ;
254};
255String STR_HELP_FIELD_REQUIRED
256{
257	Text [ en-US ] = "Activate this option if this field cannot contain NULL values, i.e. the user must always enter data." ;
258};
259String STR_HELP_TEXT_LENGTH
260{
261	Text [ en-US ] = "Enter the maximum text length permitted." ;
262};
263String STR_HELP_NUMERIC_TYPE
264{
265	Text [ en-US ] = "Enter the number format." ;
266};
267String STR_HELP_LENGTH
268{
269	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." ;
270};
271String STR_HELP_SCALE
272{
273	Text [ en-US ] = "Specify the number of decimal places permitted in this field." ;
274};
275String STR_HELP_FORMAT_CODE
276{
277	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).";
278};
279String STR_HELP_FORMAT_BUTTON
280{
281	Text [ en-US ] = "This is where you determine the output format of the data.";
282};
283String STR_HELP_AUTOINCREMENT
284{
285	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)." ;
286};
287PushButton PB_FORMAT
288{
289	TabStop = TRUE ;
290	Text [ en-US ] = "~...";
291};
292String STR_TABLEDESIGN_DUPLICATE_NAME
293{
294	Text [ en-US ] = "The table cannot be saved because column name \"$column$\" was assigned twice.";
295};
296String STR_TBL_COLUMN_IS_KEYCOLUMN
297{
298	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?";
299};
300String STR_TBL_COLUMN_IS_KEYCOLUMN_TITLE
301{
302	Text [ en-US ] = "Primary Key Affected";
303};
304String STR_COLUMN_NAME
305{
306	Text [ en-US ] = "Column";
307};
308String STR_QRY_CONTINUE
309{
310	Text [ en-US ] = "Continue anyway?" ;
311};
312String STR_STAT_WARNING
313{
314	Text [ en-US ] = "Warning!" ;
315};
316QueryBox TABLE_DESIGN_SAVEMODIFIED
317{
318	Buttons = WB_YES_NO_CANCEL ;
319	DefButton = WB_DEF_YES ;
320	Message [ en-US ] = "The table has been changed.\nDo you want to save the changes?" ;
321};
322QueryBox TABLE_QUERY_CONNECTION_LOST
323{
324	Buttons = WB_YES_NO ;
325	Message [ en-US ] = "The connection to the database was lost! The table design can only be used with limited functionality without a connection.\nReconnect?" ;
326};
327String STR_TABLEDESIGN_CONNECTION_MISSING
328{
329	Text [ en-US ] = "The table could not be saved due to problems connecting to the database.";
330};
331String STR_TABLEDESIGN_DATASOURCE_DELETED
332{
333	Text [ en-US ] = "The table filter could not be adjusted because the data source has been deleted.";
334};
335
336QueryBox QUERY_SAVE_TABLE_EDIT_INDEXES
337{
338	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?";
339
340	Buttons = WB_YES_NO ;
341};
342String STR_TABLEDESIGN_NO_PRIM_KEY_HEAD
343{
344	Text [ en-US ] = "No primary key" ;
345};
346String STR_TABLEDESIGN_NO_PRIM_KEY
347{
348	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?" ;
349};
350String STR_TABLEDESIGN_TITLE
351{
352	Text [ en-US ] = " - %PRODUCTNAME Base: Table Design";
353};
354
355/*
356  The menubar resource has become obsolete - you can now find the menubar definition at: <project>/uiconfig/dbtable/menubar/menubar.xml
357*/
358
359String STR_TABLEDESIGN_ALTER_ERROR
360{
361	Text [ en-US ] = "The column \"$column$\" could not be changed. Should the column instead be deleted and the new format appended?" ;
362};
363
364String STR_TABLEDESIGN_SAVE_ERROR
365{
366    Text [ en-US ] = "Error while saving the table design";
367};
368
369String STR_TABLEDESIGN_COULD_NOT_DROP_COL
370{
371    Text [ en-US ] = "The column $column$ could not be deleted.";
372};
373
374QueryBox TABLE_DESIGN_ALL_ROWS_DELETED
375{
376	Buttons = WB_YES_NO_CANCEL ;
377	DefButton = WB_DEF_YES ;
378	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.";
379};
380
381String STR_AUTOINCREMENT_VALUE
382{
383	Text [ en-US ] = "A~uto-increment statement";
384};
385String STR_HELP_AUTOINCREMENT_VALUE
386{
387	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.";
388};
389
390String STR_NO_TYPE_INFO_AVAILABLE
391{
392	Text [ en-US ] = "No type information could be retrieved from the database.\nThe table design mode is not available for this data source.";
393};
394
395String STR_CHANGE_COLUMN_NAME
396{
397    Text [ en-US ] = "change field name";
398};
399
400String STR_CHANGE_COLUMN_TYPE
401{
402    Text [ en-US ] = "change field type";
403};
404
405String STR_CHANGE_COLUMN_DESCRIPTION
406{
407    Text [ en-US ] = "change field description";
408};
409
410String STR_CHANGE_COLUMN_ATTRIBUTE
411{
412    Text [ en-US ] = "change field attribute";
413};
414