xref: /trunk/main/dbaccess/source/ui/querydesign/query.src (revision cdf0e10c4e3984b49a9502b011690b615761d4a3)
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