/**************************************************************
 * 
 * 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_QUERY_HRC
#include "Query.hrc"
#endif
#ifndef _GLOBLMN_HRC
#include <svx/globlmn.hrc>
#endif
#ifndef _CNTIDS_HRC
#include <sfx2/cntids.hrc>
#endif
#ifndef DBACCESS_UI_BROWSER_ID_HXX
#include "browserids.hxx"
#endif
#ifndef _DBA_DBACCESS_HELPID_HRC_
#include "dbaccess_helpid.hrc"
#endif
#ifndef DBAUI_TOOLBOX_HXX
#include "toolbox.hrc"
#endif

#define MN_EDIT 20
#define MN_VIEW 21
#define MN_EXTRA 22
#define MN_INSERT 23
#define MN_WIN 30
#define MN_HELP 31

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; };
};
ImageList IMG_JOINS_H
{
    Prefix = "joh";
	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_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." ;
};
ErrorBox ERR_QRY_AMB_FIELD
{
	Message [ en-US ] = "Field name not found or not unique" ;
};
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?";
};

ErrorBox ERR_QRY_NOSTATEMENT
{
	Message [ en-US ] = "No query could be created.";
};

ErrorBox ERR_QRY_NOCRITERIA
{
	Message [ en-US ] = "No query could be created because no fields were selected.";
};

/*
  The menubar resource has become obsolete - you can now find the menubar definition at: <project>/uiconfig/dbquery/menubar/menubar.xml
 */

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.";
};