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