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