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