| /************************************************************** |
| * |
| * 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?" ; |
| }; |
| |
| String STR_ERROR_PARSING_STATEMENT |
| { |
| Text [ en-US ] = "$object$ is based on an SQL command which could not be parsed."; |
| }; |
| |
| String STR_INFO_OPENING_IN_SQL_VIEW |
| { |
| Text [ en-US ] = "$object$ will be opened in SQL view."; |
| }; |
| |
| 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."; |
| }; |