1*81d089aeSAndrew Rist/************************************************************** 2cdf0e10cSrcweir * 3*81d089aeSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*81d089aeSAndrew Rist * or more contributor license agreements. See the NOTICE file 5*81d089aeSAndrew Rist * distributed with this work for additional information 6*81d089aeSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*81d089aeSAndrew Rist * to you under the Apache License, Version 2.0 (the 8*81d089aeSAndrew Rist * "License"); you may not use this file except in compliance 9*81d089aeSAndrew Rist * with the License. You may obtain a copy of the License at 10*81d089aeSAndrew Rist * 11*81d089aeSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*81d089aeSAndrew Rist * 13*81d089aeSAndrew Rist * Unless required by applicable law or agreed to in writing, 14*81d089aeSAndrew Rist * software distributed under the License is distributed on an 15*81d089aeSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*81d089aeSAndrew Rist * KIND, either express or implied. See the License for the 17*81d089aeSAndrew Rist * specific language governing permissions and limitations 18*81d089aeSAndrew Rist * under the License. 19*81d089aeSAndrew Rist * 20*81d089aeSAndrew Rist *************************************************************/ 21*81d089aeSAndrew Rist 22*81d089aeSAndrew Rist 23cdf0e10cSrcweir#ifndef _DBU_QRY_HRC_ 24cdf0e10cSrcweir#include "dbu_qry.hrc" 25cdf0e10cSrcweir#endif 26cdf0e10cSrcweir#ifndef DBAUI_QUERYDLG_HRC 27cdf0e10cSrcweir#include "querydlg.hrc" 28cdf0e10cSrcweir#endif 29cdf0e10cSrcweir#include "dbaccess_helpid.hrc" 30cdf0e10cSrcweir 31cdf0e10cSrcweirModalDialog DLG_QRY_JOIN 32cdf0e10cSrcweir{ 33cdf0e10cSrcweir OutputSize = TRUE ; 34cdf0e10cSrcweir SVLook = TRUE ; 35cdf0e10cSrcweir HelpId = HID_DLG_QRY_JOIN ; 36cdf0e10cSrcweir Size = MAP_APPFONT ( 265, 219 ) ; 37cdf0e10cSrcweir 38cdf0e10cSrcweir Moveable = TRUE ; 39cdf0e10cSrcweir Closeable = TRUE ; 40cdf0e10cSrcweir 41cdf0e10cSrcweir Window WND_JOIN_CONTROL 42cdf0e10cSrcweir { 43cdf0e10cSrcweir Pos = MAP_APPFONT( 0, 0 ); 44cdf0e10cSrcweir Size = MAP_APPFONT( 203, 44 ); 45cdf0e10cSrcweir DialogControl = TRUE; 46cdf0e10cSrcweir HelpId = HID_DLG_QRY_JOIN_CONTROL ; 47cdf0e10cSrcweir FixedLine FL_JOIN 48cdf0e10cSrcweir { 49cdf0e10cSrcweir Pos = MAP_APPFONT ( 6 , 3 ) ; 50cdf0e10cSrcweir Size = MAP_APPFONT ( 191 , 8 ) ; 51cdf0e10cSrcweir Text [ en-US ] = "Options"; 52cdf0e10cSrcweir }; 53cdf0e10cSrcweir 54cdf0e10cSrcweir FixedText FT_LISTBOXTITLE 55cdf0e10cSrcweir { 56cdf0e10cSrcweir Pos = MAP_APPFONT ( 12 , 16 ) ; 57cdf0e10cSrcweir Size = MAP_APPFONT ( 89 , 8 ) ; 58cdf0e10cSrcweir 59cdf0e10cSrcweir Text [ en-US ] = "~Type"; 60cdf0e10cSrcweir }; 61cdf0e10cSrcweir 62cdf0e10cSrcweir ListBox LB_JOINTYPE 63cdf0e10cSrcweir { 64cdf0e10cSrcweir Pos = MAP_APPFONT ( 101 , 15 ) ; 65cdf0e10cSrcweir Size = MAP_APPFONT ( 90 , 60 ) ; 66cdf0e10cSrcweir HelpId = HID_DLG_QRY_JOINTYPE ; 67cdf0e10cSrcweir 68cdf0e10cSrcweir DropDown = TRUE; 69cdf0e10cSrcweir DDExtraWidth = TRUE; 70cdf0e10cSrcweir StringList [ en-US ] = 71cdf0e10cSrcweir { 72cdf0e10cSrcweir < "Inner join" ; ID_INNER_JOIN; > ; 73cdf0e10cSrcweir < "Left join" ; ID_LEFT_JOIN; > ; 74cdf0e10cSrcweir < "Right join" ; ID_RIGHT_JOIN; > ; 75cdf0e10cSrcweir < "Full (outer) join" ; ID_FULL_JOIN; > ; 76cdf0e10cSrcweir < "Cross join" ; ID_CROSS_JOIN; > ; 77cdf0e10cSrcweir }; 78cdf0e10cSrcweir }; 79cdf0e10cSrcweir CheckBox CB_NATURAL 80cdf0e10cSrcweir { 81cdf0e10cSrcweir HelpID = "dbaccess:CheckBox:DLG_QRY_JOIN:CB_NATURAL"; 82cdf0e10cSrcweir Pos = MAP_APPFONT ( 101 , 31 ) ; 83cdf0e10cSrcweir Size = MAP_APPFONT ( 89 , 8 ) ; 84cdf0e10cSrcweir 85cdf0e10cSrcweir Text [ en-US ] = "Natural"; 86cdf0e10cSrcweir }; 87cdf0e10cSrcweir }; 88cdf0e10cSrcweir 89cdf0e10cSrcweir Window WND_CONTROL 90cdf0e10cSrcweir { 91cdf0e10cSrcweir Pos = MAP_APPFONT( 0, 0 ); 92cdf0e10cSrcweir Size = MAP_APPFONT( 203, 153 ); 93cdf0e10cSrcweir DialogControl = TRUE; 94cdf0e10cSrcweir HelpId = HID_DLG_QRY_WINDOW_CONTROL ; 95cdf0e10cSrcweir 96cdf0e10cSrcweir FixedLine FL_INVOLVED_TABLES 97cdf0e10cSrcweir { 98cdf0e10cSrcweir Pos = MAP_APPFONT ( 6 , 3 ) ; 99cdf0e10cSrcweir Size = MAP_APPFONT ( 191 , 8 ) ; 100cdf0e10cSrcweir Text [ en-US ] = "Tables involved"; 101cdf0e10cSrcweir }; 102cdf0e10cSrcweir 103cdf0e10cSrcweir ListBox LB_LEFT_TABLE 104cdf0e10cSrcweir { 105cdf0e10cSrcweir Border = TRUE; 106cdf0e10cSrcweir Pos = MAP_APPFONT( 12, 14 ); 107cdf0e10cSrcweir Size = MAP_APPFONT( 87, 60 ); 108cdf0e10cSrcweir HelpId = HID_DLG_QRY_LEFT_TABLE ; 109cdf0e10cSrcweir DropDown = TRUE; 110cdf0e10cSrcweir TabStop = TRUE; 111cdf0e10cSrcweir }; 112cdf0e10cSrcweir 113cdf0e10cSrcweir ListBox LB_RIGHT_TABLE 114cdf0e10cSrcweir { 115cdf0e10cSrcweir Border = TRUE; 116cdf0e10cSrcweir Pos = MAP_APPFONT( 104, 14 ); 117cdf0e10cSrcweir Size = MAP_APPFONT( 87, 60 ); 118cdf0e10cSrcweir HelpId = HID_DLG_QRY_RIGHT_TABLE ; 119cdf0e10cSrcweir DropDown = TRUE; 120cdf0e10cSrcweir TabStop = TRUE; 121cdf0e10cSrcweir }; 122cdf0e10cSrcweir 123cdf0e10cSrcweir FixedLine FL_INVOLVED_FIELDS 124cdf0e10cSrcweir { 125cdf0e10cSrcweir Pos = MAP_APPFONT ( 6 , 29 ) ; 126cdf0e10cSrcweir Size = MAP_APPFONT ( 191 , 8 ) ; 127cdf0e10cSrcweir Text [ en-US ] = "Fields involved"; 128cdf0e10cSrcweir }; 129cdf0e10cSrcweir }; 130cdf0e10cSrcweir 131cdf0e10cSrcweir FixedText ML_HELPTEXT 132cdf0e10cSrcweir { 133cdf0e10cSrcweir Pos = MAP_APPFONT ( 12 , 159 ) ; 134cdf0e10cSrcweir Size = MAP_APPFONT ( 179 , 49 ) ; 135cdf0e10cSrcweir UniqueId = HID_DLG_QRY_HELPTEXT ; 136cdf0e10cSrcweir SVLook = TRUE; 137cdf0e10cSrcweir WordBreak = TRUE; 138cdf0e10cSrcweir }; 139cdf0e10cSrcweir 140cdf0e10cSrcweir OKButton PB_OK 141cdf0e10cSrcweir { 142cdf0e10cSrcweir Pos = MAP_APPFONT ( 206 , 6 ) ; 143cdf0e10cSrcweir Size = MAP_APPFONT ( 50 , 14 ) ; 144cdf0e10cSrcweir TabStop = TRUE ; 145cdf0e10cSrcweir DefButton = TRUE ; 146cdf0e10cSrcweir }; 147cdf0e10cSrcweir CancelButton PB_CANCEL 148cdf0e10cSrcweir { 149cdf0e10cSrcweir Pos = MAP_APPFONT ( 206 , 23 ) ; 150cdf0e10cSrcweir Size = MAP_APPFONT ( 50 , 14 ) ; 151cdf0e10cSrcweir TabStop = TRUE ; 152cdf0e10cSrcweir }; 153cdf0e10cSrcweir HelpButton PB_HELP 154cdf0e10cSrcweir { 155cdf0e10cSrcweir Pos = MAP_APPFONT ( 206 , 43 ) ; 156cdf0e10cSrcweir Size = MAP_APPFONT ( 50 , 14 ) ; 157cdf0e10cSrcweir TabStop = TRUE ; 158cdf0e10cSrcweir }; 159cdf0e10cSrcweir 160cdf0e10cSrcweir Text [ en-US ] = "Join Properties"; 161cdf0e10cSrcweir}; 162cdf0e10cSrcweir 163cdf0e10cSrcweirString STR_JOIN_TYPE_HINT 164cdf0e10cSrcweir{ 165cdf0e10cSrcweir Text [ en-US ] = "Please note that some databases may not support this join type."; 166cdf0e10cSrcweir}; 167cdf0e10cSrcweir 168cdf0e10cSrcweirString STR_QUERY_INNER_JOIN 169cdf0e10cSrcweir{ 170cdf0e10cSrcweir Text [ en-US ] = "Includes only records for which the contents of the related fields of both tables are identical."; 171cdf0e10cSrcweir}; 172cdf0e10cSrcweir 173cdf0e10cSrcweirString STR_QUERY_LEFTRIGHT_JOIN 174cdf0e10cSrcweir{ 175cdf0e10cSrcweir Text [ en-US ] = "Contains ALL records from table '%1' but only records from table '%2' where the values in the related fields are matching."; 176cdf0e10cSrcweir}; 177cdf0e10cSrcweir 178cdf0e10cSrcweirString STR_QUERY_FULL_JOIN 179cdf0e10cSrcweir{ 180cdf0e10cSrcweir Text [ en-US ] = "Contains ALL records from '%1' and from '%2'."; 181cdf0e10cSrcweir}; 182cdf0e10cSrcweirString STR_QUERY_CROSS_JOIN 183cdf0e10cSrcweir{ 184cdf0e10cSrcweir Text [ en-US ] = "Contains the cartesian product of ALL records from '%1' and from '%2'."; 185cdf0e10cSrcweir}; 186cdf0e10cSrcweirString STR_QUERY_NATURAL_JOIN 187cdf0e10cSrcweir{ 188cdf0e10cSrcweir Text [ en-US ] = "Contains only one column for each pair of equally-named columns from '%1' and from '%2'."; 189cdf0e10cSrcweir}; 190cdf0e10cSrcweir 191cdf0e10cSrcweir 192