/*************************************************************************
 *
 *  OpenOffice.org - a multi-platform office productivity suite
 *
 *  $RCSfile: querydlg.src,v $
 *
 *  $Revision: 1.47 $
 *
 *  last change: $Author: hr $ $Date: 2005-09-23 14:18:25 $
 *
 *  The Contents of this file are made available subject to
 *  the terms of GNU Lesser General Public License Version 2.1.
 *
 *
 *    GNU Lesser General Public License Version 2.1
 *    =============================================
 *    Copyright 2005 by Sun Microsystems, Inc.
 *    901 San Antonio Road, Palo Alto, CA 94303, USA
 *
 *    This library is free software; you can redistribute it and/or
 *    modify it under the terms of the GNU Lesser General Public
 *    License version 2.1, as published by the Free Software Foundation.
 *
 *    This library is distributed in the hope that it will be useful,
 *    but WITHOUT ANY WARRANTY; without even the implied warranty of
 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *    Lesser General Public License for more details.
 *
 *    You should have received a copy of the GNU Lesser General Public
 *    License along with this library; if not, write to the Free Software
 *    Foundation, Inc., 59 Temple Place, Suite 330, Boston,
 *    MA  02111-1307  USA
 *
 ************************************************************************/
#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, 205 ) ;
    Text [ de ] = "Verbundeigenschaften" ;

    Moveable = TRUE ;
    Closeable = TRUE ;

    Window WND_CONTROL
    {
        Pos = MAP_APPFONT( 0, 0 );
        Size = MAP_APPFONT( 203, 113 );
        DialogControl = TRUE;
        HelpId        = HID_DLG_QRY_WINDOW_CONTROL ;

        FixedLine FL_INVOLVED_TABLES
        {
            Pos = MAP_APPFONT ( 6 , 3 ) ;
            Size = MAP_APPFONT ( 191 , 8 ) ;
            Text [ de ] = "beteiligte Tabellen" ;
            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 [ de ] = "beteiligte Felder" ;
            Text [ en-US ] = "Fields involved";
        };
    };

    FixedLine FL_JOIN
    {
        Pos = MAP_APPFONT ( 6 , 114 ) ;
        Size = MAP_APPFONT ( 191 , 8 ) ;
        Text [ de ] = "Optionen" ;
        Text [ en-US ] = "Options";
        Text [ x-comment ] = " ";
    };

    FixedText FT_LISTBOXTITLE
    {
        Pos = MAP_APPFONT ( 12 , 127 ) ;
        Size = MAP_APPFONT ( 89 , 8 ) ;

        Text [ de ] = "~Art" ;
        Text [ en-US ] = "~Type";
    };

    ListBox LB_JOINTYPE
    {
        Pos             = MAP_APPFONT ( 101 , 125 ) ;
        Size            = MAP_APPFONT ( 90 , 60 ) ;
        HelpId          = HID_DLG_QRY_JOINTYPE ;

        StringList [ de ] =
        {
            < "Innerer" ; Default; > ;
            < "Linker" ; Default; > ;
            < "Rechter" ; Default; > ;
            < "Vollständiger"  ; Default; > ;
        };
        DropDown        = TRUE;
        DDExtraWidth    = TRUE;
    StringList [ x-comment ] =
    {
         < "; Innerer" ; Default; > ;
        < "; Linker" ; Default; > ;
        < "; Rechter" ; Default; > ;
        < "; Vollständiger"  ; Default; > ;
    };
    StringList [ en-US ] =
    {
         < "Inner join" ; Default; > ;
        < "Left join" ; Default; > ;
        < "Right join" ; Default; > ;
        < "Full (outer) join"  ; Default; > ;
    };
    };

    FixedText ML_HELPTEXT
    {
        Pos             = MAP_APPFONT ( 12 , 145 ) ;
        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";
    Text [ x-comment ] = " ";
};

String STR_JOIN_TYPE_HINT
{
    Text [ de ] = "Bitte beachten Sie, daß einige Datenbanken eventuell diese Art der Verknüpfung nicht unterstützen.";
    Text [ en-US ] = "Please note that some databases may not support this join type.";
};

String STR_QUERY_INNER_JOIN
{
    Text [ de ] = "Beinhaltet nur die Datensätze, bei denen die Inhalte der verknüpften Felder beider Tabellen gleich sind.";
    Text [ en-US ] = "Includes only records for which the contents of the related fields of both tables are identical.";
    Text [ x-comment ] = " ";
};

String STR_QUERY_LEFTRIGHT_JOIN
{
    Text [ de ] = "Beinhaltet ALLE Datensätze aus '%1' und nur die Datensätze aus '%2', bei denen die Inhalte der verknüpften Felder beider Tabellen gleich sind.";
    Text [ en-US ] = "Contains ALL records from table '%1' but only records from table '%2' where the values in the related fields are matching.";
    Text [ x-comment ] = " ";
};

String STR_QUERY_FULL_JOIN
{
    Text [ de ] = "Beinhaltet ALLE Datensätze aus '%1' und aus '%2'.";
    Text [ en-US ] = "Contains ALL records from '%1' and from '%2'.";
    Text [ x-comment ] = " ";
};