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#ifndef _DBU_QRY_HRC_
28#include "dbu_qry.hrc"
29#endif
30#ifndef DBAUI_QUERYDLG_HRC
31#include "querydlg.hrc"
32#endif
33#include "dbaccess_helpid.hrc"
34
35ModalDialog DLG_QRY_JOIN
36{
37	OutputSize = TRUE ;
38	SVLook = TRUE ;
39	HelpId = HID_DLG_QRY_JOIN ;
40	Size = MAP_APPFONT ( 265, 219 ) ;
41
42	Moveable = TRUE ;
43	Closeable = TRUE ;
44
45    Window WND_JOIN_CONTROL
46	{
47		Pos = MAP_APPFONT( 0, 0 );
48		Size = MAP_APPFONT( 203, 44 );
49		DialogControl = TRUE;
50		HelpId        = HID_DLG_QRY_JOIN_CONTROL ;
51        FixedLine FL_JOIN
52	    {
53		    Pos = MAP_APPFONT ( 6 , 3 ) ;
54		    Size = MAP_APPFONT ( 191 , 8 ) ;
55		    Text [ en-US ] = "Options";
56	    };
57
58	    FixedText FT_LISTBOXTITLE
59	    {
60		    Pos = MAP_APPFONT ( 12 , 16 ) ;
61		    Size = MAP_APPFONT ( 89 , 8 ) ;
62
63		    Text [ en-US ] = "~Type";
64	    };
65
66	    ListBox LB_JOINTYPE
67	    {
68		    Pos             = MAP_APPFONT ( 101 , 15 ) ;
69		    Size            = MAP_APPFONT ( 90 , 60 ) ;
70		    HelpId          = HID_DLG_QRY_JOINTYPE ;
71
72		    DropDown		= TRUE;
73		    DDExtraWidth	= TRUE;
74	        StringList [ en-US ] =
75	        {
76		        < "Inner join"          ; ID_INNER_JOIN;    > ;
77		        < "Left join"           ; ID_LEFT_JOIN;     > ;
78		        < "Right join"          ; ID_RIGHT_JOIN;    > ;
79		        < "Full (outer) join"   ; ID_FULL_JOIN;     > ;
80                < "Cross join"          ; ID_CROSS_JOIN;    > ;
81	        };
82	    };
83        CheckBox CB_NATURAL
84	    {
85            HelpID = "dbaccess:CheckBox:DLG_QRY_JOIN:CB_NATURAL";
86		    Pos = MAP_APPFONT ( 101 , 31 ) ;
87		    Size = MAP_APPFONT ( 89 , 8 ) ;
88
89		    Text [ en-US ] = "Natural";
90	    };
91    };
92
93	Window WND_CONTROL
94	{
95		Pos = MAP_APPFONT( 0, 0 );
96		Size = MAP_APPFONT( 203, 153 );
97		DialogControl = TRUE;
98		HelpId        = HID_DLG_QRY_WINDOW_CONTROL ;
99
100		FixedLine FL_INVOLVED_TABLES
101		{
102			Pos = MAP_APPFONT ( 6 , 3 ) ;
103			Size = MAP_APPFONT ( 191 , 8 ) ;
104			Text [ en-US ] = "Tables involved";
105		};
106
107		ListBox LB_LEFT_TABLE
108		{
109			Border = TRUE;
110			Pos = MAP_APPFONT( 12, 14 );
111			Size = MAP_APPFONT( 87, 60 );
112			HelpId        = HID_DLG_QRY_LEFT_TABLE ;
113			DropDown = TRUE;
114			TabStop = TRUE;
115		};
116
117		ListBox LB_RIGHT_TABLE
118		{
119			Border = TRUE;
120			Pos = MAP_APPFONT( 104, 14 );
121			Size = MAP_APPFONT( 87, 60 );
122			HelpId        = HID_DLG_QRY_RIGHT_TABLE ;
123			DropDown = TRUE;
124			TabStop = TRUE;
125		};
126
127		FixedLine FL_INVOLVED_FIELDS
128		{
129			Pos = MAP_APPFONT ( 6 , 29 ) ;
130			Size = MAP_APPFONT ( 191 , 8 ) ;
131			Text [ en-US ] = "Fields involved";
132		};
133	};
134
135	FixedText ML_HELPTEXT
136	{
137		Pos             = MAP_APPFONT ( 12 , 159 ) ;
138		Size            = MAP_APPFONT ( 179 , 49 ) ;
139		UniqueId        = HID_DLG_QRY_HELPTEXT ;
140		SVLook          = TRUE;
141		WordBreak		= TRUE;
142	};
143
144	OKButton PB_OK
145	{
146		Pos = MAP_APPFONT ( 206 , 6 ) ;
147		Size = MAP_APPFONT ( 50 , 14 ) ;
148		TabStop = TRUE ;
149		DefButton = TRUE ;
150	};
151	CancelButton PB_CANCEL
152	{
153		Pos = MAP_APPFONT ( 206 , 23 ) ;
154		Size = MAP_APPFONT ( 50 , 14 ) ;
155		TabStop = TRUE ;
156	};
157	HelpButton PB_HELP
158	{
159		Pos = MAP_APPFONT ( 206 , 43 ) ;
160		Size = MAP_APPFONT ( 50 , 14 ) ;
161		TabStop = TRUE ;
162	};
163
164	Text [ en-US ] = "Join Properties";
165};
166
167String STR_JOIN_TYPE_HINT
168{
169    Text [ en-US ] = "Please note that some databases may not support this join type.";
170};
171
172String STR_QUERY_INNER_JOIN
173{
174	Text [ en-US ] = "Includes only records for which the contents of the related fields of both tables are identical.";
175};
176
177String STR_QUERY_LEFTRIGHT_JOIN
178{
179	Text [ en-US ] = "Contains ALL records from table '%1' but only records from table '%2' where the values in the related fields are matching.";
180};
181
182String STR_QUERY_FULL_JOIN
183{
184	Text [ en-US ] = "Contains ALL records from '%1' and from '%2'.";
185};
186String STR_QUERY_CROSS_JOIN
187{
188	Text [ en-US ] = "Contains the cartesian product of ALL records from '%1' and from '%2'.";
189};
190String STR_QUERY_NATURAL_JOIN
191{
192	Text [ en-US ] = "Contains only one column for each pair of equally-named columns from '%1' and from '%2'.";
193};
194
195
196