/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
 * This file is part of the LibreOffice project.
 *
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 * This file incorporates work covered by the following license notice:
 *
 *   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 .
 */
#include "dbu_qry.hrc"
#include "Query.hrc"
#include <svx/globlmn.hrc>
#include <sfx2/cntids.hrc>
#include "browserids.hxx"
#include "dbaccess_helpid.hrc"
#include "toolbox.hrc"

Menu RID_MENU_JOINVIEW_CONNECTION
{
    ItemList =
    {
        MenuItem
        {
            ITEM_EDIT_DELETE
        };
        MenuItem
        {
            MID_DBUI_QUERY_EDIT_JOINCONNECTION
        };
    };
};

Menu RID_MENU_JOINVIEW_TABLE
{
    ItemList =
    {
        MenuItem
        {
            ITEM_EDIT_DELETE
        };
     };
};

Menu RID_QUERYCOLPOPUPMENU
{
    ItemList =
    {
        MenuItem
        {
            MID_COLUMN_WIDTH
        };
        MenuItem
        {
            Separator = TRUE ;
        };
        MenuItem
        {
            ITEM_EDIT_DELETE
        };
    };
};

ImageList IMG_JOINS
{
    Prefix = "jo";
    MaskColor   = Color { Red   = 0xffff; Green = 0x0000; Blue  = 0xffff; };
    IdList = {
        IMG_PRIMARY_KEY; IMG_FOREIGN_KEY;
    };
    IdCount = { 2; };
};

String STR_QUERY_UNDO_TABWINSHOW
{
    Text [ en-US ] = "Add Table Window" ;
};

String STR_QUERY_UNDO_MOVETABWIN
{
    Text [ en-US ] = "Move table window" ;
};
String STR_QUERY_UNDO_INSERTCONNECTION
{
    Text [ en-US ] = "Insert Join" ;
};

String STR_QUERY_UNDO_REMOVECONNECTION
{
    Text [ en-US ] = "Delete Join" ;
};

String STR_QUERY_UNDO_SIZETABWIN
{
    Text [ en-US ] = "Resize table window" ;
};
String STR_QUERY_UNDO_TABFIELDDELETE
{
    Text [ en-US ] = "Delete Column" ;
};

String STR_QUERY_UNDO_TABFIELDMOVED
{
    Text [ en-US ] = "Move column";
};

String STR_QUERY_UNDO_TABFIELDCREATE
{
    Text [ en-US ] = "Add Column" ;
};

String RID_STR_TABLE_DOESNT_EXIST
{
    Text [ en-US ] = "Invalid expression, table '$name$' does not exist.";
};

String RID_STR_FIELD_DOESNT_EXIST
{
    Text [ en-US ] = "Invalid expression, field name '$name$' does not exist.";
};

String RID_STR_TOMUCHTABLES
{
    Text [ en-US ] = "The query covers #num# tables. The selected database type, however, can only process a maximum of #maxnum# table(s) per statement.";
};

String STR_QUERY_UNDO_TABWINDELETE
{
    Text [ en-US ] = "Delete Table Window" ;
};

String STR_QUERY_UNDO_MODIFY_CELL
{
    Text [ en-US ] = "Edit Column Description";
};

String STR_QUERY_UNDO_SIZE_COLUMN
{
    Text [ en-US ] = "Adjust column width";
};

String STR_QUERY_SORTTEXT
{
    Text [ en-US ] = "(not sorted);ascending;descending" ;
};

String STR_QUERY_FUNCTIONS
{
    Text [ en-US ] = "(no function);Group";
};

String STR_QUERY_NOTABLE
{
    Text [ en-US ] = "(no table)";
};

String STR_QRY_ORDERBY_UNRELATED
{
    Text [ en-US ] = "The database only supports sorting for visible fields.";
};

Menu RID_QUERYFUNCTION_POPUPMENU
{
    ItemList =
    {
        MenuItem
        {
            Identifier = ID_QUERY_FUNCTION ;
            HelpID = HID_QUERY_FUNCTION;
            Text [ en-US ] = "Functions";
        };
        MenuItem
        {
            Separator = TRUE ;
        };
        MenuItem
        {
            Identifier = ID_QUERY_TABLENAME ;
            HelpID = HID_QUERY_TABLENAME ;
            Text [ en-US ] = "Table Name";
        };
        MenuItem
        {
            Identifier = ID_QUERY_ALIASNAME ;
            HelpID = HID_QUERY_ALIASNAME ;
            Text [ en-US ] = "Alias";
        };
        MenuItem
        {
            Separator = TRUE;
        };
        MenuItem
        {
            Identifier = ID_QUERY_DISTINCT ;
            HelpID = HID_QUERY_DISTINCT ;
            Text [ en-US ] = "Distinct Values";
        };
    };
};

