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 DBAUI_WIZARD_PAGES_HRC
29#include "WizardPages.hrc"
30#endif
31#ifndef _DBU_MISC_HRC_
32#include "dbu_misc.hrc"
33#endif
34#ifndef _DBA_DBACCESS_HELPID_HRC_
35#include "dbaccess_helpid.hrc"
36#endif
37
38#include "dbaccess_slotid.hrc"
39
40#define WINDOW_SIZE_X   276
41#define WINDOW_SIZE_Y	185
42
43#define WINDOW_BORDER_X	 12
44#define WINDOW_BORDER_Y	 14
45
46#define BUTTON_SIZE_X	 50
47#define BUTTON_SIZE_Y	 14
48
49String STR_WIZ_COLUMN_SELECT_TITEL
50{
51	Text [ en-US ] = "Apply columns";
52};
53
54String STR_WIZ_TYPE_SELECT_TITEL
55{
56	Text [ en-US ] = "Type formatting";
57};
58
59String STR_WIZ_PKEY_ALREADY_DEFINED
60{
61	Text [ en-US ] = "The following fields have already been set as primary keys:\n";
62};
63
64String STR_WIZ_NAME_MATCHING_TITEL
65{
66	Text [ en-US ]	= "Assign columns" ;
67};
68
69ModalDialog WIZ_RTFCOPYTABLE
70{
71    HelpID = "dbaccess:ModalDialog:WIZ_RTFCOPYTABLE";
72
73	Text [ en-US ] = "Copy RTF Table" ;
74
75
76	OutputSize		= TRUE ;
77	SVLook			= TRUE ;
78	Moveable		= TRUE ;
79	Closeable		= TRUE ;
80	Hide			= TRUE;
81
82    HelpButton PB_HELP
83	{
84		TabStop				= TRUE ;
85		Size				= MAP_APPFONT ( BUTTON_SIZE_X , BUTTON_SIZE_Y ) ;
86		Text [ en-US ] = "~Help";
87	};
88	CancelButton PB_CANCEL
89	{
90		TabStop				= TRUE ;
91		Size				= MAP_APPFONT ( BUTTON_SIZE_X , BUTTON_SIZE_Y ) ;
92		Text [ en-US ] = "~Cancel";
93	};
94	PushButton PB_PREV
95	{
96	    HelpID = "dbaccess:PushButton:WIZ_RTFCOPYTABLE:PB_PREV";
97		TabStop				= TRUE ;
98		Size				= MAP_APPFONT ( BUTTON_SIZE_X , BUTTON_SIZE_Y ) ;
99		Text [ en-US ] = "< ~Back";
100	};
101	PushButton PB_NEXT
102	{
103	    HelpID = "dbaccess:PushButton:WIZ_RTFCOPYTABLE:PB_NEXT";
104		TabStop				= TRUE ;
105		Size				= MAP_APPFONT ( BUTTON_SIZE_X , BUTTON_SIZE_Y ) ;
106		Text [ en-US ] = "~Next>";
107	};
108	OKButton PB_OK
109	{
110		TabStop				= TRUE ;
111		Size				= MAP_APPFONT ( BUTTON_SIZE_X , BUTTON_SIZE_Y ) ;
112		Text [ en-US ] = "C~reate";
113	};
114
115};
116
117//==================================================================
118 // TAB_WIZ_COLUMN_SELECT
119 //==================================================================
120TabPage TAB_WIZ_COLUMN_SELECT
121{
122	SVLook	= TRUE ;
123	Size	= MAP_APPFONT ( WINDOW_SIZE_X , WINDOW_SIZE_Y ) ;
124
125	HelpId	= HID_TAB_WIZ_COLUMN_SELECT;
126	Hide	= TRUE;
127
128    FixedLine FL_COLUMN_SELECT
129	{
130		Pos					= MAP_APPFONT ( 6 , 3  ) ;
131        Size                = MAP_APPFONT ( WINDOW_SIZE_X - 12 , 8 ) ;
132		Text [ en-US ] = "Existing columns" ;
133	};
134
135	MultiListBox LB_ORG_COLUMN_NAMES
136	{
137	    HelpID = "dbaccess:MultiListBox:TAB_WIZ_COLUMN_SELECT:LB_ORG_COLUMN_NAMES";
138		Border				= TRUE ;
139		Pos					= MAP_APPFONT ( WINDOW_BORDER_X , WINDOW_BORDER_Y ) ;
140        Size                = MAP_APPFONT ( 95 , WINDOW_SIZE_Y - 23 ) ;
141		TabStop				= TRUE ;
142		HScroll             = TRUE;
143		VScroll             = TRUE;
144		AutoHScroll			= TRUE;
145		SimpleMode			= TRUE;
146		Sort				= FALSE;
147	};
148    ImageButton IB_COLUMN_RH
149	{
150        HelpID = "dbaccess:ImageButton:TAB_WIZ_COLUMN_SELECT:IB_COLUMN_RH";
151        Pos                 = MAP_APPFONT ( WINDOW_BORDER_X + 116 , WINDOW_BORDER_Y + 25 ) ;
152		Size				= MAP_APPFONT ( 20 , 14 ) ;
153		TabStop				= TRUE ;
154		ButtonImage = Image
155		{
156			ImageBitmap = Bitmap
157			{
158                File = "one_right.bmp" ;
159			};
160			MaskColor = Color
161			{
162				Red   = 0xFFFF;
163				Green = 0x0000;
164				Blue  = 0xFFFF;
165			};
166		};
167	};
168    ImageButton IB_COLUMNS_RH
169	{
170        HelpID = "dbaccess:ImageButton:TAB_WIZ_COLUMN_SELECT:IB_COLUMNS_RH";
171        Pos                 = MAP_APPFONT ( WINDOW_BORDER_X + 116 , WINDOW_BORDER_Y + 45 ) ;
172		Size				= MAP_APPFONT ( 20 , 14 ) ;
173		TabStop				= TRUE;
174		DefButton           = TRUE;
175		ButtonImage = Image
176		{
177			ImageBitmap = Bitmap
178			{
179                File = "all_right.bmp" ;
180			};
181			MaskColor = Color
182			{
183				Red   = 0xFFFF;
184				Green = 0x0000;
185				Blue  = 0xFFFF;
186			};
187		};
188	};
189    ImageButton IB_COLUMN_LH
190	{
191        HelpID = "dbaccess:ImageButton:TAB_WIZ_COLUMN_SELECT:IB_COLUMN_LH";
192        Pos                 = MAP_APPFONT ( WINDOW_BORDER_X + 116 , WINDOW_BORDER_Y + 65) ;
193		Size				= MAP_APPFONT ( 20 , 14 ) ;
194		TabStop				= TRUE ;
195		ButtonImage = Image
196		{
197			ImageBitmap = Bitmap
198			{
199                File = "one_left.bmp" ;
200			};
201			MaskColor = Color
202			{
203				Red   = 0xFFFF;
204				Green = 0x0000;
205				Blue  = 0xFFFF;
206			};
207		};
208	};
209    ImageButton IB_COLUMNS_LH
210	{
211        HelpID = "dbaccess:ImageButton:TAB_WIZ_COLUMN_SELECT:IB_COLUMNS_LH";
212        Pos                 = MAP_APPFONT ( WINDOW_BORDER_X + 116 , WINDOW_BORDER_Y + 85) ;
213		Size				= MAP_APPFONT ( 20 , 14 ) ;
214		TabStop				= TRUE ;
215		ButtonImage = Image
216		{
217			ImageBitmap = Bitmap
218			{
219                File = "all_left.bmp" ;
220			};
221			MaskColor = Color
222			{
223				Red   = 0xFFFF;
224				Green = 0x0000;
225				Blue  = 0xFFFF;
226			};
227		};
228	};
229
230	MultiListBox LB_NEW_COLUMN_NAMES
231	{
232	    HelpID = "dbaccess:MultiListBox:TAB_WIZ_COLUMN_SELECT:LB_NEW_COLUMN_NAMES";
233		Border				= TRUE ;
234        Pos                 = MAP_APPFONT ( WINDOW_BORDER_X + 157, WINDOW_BORDER_Y) ;
235        Size                = MAP_APPFONT ( 95 , WINDOW_SIZE_Y - 23 ) ;
236		TabStop				= TRUE ;
237		HScroll             = TRUE;
238		VScroll             = TRUE;
239		AutoHScroll			= TRUE;
240		SimpleMode			= TRUE;
241		Sort				= FALSE;
242	};
243};
244
245//==================================================================
246 // TAB_WIZ_TYPE_SELECT
247 //==================================================================
248TabPage TAB_WIZ_TYPE_SELECT
249{
250	SVLook	= TRUE ;
251	Size	= MAP_APPFONT ( WINDOW_SIZE_X , WINDOW_SIZE_Y ) ;
252
253	HelpId	= HID_TAB_WIZ_TYPE_SELECT;
254	Hide	= TRUE;
255
256	MultiListBox LB_NEW_COLUMN_NAMES
257	{
258	    HelpID = "dbaccess:MultiListBox:TAB_WIZ_TYPE_SELECT:LB_NEW_COLUMN_NAMES";
259		Border				= TRUE ;
260		Pos					= MAP_APPFONT ( 6 , 6 ) ;
261		Size				= MAP_APPFONT ( 87 , WINDOW_SIZE_Y - 12 ) ;
262		TabStop				= TRUE ;
263		HScroll             = TRUE;
264		VScroll             = TRUE;
265		AutoHScroll			= TRUE;
266		SimpleMode			= TRUE;
267	};
268
269    FixedLine FL_COLUMN_NAME
270	{
271		Pos					= MAP_APPFONT ( 99 , 3  ) ;
272        Size                = MAP_APPFONT ( WINDOW_SIZE_X -  105, 8 ) ;
273		Text [ en-US ] = "Column information" ;
274	};
275
276	TabPage CONTROL_CONTAINER
277	{
278	    HelpID = "dbaccess:TabPage:CONTROL_CONTAINER";
279		Pos					= MAP_APPFONT ( 102 , WINDOW_BORDER_Y  ) ;
280		Size				= MAP_APPFONT ( WINDOW_SIZE_X -  111, WINDOW_SIZE_Y - WINDOW_BORDER_Y - 67 );
281		SVLook              = TRUE;
282		DialogControl       = TRUE;
283	};
284
285    FixedLine FL_AUTO_TYPE
286	{
287		Pos					= MAP_APPFONT ( 99 , WINDOW_SIZE_Y - WINDOW_BORDER_Y - 41  ) ;
288        Size                = MAP_APPFONT ( WINDOW_SIZE_X - 105, 8 ) ;
289		Text [ en-US ] = "Automatic type recognition" ;
290	};
291
292	FixedText FT_AUTO
293	{
294        Pos                 = MAP_APPFONT ( 105 , WINDOW_SIZE_Y - WINDOW_BORDER_Y - 28 ) ;
295        Size                = MAP_APPFONT ( 40 , 8 ) ;
296		Text [ en-US ] = "Lines (ma~x)";
297	};
298
299	NumericField ET_AUTO
300	{
301	    HelpID = "dbaccess:NumericField:TAB_WIZ_TYPE_SELECT:ET_AUTO";
302		Border				= TRUE ;
303        Pos                 = MAP_APPFONT ( 151 , WINDOW_SIZE_Y - WINDOW_BORDER_Y - 29) ;
304		Size				= MAP_APPFONT ( 40 , 12 ) ;
305		TabStop				= TRUE ;
306	};
307
308	PushButton PB_AUTO
309	{
310	    HelpID = "dbaccess:PushButton:TAB_WIZ_TYPE_SELECT:PB_AUTO";
311        Pos                 = MAP_APPFONT ( WINDOW_SIZE_X - 62 , WINDOW_SIZE_Y - WINDOW_BORDER_Y - 30 ) ;
312		Size				= MAP_APPFONT ( BUTTON_SIZE_X , BUTTON_SIZE_Y ) ;
313		TabStop				= TRUE ;
314		Text				= "~Auto" ;
315	};
316};
317
318Menu RID_SBA_RTF_PKEYPOPUP
319{
320	ItemList =
321	{
322		MenuItem
323		{
324			Identifier		= SID_TABLEDESIGN_TABED_PRIMARYKEY ;
325			HelpID			= HID_TABLEDESIGN_TABED_PRIMARYKEY ;
326			Checkable		= TRUE ;
327			Text [ en-US ] = "Primary Key" ;
328		};
329	};
330};
331//==================================================================
332 // TAB_WIZ_NAME_MATCHING
333 //==================================================================
334TabPage TAB_WIZ_NAME_MATCHING
335{
336    HelpID = "dbaccess:TabPage:TAB_WIZ_NAME_MATCHING";
337	SVLook	= TRUE ;
338	Size	= MAP_APPFONT ( WINDOW_SIZE_X , WINDOW_SIZE_Y ) ;
339
340	Hide	= TRUE;
341
342	FixedText FT_TABLE_LEFT
343	{
344		Pos					= MAP_APPFONT ( 52 , 6  ) ;
345		Size				= MAP_APPFONT ( 75 , 20) ;
346		Text [ en-US ] = "Source table: \n";
347	};
348
349	FixedText FT_TABLE_RIGHT
350	{
351        Pos                 = MAP_APPFONT ( 144, 6  ) ;
352		Size				= MAP_APPFONT ( 75 , 20) ;
353		Text [ en-US ] = "Destination table: \n";
354	};
355
356	Control CTRL_LEFT
357	{
358		Border				= TRUE;
359		Pos					= MAP_APPFONT ( 52, 28) ;
360        Size                = MAP_APPFONT ( 82 , WINDOW_SIZE_Y - 34 ) ;
361		TabStop				= TRUE;
362		HelpId				= HID_TAB_NAMEMATCHING_COLS_AVAIL;
363		/*DialogControl       = TRUE;*/
364	};
365
366	Control CTRL_RIGHT
367	{
368		Border				= TRUE ;
369        Pos                 = MAP_APPFONT ( 144, 28) ;
370        Size                = MAP_APPFONT ( 82 , WINDOW_SIZE_Y - 34 ) ;
371		TabStop				= TRUE;
372		HelpId				= HID_TAB_NAMEMATCHING_COLS_ASSIGN;
373		/*DialogControl       = TRUE;*/
374	};
375
376    ImageButton IB_COLUMN_UP
377	{
378        HelpID = "dbaccess:ImageButton:TAB_WIZ_NAME_MATCHING:IB_COLUMN_UP";
379        Pos                 = MAP_APPFONT ( 19 ,  45 ) ;
380        Size                = MAP_APPFONT ( 14 , 14 ) ;
381		TabStop				= TRUE;
382		DefButton           = TRUE;
383		ButtonImage = Image
384		{
385			ImageBitmap = Bitmap
386			{
387                File = "sortup.bmp" ;
388			};
389			MaskColor = Color
390			{
391                Red = 0xFFFF ;
392                Green = 0x0000 ;
393                Blue = 0xFFFF ;
394			};
395		};
396	};
397    ImageButton IB_COLUMN_DOWN
398	{
399        HelpID = "dbaccess:ImageButton:TAB_WIZ_NAME_MATCHING:IB_COLUMN_DOWN";
400        Pos                 = MAP_APPFONT ( 19 ,  63 ) ;
401        Size                = MAP_APPFONT ( 14 , 14 ) ;
402		TabStop				= TRUE;
403		ButtonImage = Image
404		{
405			ImageBitmap = Bitmap
406			{
407                File = "sortdown.bmp" ;
408			};
409			MaskColor = Color
410			{
411                Red = 0xFFFF ;
412                Green = 0x0000 ;
413                Blue = 0xFFFF ;
414			};
415		};
416	};
417    ImageButton IB_COLUMN_UP_RIGHT
418	{
419        HelpID = "dbaccess:ImageButton:TAB_WIZ_NAME_MATCHING:IB_COLUMN_UP_RIGHT";
420        Pos                 = MAP_APPFONT ( WINDOW_SIZE_X - 33, 45 ) ;
421        Size                = MAP_APPFONT ( 14 , 14 ) ;
422		TabStop				= TRUE;
423		DefButton           = TRUE;
424		ButtonImage = Image
425		{
426			ImageBitmap = Bitmap
427			{
428                File = "sortup.bmp" ;
429			};
430			MaskColor = Color
431			{
432                Red = 0xFFFF ;
433                Green = 0x0000 ;
434                Blue = 0xFFFF ;
435			};
436		};
437	};
438    ImageButton IB_COLUMN_DOWN_RIGHT
439	{
440        HelpID = "dbaccess:ImageButton:TAB_WIZ_NAME_MATCHING:IB_COLUMN_DOWN_RIGHT";
441        Pos                 = MAP_APPFONT ( WINDOW_SIZE_X - 33, 63) ;
442        Size                = MAP_APPFONT ( 14 , 14 ) ;
443		TabStop				= TRUE ;
444		ButtonImage = Image
445		{
446			ImageBitmap = Bitmap
447			{
448                File = "sortdown.bmp" ;
449			};
450			MaskColor = Color
451			{
452                Red = 0xFFFF ;
453                Green = 0x0000 ;
454                Blue = 0xFFFF ;
455			};
456		};
457	};
458
459	PushButton PB_ALL
460	{
461	    HelpID = "dbaccess:PushButton:TAB_WIZ_NAME_MATCHING:PB_ALL";
462        Pos                 = MAP_APPFONT ( 6, 83) ;
463		Size				= MAP_APPFONT ( 40 , 14 ) ;
464		TabStop				= TRUE ;
465		Text [ en-US ]	= "~All" ;
466	};
467
468	PushButton PB_NONE
469	{
470	    HelpID = "dbaccess:PushButton:TAB_WIZ_NAME_MATCHING:PB_NONE";
471        Pos                 = MAP_APPFONT ( 6, 103) ;
472		Size				= MAP_APPFONT ( 40 , 14 ) ;
473		TabStop				= TRUE ;
474		Text [ en-US ]	= "Non~e" ;
475	};
476};
477TabPage TAB_WIZ_COPYTABLE
478{
479	SVLook	= TRUE ;
480    Size    = MAP_APPFONT ( WINDOW_SIZE_X, WINDOW_SIZE_Y ) ;
481
482	HelpId	= HID_TAB_WIZ_COPYTABLE;
483	Hide	= TRUE;
484
485	FixedText FT_TABLENAME
486	{
487        Pos                 = MAP_APPFONT ( 12 , 11) ;
488        Size                = MAP_APPFONT ( 60 , 8 ) ;
489		Text [ en-US ] = "Ta~ble name";
490	};
491
492	Edit ET_TABLENAME
493	{
494		HelpId				= HID_TAB_WIZ_TABLENAME_EDIT;
495		Border				= TRUE ;
496        Pos                 = MAP_APPFONT ( 80 , 9) ;
497        Size                = MAP_APPFONT ( WINDOW_SIZE_X - 92 , 12 ) ;
498		TabStop				= TRUE ;
499	};
500
501    FixedLine FL_OPTIONS
502	{
503        Pos                 = MAP_APPFONT ( 6 , 24 ) ;
504        Size                = MAP_APPFONT ( WINDOW_SIZE_X - 12 , 8 ) ;
505		Text [ en-US ] = "Options" ;
506	};
507	RadioButton RB_DEFDATA
508	{
509	    HelpID = "dbaccess:RadioButton:TAB_WIZ_COPYTABLE:RB_DEFDATA";
510        Pos                 = MAP_APPFONT ( 12 , 35 ) ;
511		Size				= MAP_APPFONT ( 73 , 10 ) ;
512		Text [ en-US ] = "De~finition and data" ;
513	};
514	RadioButton RB_DEF
515	{
516	    HelpID = "dbaccess:RadioButton:TAB_WIZ_COPYTABLE:RB_DEF";
517        Pos                 = MAP_APPFONT ( 12, 49 ) ;
518		Size				= MAP_APPFONT ( 73 , 10 ) ;
519		Text [ en-US ] = "Def~inition" ;
520	};
521
522	RadioButton RB_VIEW
523	{
524	    HelpID = "dbaccess:RadioButton:TAB_WIZ_COPYTABLE:RB_VIEW";
525        Pos                 = MAP_APPFONT ( 12, 63 ) ;
526		Size				= MAP_APPFONT ( 73 , 10 ) ;
527		Text [ en-US ] = "A~s table view";
528	};
529
530	RadioButton RB_APPENDDATA
531	{
532	    HelpID = "dbaccess:RadioButton:TAB_WIZ_COPYTABLE:RB_APPENDDATA";
533        Pos                 = MAP_APPFONT ( 12, 77 ) ;
534		Size				= MAP_APPFONT ( 73 , 10 ) ;
535		Text [ en-US ] = "Append ~data" ;
536	};
537
538    CheckBox CB_USEHEADERLINE
539	{
540        HelpID = "dbaccess:CheckBox:TAB_WIZ_COPYTABLE:CB_USEHEADERLINE";
541        Pos                 = MAP_APPFONT ( 12, 93 ) ;
542		Size				= MAP_APPFONT ( WINDOW_SIZE_X - 18, 10 ) ;
543		Text [ en-US ] = "Use first ~line as column names" ;
544	};
545
546	CheckBox CB_PRIMARY_COLUMN
547	{
548	    HelpID = "dbaccess:CheckBox:TAB_WIZ_COPYTABLE:CB_PRIMARY_COLUMN";
549        Pos                 = MAP_APPFONT ( 12, 107 ) ;
550		Size				= MAP_APPFONT ( 90 , 10 ) ;
551		Text [ en-US ] = "Crea~te primary key";
552	};
553	FixedText FT_KEYNAME
554	{
555        Pos                 = MAP_APPFONT ( 21 , 122 ) ;
556        Size                = MAP_APPFONT ( 39 , 8 ) ;
557		Text [ en-US ] = "Name";
558	};
559
560	Edit ET_KEYNAME
561	{
562	    HelpID = "dbaccess:Edit:TAB_WIZ_COPYTABLE:ET_KEYNAME";
563        Pos                 = MAP_APPFONT ( 80, 120 ) ;
564		Size				= MAP_APPFONT ( 65 , 12 ) ;
565		TabStop				= TRUE ;
566		Border				= TRUE ;
567	};
568};
569
570String STR_WIZ_TABLE_COPY
571{
572	Text [ en-US ] = "Copy table" ;
573};
574
575String STR_COPYTABLE_TITLE_COPY
576{
577	Text [ en-US ] = "Copy table" ;
578};
579
580String STR_INVALID_TABLE_NAME
581{
582	Text [ en-US ] = "This table name is not valid in the current database.";
583};
584String STR_SUGGEST_APPEND_TABLE_DATA
585{
586	Text [ en-US ] = "Choose the option 'Append data' on the first page to append data to an existing table.";
587};
588
589String STR_INVALID_TABLE_NAME_LENGTH
590{
591	Text [ en-US ] = "Please change the table name. It is too long.";
592};
593
594Image IMG_SORTUP_H
595{
596	ImageBitmap = Bitmap
597	{
598        File = "sortup_h.bmp" ;
599	};
600	MaskColor = Color
601	{
602        Red = 0xFFFF ;
603        Green = 0x0000 ;
604        Blue = 0xFFFF ;
605	};
606};
607
608Image IMG_SORTDOWN_H
609{
610	ImageBitmap = Bitmap
611	{
612        File = "sortdown_h.bmp" ;
613	};
614	MaskColor = Color
615	{
616        Red = 0xFFFF ;
617        Green = 0x0000 ;
618        Blue = 0xFFFF ;
619	};
620};
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659