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