String STR_QUERY_HANDLETEXT
{
    Text [ en-US ] = "Field;Alias;Table;Sort;Visible;Function;Criterion;Or;Or";
};

String STR_QUERY_LIMIT_ALL
{
    Text [ en-US ] = "All";
};

String STR_QRY_TOO_MANY_COLUMNS
{
    Text [ en-US ] = "There are too many columns.";
};

ErrorBox ERR_QRY_CRITERIA_ON_ASTERISK
{
    Message [ en-US ] = "A condition cannot be applied to field [*]" ;
};

String STR_QRY_TOO_LONG_STATEMENT
{
    Text [ en-US ] = "The SQL statement created is too long.";
};

String STR_QRY_TOOCOMPLEX
{
    Text [ en-US ] = "Query is too complex" ;
};

String STR_QRY_NOSELECT
{
    Text [ en-US ] = "Nothing has been selected." ;
};

String STR_QRY_TOOMANYCOND
{
    Text [ en-US ] = "Too many search criteria" ;
};

String STR_QRY_SYNTAX
{
    Text [ en-US ] = "SQL syntax error" ;
};

ErrorBox ERR_QRY_ORDERBY_ON_ASTERISK
{
    Message [ en-US ] = "[*] cannot be used as a sort criterion.";
};

String STR_QRY_TOO_MANY_TABLES
{
    Text [ en-US ] = "There are too many tables.";
};

String STR_QRY_NATIVE
{
    Text [ en-US ] = "The statement will not be applied when querying in the SQL dialect of the database." ;
};

String STR_QRY_ILLEGAL_JOIN
{
    Text [ en-US ] = "Join could not be processed" ;
};

String STR_SVT_SQL_SYNTAX_ERROR
{
    Text [ en-US ] = "Syntax error in SQL statement" ;
};

String STR_QUERYDESIGN_NO_VIEW_SUPPORT
{
    Text [ en-US ] = "This database does not support table views.";
};

String STR_NO_ALTER_VIEW_SUPPORT
{
    Text [ en-US ] = "This database does not support altering of existing table views.";
};

String STR_QUERYDESIGN_NO_VIEW_ASK
{
    Text [ en-US ] = "Do you want to create a query instead?";
};

String STR_DATASOURCE_DELETED
{
    Text [ en-US ] = "The corresponding data source has been deleted. Therefore, data relevant to that data source cannot be saved.";
};

String STR_QRY_COLUMN_NOT_FOUND
{
    Text [ en-US ] = "The column '$name$' is unknown.";
};

String STR_QRY_JOIN_COLUMN_COMPARE
{
    Text [ en-US ] = "Columns can only be compared using '='.";
};

String STR_QRY_LIKE_LEFT_NO_COLUMN
{
    Text [ en-US ] = "You must use a column name before 'LIKE'.";
};

String STR_QRY_CHECK_CASESENSITIVE
{
    Text [ en-US ] = "The column could not be found. Please note that the database is case-sensitive.";
};

String STR_QUERYDESIGN
{
    Text [ en-US ] = " - %PRODUCTNAME Base: Query Design";
};

String STR_VIEWDESIGN
{
    Text [ en-US ] = " - %PRODUCTNAME Base: View Design";
};

String STR_QUERY_SAVEMODIFIED
{
    Text [ en-US ] = "$object$ has been changed.\nDo you want to save the changes?" ;
    Text [ x-comment ] = "For $object$, one of the values of the RSC_QUERY_OBJECT_TYPE resource will be inserted.";
};

String STR_ERROR_PARSING_STATEMENT
{
    Text [ en-US ] = "$object$ is based on an SQL command which could not be parsed.";
    Text [ x-comment ] = "For $object$, one of the values of the RSC_QUERY_OBJECT_TYPE resource "
        "(except \"SQL command\", which doesn't make sense here) will be inserted.";
};

String STR_INFO_OPENING_IN_SQL_VIEW
{
    Text [ en-US ] = "$object$ will be opened in SQL view.";
    Text [ x-comment ] = "For $object$, one of the values of the RSC_QUERY_OBJECT_TYPE resource "
        "(except \"SQL command\", which doesn't make sense here) will be inserted.";
};

Resource RSC_QUERY_OBJECT_TYPE
{
    String 1
    {
        Text [ en-US ] = "The table view";
    };
    String 2
    {
        Text [ en-US ] = "The query";
    };
    String 3
    {
        Text [ en-US ] = "The SQL statement";
    };
};

String STR_STATEMENT_WITHOUT_RESULT_SET
{
    Text [ en-US ] = "The query does not create a result set, and thus cannot be part of another query.";
};

String STR_NO_DATASOURCE_OR_CONNECTION
{
    Text [ en-US ] = "Both the ActiveConnection and the DataSourceName parameter are missing or wrong - cannot initialize the query designer.";
};

/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
