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