181d089aeSAndrew Rist/************************************************************** 2cdf0e10cSrcweir * 381d089aeSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 481d089aeSAndrew Rist * or more contributor license agreements. See the NOTICE file 581d089aeSAndrew Rist * distributed with this work for additional information 681d089aeSAndrew Rist * regarding copyright ownership. The ASF licenses this file 781d089aeSAndrew Rist * to you under the Apache License, Version 2.0 (the 881d089aeSAndrew Rist * "License"); you may not use this file except in compliance 981d089aeSAndrew Rist * with the License. You may obtain a copy of the License at 1081d089aeSAndrew Rist * 1181d089aeSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 1281d089aeSAndrew Rist * 1381d089aeSAndrew Rist * Unless required by applicable law or agreed to in writing, 1481d089aeSAndrew Rist * software distributed under the License is distributed on an 1581d089aeSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 1681d089aeSAndrew Rist * KIND, either express or implied. See the License for the 1781d089aeSAndrew Rist * specific language governing permissions and limitations 1881d089aeSAndrew Rist * under the License. 1981d089aeSAndrew Rist * 2081d089aeSAndrew Rist *************************************************************/ 2181d089aeSAndrew Rist 22*02f7a3b7Smseidel 23cdf0e10cSrcweir#ifndef _DBU_QRY_HRC_ 24cdf0e10cSrcweir#include "dbu_qry.hrc" 25cdf0e10cSrcweir#endif 26cdf0e10cSrcweir#ifndef DBAUI_QUERY_HRC 27cdf0e10cSrcweir#include "Query.hrc" 28cdf0e10cSrcweir#endif 29cdf0e10cSrcweir#ifndef _GLOBLMN_HRC 30cdf0e10cSrcweir#include <svx/globlmn.hrc> 31cdf0e10cSrcweir#endif 32cdf0e10cSrcweir#ifndef _CNTIDS_HRC 33cdf0e10cSrcweir#include <sfx2/cntids.hrc> 34cdf0e10cSrcweir#endif 35cdf0e10cSrcweir#ifndef DBACCESS_UI_BROWSER_ID_HXX 36cdf0e10cSrcweir#include "browserids.hxx" 37cdf0e10cSrcweir#endif 38cdf0e10cSrcweir#ifndef _DBA_DBACCESS_HELPID_HRC_ 39cdf0e10cSrcweir#include "dbaccess_helpid.hrc" 40cdf0e10cSrcweir#endif 41cdf0e10cSrcweir#ifndef DBAUI_TOOLBOX_HXX 42cdf0e10cSrcweir#include "toolbox.hrc" 43cdf0e10cSrcweir#endif 44cdf0e10cSrcweir 45cdf0e10cSrcweir#define MN_EDIT 20 46cdf0e10cSrcweir#define MN_VIEW 21 47cdf0e10cSrcweir#define MN_EXTRA 22 48cdf0e10cSrcweir#define MN_INSERT 23 49cdf0e10cSrcweir#define MN_WIN 30 50cdf0e10cSrcweir#define MN_HELP 31 51cdf0e10cSrcweir 52cdf0e10cSrcweirMenu RID_MENU_JOINVIEW_CONNECTION 53cdf0e10cSrcweir{ 54cdf0e10cSrcweir ItemList = 55cdf0e10cSrcweir { 56cdf0e10cSrcweir MenuItem 57cdf0e10cSrcweir { 58cdf0e10cSrcweir ITEM_EDIT_DELETE 59cdf0e10cSrcweir }; 60cdf0e10cSrcweir MenuItem 61cdf0e10cSrcweir { 62cdf0e10cSrcweir MID_DBUI_QUERY_EDIT_JOINCONNECTION 63cdf0e10cSrcweir }; 64cdf0e10cSrcweir }; 65cdf0e10cSrcweir}; 66cdf0e10cSrcweir 67cdf0e10cSrcweirMenu RID_MENU_JOINVIEW_TABLE 68cdf0e10cSrcweir{ 69cdf0e10cSrcweir ItemList = 70cdf0e10cSrcweir { 71cdf0e10cSrcweir MenuItem 72cdf0e10cSrcweir { 73cdf0e10cSrcweir ITEM_EDIT_DELETE 74cdf0e10cSrcweir }; 75cdf0e10cSrcweir }; 76cdf0e10cSrcweir}; 77cdf0e10cSrcweir 78cdf0e10cSrcweirMenu RID_QUERYCOLPOPUPMENU 79cdf0e10cSrcweir{ 80cdf0e10cSrcweir ItemList = 81cdf0e10cSrcweir { 82cdf0e10cSrcweir MenuItem 83cdf0e10cSrcweir { 84cdf0e10cSrcweir MID_COLUMN_WIDTH 85cdf0e10cSrcweir }; 86cdf0e10cSrcweir MenuItem 87cdf0e10cSrcweir { 88cdf0e10cSrcweir Separator = TRUE ; 89cdf0e10cSrcweir }; 90cdf0e10cSrcweir MenuItem 91cdf0e10cSrcweir { 92cdf0e10cSrcweir ITEM_EDIT_DELETE 93cdf0e10cSrcweir }; 94cdf0e10cSrcweir }; 95cdf0e10cSrcweir}; 96cdf0e10cSrcweirImageList IMG_JOINS 97cdf0e10cSrcweir{ 98cdf0e10cSrcweir Prefix = "jo"; 99cdf0e10cSrcweir MaskColor = Color { 100cdf0e10cSrcweir Red = 0xffff; 101cdf0e10cSrcweir Green = 0x0000; 102cdf0e10cSrcweir Blue = 0xffff; 103cdf0e10cSrcweir }; 104cdf0e10cSrcweir IdList = { 105cdf0e10cSrcweir IMG_PRIMARY_KEY; IMG_FOREIGN_KEY; 106cdf0e10cSrcweir }; 107cdf0e10cSrcweir IdCount = { 2; }; 108cdf0e10cSrcweir}; 109cdf0e10cSrcweirImageList IMG_JOINS_H 110cdf0e10cSrcweir{ 111cdf0e10cSrcweir Prefix = "joh"; 112cdf0e10cSrcweir MaskColor = Color { 113cdf0e10cSrcweir Red = 0xffff; 114cdf0e10cSrcweir Green = 0x0000; 115cdf0e10cSrcweir Blue = 0xffff; 116cdf0e10cSrcweir }; 117cdf0e10cSrcweir IdList = { 118cdf0e10cSrcweir IMG_PRIMARY_KEY; IMG_FOREIGN_KEY; 119cdf0e10cSrcweir }; 120cdf0e10cSrcweir IdCount = { 2; }; 121cdf0e10cSrcweir}; 122cdf0e10cSrcweir 123cdf0e10cSrcweirString STR_QUERY_UNDO_TABWINSHOW 124cdf0e10cSrcweir{ 125cdf0e10cSrcweir Text [ en-US ] = "Add Table Window" ; 126cdf0e10cSrcweir}; 127cdf0e10cSrcweir 128cdf0e10cSrcweirString STR_QUERY_UNDO_MOVETABWIN 129cdf0e10cSrcweir{ 130cdf0e10cSrcweir Text [ en-US ] = "Move table window" ; 131cdf0e10cSrcweir}; 132cdf0e10cSrcweirString STR_QUERY_UNDO_INSERTCONNECTION 133cdf0e10cSrcweir{ 134cdf0e10cSrcweir Text [ en-US ] = "Insert Join" ; 135cdf0e10cSrcweir}; 136cdf0e10cSrcweir 137cdf0e10cSrcweirString STR_QUERY_UNDO_REMOVECONNECTION 138cdf0e10cSrcweir{ 139cdf0e10cSrcweir Text [ en-US ] = "Delete Join" ; 140cdf0e10cSrcweir}; 141cdf0e10cSrcweir 142cdf0e10cSrcweirString STR_QUERY_UNDO_SIZETABWIN 143cdf0e10cSrcweir{ 144cdf0e10cSrcweir Text [ en-US ] = "Resize table window" ; 145cdf0e10cSrcweir}; 146cdf0e10cSrcweirString STR_QUERY_UNDO_TABFIELDDELETE 147cdf0e10cSrcweir{ 148cdf0e10cSrcweir Text [ en-US ] = "Delete Column" ; 149cdf0e10cSrcweir}; 150cdf0e10cSrcweir 151cdf0e10cSrcweirString STR_QUERY_UNDO_TABFIELDMOVED 152cdf0e10cSrcweir{ 153cdf0e10cSrcweir Text [ en-US ] = "Move column"; 154cdf0e10cSrcweir}; 155cdf0e10cSrcweir 156cdf0e10cSrcweirString STR_QUERY_UNDO_TABFIELDCREATE 157cdf0e10cSrcweir{ 158cdf0e10cSrcweir Text [ en-US ] = "Add Column" ; 159cdf0e10cSrcweir}; 160cdf0e10cSrcweirString RID_STR_TABLE_DOESNT_EXIST 161cdf0e10cSrcweir{ 162cdf0e10cSrcweir Text [ en-US ] = "Invalid expression, table '$name$' does not exist."; 163cdf0e10cSrcweir}; 164cdf0e10cSrcweir 165cdf0e10cSrcweirString RID_STR_FIELD_DOESNT_EXIST 166cdf0e10cSrcweir{ 167cdf0e10cSrcweir Text [ en-US ] = "Invalid expression, field name '$name$' does not exist."; 168cdf0e10cSrcweir}; 169cdf0e10cSrcweirString RID_STR_TOMUCHTABLES 170cdf0e10cSrcweir{ 171cdf0e10cSrcweir Text [ en-US ] = "The query covers #num# tables. The selected database type, however, can only process a maximum of #maxnum# table(s) per statement."; 172cdf0e10cSrcweir}; 173cdf0e10cSrcweir 174cdf0e10cSrcweirString STR_QUERY_UNDO_TABWINDELETE 175cdf0e10cSrcweir{ 176cdf0e10cSrcweir Text [ en-US ] = "Delete Table Window" ; 177cdf0e10cSrcweir}; 178cdf0e10cSrcweir 179cdf0e10cSrcweirString STR_QUERY_UNDO_MODIFY_CELL 180cdf0e10cSrcweir{ 181cdf0e10cSrcweir Text [ en-US ] = "Edit Column Description"; 182cdf0e10cSrcweir}; 183cdf0e10cSrcweirString STR_QUERY_UNDO_SIZE_COLUMN 184cdf0e10cSrcweir{ 185cdf0e10cSrcweir Text [ en-US ] = "Adjust column width"; 186cdf0e10cSrcweir}; 187cdf0e10cSrcweirString STR_QUERY_SORTTEXT 188cdf0e10cSrcweir{ 189cdf0e10cSrcweir Text [ en-US ] = "(not sorted);ascending;descending" ; 190cdf0e10cSrcweir}; 191cdf0e10cSrcweir 192cdf0e10cSrcweirString STR_QUERY_FUNCTIONS 193cdf0e10cSrcweir{ 194cdf0e10cSrcweir Text [ en-US ] = "(no function);Group"; 195cdf0e10cSrcweir}; 196cdf0e10cSrcweirString STR_QUERY_NOTABLE 197cdf0e10cSrcweir{ 198cdf0e10cSrcweir Text [ en-US ] = "(no table)"; 199cdf0e10cSrcweir}; 200cdf0e10cSrcweirString STR_QRY_ORDERBY_UNRELATED 201cdf0e10cSrcweir{ 202cdf0e10cSrcweir Text [ en-US ] = "The database only supports sorting for visible fields."; 203cdf0e10cSrcweir}; 204cdf0e10cSrcweirMenu RID_QUERYFUNCTION_POPUPMENU 205cdf0e10cSrcweir{ 206cdf0e10cSrcweir ItemList = 207cdf0e10cSrcweir { 208cdf0e10cSrcweir MenuItem 209cdf0e10cSrcweir { 210cdf0e10cSrcweir Identifier = ID_QUERY_FUNCTION ; 211cdf0e10cSrcweir HelpID = HID_QUERY_FUNCTION; 212cdf0e10cSrcweir Text [ en-US ] = "Functions"; 213cdf0e10cSrcweir }; 214cdf0e10cSrcweir MenuItem 215cdf0e10cSrcweir { 216cdf0e10cSrcweir Separator = TRUE ; 217cdf0e10cSrcweir }; 218cdf0e10cSrcweir MenuItem 219cdf0e10cSrcweir { 220cdf0e10cSrcweir Identifier = ID_QUERY_TABLENAME ; 221cdf0e10cSrcweir HelpID = HID_QUERY_TABLENAME ; 222cdf0e10cSrcweir Text [ en-US ] = "Table Name"; 223cdf0e10cSrcweir }; 224cdf0e10cSrcweir MenuItem 225cdf0e10cSrcweir { 226cdf0e10cSrcweir Identifier = ID_QUERY_ALIASNAME ; 227cdf0e10cSrcweir HelpID = HID_QUERY_ALIASNAME ; 228cdf0e10cSrcweir Text [ en-US ] = "Alias"; 229cdf0e10cSrcweir }; 230cdf0e10cSrcweir MenuItem 231cdf0e10cSrcweir { 232cdf0e10cSrcweir Separator = TRUE; 233cdf0e10cSrcweir }; 234cdf0e10cSrcweir MenuItem 235cdf0e10cSrcweir { 236cdf0e10cSrcweir Identifier = ID_QUERY_DISTINCT ; 237cdf0e10cSrcweir HelpID = HID_QUERY_DISTINCT ; 238cdf0e10cSrcweir Text [ en-US ] = "Distinct Values"; 239cdf0e10cSrcweir }; 240cdf0e10cSrcweir }; 241cdf0e10cSrcweir}; 242cdf0e10cSrcweirString STR_QUERY_HANDLETEXT 243cdf0e10cSrcweir{ 244cdf0e10cSrcweir Text [ en-US ] = "Field;Alias;Table;Sort;Visible;Function;Criterion;Or;Or"; 245cdf0e10cSrcweir}; 246cdf0e10cSrcweir 247cdf0e10cSrcweirString STR_QRY_TOO_MANY_COLUMNS 248cdf0e10cSrcweir{ 249cdf0e10cSrcweir Text [ en-US ] = "There are too many columns."; 250cdf0e10cSrcweir}; 251cdf0e10cSrcweir 252cdf0e10cSrcweirErrorBox ERR_QRY_CRITERIA_ON_ASTERISK 253cdf0e10cSrcweir{ 254cdf0e10cSrcweir Message [ en-US ] = "A condition cannot be applied to field [*]" ; 255cdf0e10cSrcweir}; 256cdf0e10cSrcweirString STR_QRY_TOO_LONG_STATEMENT 257cdf0e10cSrcweir{ 258cdf0e10cSrcweir Text [ en-US ] = "The SQL statement created is too long."; 259cdf0e10cSrcweir}; 260cdf0e10cSrcweirString STR_QRY_TOOCOMPLEX 261cdf0e10cSrcweir{ 262cdf0e10cSrcweir Text [ en-US ] = "Query is too complex" ; 263cdf0e10cSrcweir}; 264cdf0e10cSrcweirString STR_QRY_NOSELECT 265cdf0e10cSrcweir{ 266cdf0e10cSrcweir Text [ en-US ] = "Nothing has been selected." ; 267cdf0e10cSrcweir}; 268cdf0e10cSrcweirString STR_QRY_TOOMANYCOND 269cdf0e10cSrcweir{ 270cdf0e10cSrcweir Text [ en-US ] = "Too many search criteria" ; 271cdf0e10cSrcweir}; 272cdf0e10cSrcweirString STR_QRY_SYNTAX 273cdf0e10cSrcweir{ 274cdf0e10cSrcweir Text [ en-US ] = "SQL syntax error" ; 275cdf0e10cSrcweir}; 276cdf0e10cSrcweirErrorBox ERR_QRY_ORDERBY_ON_ASTERISK 277cdf0e10cSrcweir{ 278cdf0e10cSrcweir Message [ en-US ] = "[*] cannot be used as a sort criterion."; 279cdf0e10cSrcweir}; 280cdf0e10cSrcweirString STR_QRY_TOO_MANY_TABLES 281cdf0e10cSrcweir{ 282cdf0e10cSrcweir Text [ en-US ] = "There are too many tables."; 283cdf0e10cSrcweir}; 284cdf0e10cSrcweir 285cdf0e10cSrcweirString STR_QRY_NATIVE 286cdf0e10cSrcweir{ 287cdf0e10cSrcweir Text [ en-US ] = "The statement will not be applied when querying in the SQL dialect of the database." ; 288cdf0e10cSrcweir}; 289cdf0e10cSrcweirErrorBox ERR_QRY_AMB_FIELD 290cdf0e10cSrcweir{ 291cdf0e10cSrcweir Message [ en-US ] = "Field name not found or not unique" ; 292cdf0e10cSrcweir}; 293cdf0e10cSrcweirString STR_QRY_ILLEGAL_JOIN 294cdf0e10cSrcweir{ 295cdf0e10cSrcweir Text [ en-US ] = "Join could not be processed" ; 296cdf0e10cSrcweir}; 297cdf0e10cSrcweir 298cdf0e10cSrcweirString STR_SVT_SQL_SYNTAX_ERROR 299cdf0e10cSrcweir{ 300cdf0e10cSrcweir Text [ en-US ] = "Syntax error in SQL statement" ; 301cdf0e10cSrcweir}; 302cdf0e10cSrcweir 303cdf0e10cSrcweirString STR_QUERYDESIGN_NO_VIEW_SUPPORT 304cdf0e10cSrcweir{ 305cdf0e10cSrcweir Text [ en-US ] = "This database does not support table views."; 306cdf0e10cSrcweir}; 307cdf0e10cSrcweir 308cdf0e10cSrcweirString STR_NO_ALTER_VIEW_SUPPORT 309cdf0e10cSrcweir{ 310cdf0e10cSrcweir Text [ en-US ] = "This database does not support altering of existing table views."; 311cdf0e10cSrcweir}; 312cdf0e10cSrcweir 313cdf0e10cSrcweirString STR_QUERYDESIGN_NO_VIEW_ASK 314cdf0e10cSrcweir{ 315cdf0e10cSrcweir Text [ en-US ] = "Do you want to create a query instead?"; 316cdf0e10cSrcweir}; 317cdf0e10cSrcweir 318cdf0e10cSrcweirErrorBox ERR_QRY_NOSTATEMENT 319cdf0e10cSrcweir{ 320cdf0e10cSrcweir Message [ en-US ] = "No query could be created."; 321cdf0e10cSrcweir}; 322cdf0e10cSrcweir 323cdf0e10cSrcweirErrorBox ERR_QRY_NOCRITERIA 324cdf0e10cSrcweir{ 325cdf0e10cSrcweir Message [ en-US ] = "No query could be created because no fields were selected."; 326cdf0e10cSrcweir}; 327cdf0e10cSrcweir 328cdf0e10cSrcweir/* 329cdf0e10cSrcweir The menubar resource has become obsolete - you can now find the menubar definition at: <project>/uiconfig/dbquery/menubar/menubar.xml 330cdf0e10cSrcweir */ 331cdf0e10cSrcweir 332cdf0e10cSrcweirString STR_DATASOURCE_DELETED 333cdf0e10cSrcweir{ 334cdf0e10cSrcweir Text [ en-US ] = "The corresponding data source has been deleted. Therefore, data relevant to that data source cannot be saved."; 335cdf0e10cSrcweir}; 336cdf0e10cSrcweir 337cdf0e10cSrcweirString STR_QRY_COLUMN_NOT_FOUND 338cdf0e10cSrcweir{ 339cdf0e10cSrcweir Text [ en-US ] = "The column '$name$' is unknown."; 340cdf0e10cSrcweir}; 341cdf0e10cSrcweir 342cdf0e10cSrcweirString STR_QRY_JOIN_COLUMN_COMPARE 343cdf0e10cSrcweir{ 344cdf0e10cSrcweir Text [ en-US ] = "Columns can only be compared using '='."; 345cdf0e10cSrcweir}; 346cdf0e10cSrcweir 347cdf0e10cSrcweirString STR_QRY_LIKE_LEFT_NO_COLUMN 348cdf0e10cSrcweir{ 349cdf0e10cSrcweir Text [ en-US ] = "You must use a column name before 'LIKE'."; 350cdf0e10cSrcweir}; 351cdf0e10cSrcweir 352cdf0e10cSrcweirString STR_QRY_CHECK_CASESENSITIVE 353cdf0e10cSrcweir{ 354cdf0e10cSrcweir Text [ en-US ] = "The column could not be found. Please note that the database is case-sensitive."; 355cdf0e10cSrcweir}; 356cdf0e10cSrcweir 357cdf0e10cSrcweirString STR_QUERYDESIGN 358cdf0e10cSrcweir{ 359cdf0e10cSrcweir Text [ en-US ] = " - %PRODUCTNAME Base: Query Design"; 360cdf0e10cSrcweir}; 361cdf0e10cSrcweir 362cdf0e10cSrcweirString STR_VIEWDESIGN 363cdf0e10cSrcweir{ 364cdf0e10cSrcweir Text [ en-US ] = " - %PRODUCTNAME Base: View Design"; 365cdf0e10cSrcweir}; 366cdf0e10cSrcweir 367cdf0e10cSrcweirString STR_QUERY_SAVEMODIFIED 368cdf0e10cSrcweir{ 369cdf0e10cSrcweir Text [ en-US ] = "$object$ has been changed.\nDo you want to save the changes?" ; 370cdf0e10cSrcweir}; 371cdf0e10cSrcweir 372cdf0e10cSrcweirString STR_ERROR_PARSING_STATEMENT 373cdf0e10cSrcweir{ 3742d18be12SAndrea Pescetti Text [ en-US ] = "$object$ is based on an SQL command which could not be parsed."; 375cdf0e10cSrcweir}; 376cdf0e10cSrcweir 377cdf0e10cSrcweirString STR_INFO_OPENING_IN_SQL_VIEW 378cdf0e10cSrcweir{ 3792d18be12SAndrea Pescetti Text [ en-US ] = "$object$ will be opened in SQL view."; 380cdf0e10cSrcweir}; 381cdf0e10cSrcweir 382cdf0e10cSrcweirResource RSC_QUERY_OBJECT_TYPE 383cdf0e10cSrcweir{ 384cdf0e10cSrcweir String 1 385cdf0e10cSrcweir { 386cdf0e10cSrcweir Text [ en-US ] = "The table view"; 387cdf0e10cSrcweir }; 388cdf0e10cSrcweir String 2 389cdf0e10cSrcweir { 390cdf0e10cSrcweir Text [ en-US ] = "The query"; 391cdf0e10cSrcweir }; 392cdf0e10cSrcweir String 3 393cdf0e10cSrcweir { 394cdf0e10cSrcweir Text [ en-US ] = "The SQL statement"; 395cdf0e10cSrcweir }; 396cdf0e10cSrcweir}; 397cdf0e10cSrcweir 398cdf0e10cSrcweirString STR_STATEMENT_WITHOUT_RESULT_SET 399cdf0e10cSrcweir{ 400cdf0e10cSrcweir Text [ en-US ] = "The query does not create a result set, and thus cannot be part of another query."; 401cdf0e10cSrcweir}; 402cdf0e10cSrcweir 403cdf0e10cSrcweirString STR_NO_DATASOURCE_OR_CONNECTION 404cdf0e10cSrcweir{ 405cdf0e10cSrcweir Text [ en-US ] = "Both the ActiveConnection and the DataSourceName parameter are missing or wrong - cannot initialize the query designer."; 406cdf0e10cSrcweir}; 407