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