| /************************************************************** | |
| * | |
| * Licensed to the Apache Software Foundation (ASF) under one | |
| * or more contributor license agreements. See the NOTICE file | |
| * distributed with this work for additional information | |
| * regarding copyright ownership. The ASF licenses this file | |
| * to you under the Apache License, Version 2.0 (the | |
| * "License"); you may not use this file except in compliance | |
| * with the License. You may obtain a copy of the License at | |
| * | |
| * http://www.apache.org/licenses/LICENSE-2.0 | |
| * | |
| * Unless required by applicable law or agreed to in writing, | |
| * software distributed under the License is distributed on an | |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
| * KIND, either express or implied. See the License for the | |
| * specific language governing permissions and limitations | |
| * under the License. | |
| * | |
| *************************************************************/ | |
| #ifndef _DBU_QRY_HRC_ | |
| #include "dbu_qry.hrc" | |
| #endif | |
| #ifndef DBAUI_QUERYDLG_HRC | |
| #include "querydlg.hrc" | |
| #endif | |
| #include "dbaccess_helpid.hrc" | |
| ModalDialog DLG_QRY_JOIN | |
| { | |
| OutputSize = TRUE ; | |
| SVLook = TRUE ; | |
| HelpId = HID_DLG_QRY_JOIN ; | |
| Size = MAP_APPFONT ( 265, 219 ) ; | |
| Moveable = TRUE ; | |
| Closeable = TRUE ; | |
| Window WND_JOIN_CONTROL | |
| { | |
| Pos = MAP_APPFONT( 0, 0 ); | |
| Size = MAP_APPFONT( 203, 44 ); | |
| DialogControl = TRUE; | |
| HelpId = HID_DLG_QRY_JOIN_CONTROL ; | |
| FixedLine FL_JOIN | |
| { | |
| Pos = MAP_APPFONT ( 6 , 3 ) ; | |
| Size = MAP_APPFONT ( 191 , 8 ) ; | |
| Text [ en-US ] = "Options"; | |
| }; | |
| FixedText FT_LISTBOXTITLE | |
| { | |
| Pos = MAP_APPFONT ( 12 , 16 ) ; | |
| Size = MAP_APPFONT ( 89 , 8 ) ; | |
| Text [ en-US ] = "~Type"; | |
| }; | |
| ListBox LB_JOINTYPE | |
| { | |
| Pos = MAP_APPFONT ( 101 , 15 ) ; | |
| Size = MAP_APPFONT ( 90 , 60 ) ; | |
| HelpId = HID_DLG_QRY_JOINTYPE ; | |
| DropDown = TRUE; | |
| DDExtraWidth = TRUE; | |
| StringList [ en-US ] = | |
| { | |
| < "Inner join" ; ID_INNER_JOIN; > ; | |
| < "Left join" ; ID_LEFT_JOIN; > ; | |
| < "Right join" ; ID_RIGHT_JOIN; > ; | |
| < "Full (outer) join" ; ID_FULL_JOIN; > ; | |
| < "Cross join" ; ID_CROSS_JOIN; > ; | |
| }; | |
| }; | |
| CheckBox CB_NATURAL | |
| { | |
| HelpID = "dbaccess:CheckBox:DLG_QRY_JOIN:CB_NATURAL"; | |
| Pos = MAP_APPFONT ( 101 , 31 ) ; | |
| Size = MAP_APPFONT ( 89 , 8 ) ; | |
| Text [ en-US ] = "Natural"; | |
| }; | |
| }; | |
| Window WND_CONTROL | |
| { | |
| Pos = MAP_APPFONT( 0, 0 ); | |
| Size = MAP_APPFONT( 203, 153 ); | |
| DialogControl = TRUE; | |
| HelpId = HID_DLG_QRY_WINDOW_CONTROL ; | |
| FixedLine FL_INVOLVED_TABLES | |
| { | |
| Pos = MAP_APPFONT ( 6 , 3 ) ; | |
| Size = MAP_APPFONT ( 191 , 8 ) ; | |
| Text [ en-US ] = "Tables involved"; | |
| }; | |
| ListBox LB_LEFT_TABLE | |
| { | |
| Border = TRUE; | |
| Pos = MAP_APPFONT( 12, 14 ); | |
| Size = MAP_APPFONT( 87, 60 ); | |
| HelpId = HID_DLG_QRY_LEFT_TABLE ; | |
| DropDown = TRUE; | |
| TabStop = TRUE; | |
| }; | |
| ListBox LB_RIGHT_TABLE | |
| { | |
| Border = TRUE; | |
| Pos = MAP_APPFONT( 104, 14 ); | |
| Size = MAP_APPFONT( 87, 60 ); | |
| HelpId = HID_DLG_QRY_RIGHT_TABLE ; | |
| DropDown = TRUE; | |
| TabStop = TRUE; | |
| }; | |
| FixedLine FL_INVOLVED_FIELDS | |
| { | |
| Pos = MAP_APPFONT ( 6 , 29 ) ; | |
| Size = MAP_APPFONT ( 191 , 8 ) ; | |
| Text [ en-US ] = "Fields involved"; | |
| }; | |
| }; | |
| FixedText ML_HELPTEXT | |
| { | |
| Pos = MAP_APPFONT ( 12 , 159 ) ; | |
| Size = MAP_APPFONT ( 179 , 49 ) ; | |
| UniqueId = HID_DLG_QRY_HELPTEXT ; | |
| SVLook = TRUE; | |
| WordBreak = TRUE; | |
| }; | |
| OKButton PB_OK | |
| { | |
| Pos = MAP_APPFONT ( 206 , 6 ) ; | |
| Size = MAP_APPFONT ( 50 , 14 ) ; | |
| TabStop = TRUE ; | |
| DefButton = TRUE ; | |
| }; | |
| CancelButton PB_CANCEL | |
| { | |
| Pos = MAP_APPFONT ( 206 , 23 ) ; | |
| Size = MAP_APPFONT ( 50 , 14 ) ; | |
| TabStop = TRUE ; | |
| }; | |
| HelpButton PB_HELP | |
| { | |
| Pos = MAP_APPFONT ( 206 , 43 ) ; | |
| Size = MAP_APPFONT ( 50 , 14 ) ; | |
| TabStop = TRUE ; | |
| }; | |
| Text [ en-US ] = "Join Properties"; | |
| }; | |
| String STR_JOIN_TYPE_HINT | |
| { | |
| Text [ en-US ] = "Please note that some databases may not support this join type."; | |
| }; | |
| String STR_QUERY_INNER_JOIN | |
| { | |
| Text [ en-US ] = "Includes only records for which the contents of the related fields of both tables are identical."; | |
| }; | |
| String STR_QUERY_LEFTRIGHT_JOIN | |
| { | |
| Text [ en-US ] = "Contains ALL records from table '%1' but only records from table '%2' where the values in the related fields are matching."; | |
| }; | |
| String STR_QUERY_FULL_JOIN | |
| { | |
| Text [ en-US ] = "Contains ALL records from '%1' and from '%2'."; | |
| }; | |
| String STR_QUERY_CROSS_JOIN | |
| { | |
| Text [ en-US ] = "Contains the cartesian product of ALL records from '%1' and from '%2'."; | |
| }; | |
| String STR_QUERY_NATURAL_JOIN | |
| { | |
| Text [ en-US ] = "Contains only one column for each pair of equally-named columns from '%1' and from '%2'."; | |
| }; |