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    Text [ x-comment ] = "For $object$, one of the values of the RSC_QUERY_OBJECT_TYPE resource will be inserted.";
371};
372
373String STR_ERROR_PARSING_STATEMENT
374{
375    Text [ en-US ] = "$object$ is based on an SQL command which could not be parsed.";
376    Text [ x-comment ] = "For $object$, one of the values of the RSC_QUERY_OBJECT_TYPE resource "
377        "(except \"SQL command\", which doesn't make sense here) will be inserted.";
378};
379
380String STR_INFO_OPENING_IN_SQL_VIEW
381{
382    Text [ en-US ] = "$object$ will be opened in SQL view.";
383    Text [ x-comment ] = "For $object$, one of the values of the RSC_QUERY_OBJECT_TYPE resource "
384        "(except \"SQL command\", which doesn't make sense here) will be inserted.";
385};
386
387Resource RSC_QUERY_OBJECT_TYPE
388{
389    String 1
390    {
391        Text [ en-US ] = "The table view";
392    };
393    String 2
394    {
395        Text [ en-US ] = "The query";
396    };
397    String 3
398    {
399        Text [ en-US ] = "The SQL statement";
400    };
401};
402
403String STR_STATEMENT_WITHOUT_RESULT_SET
404{
405    Text [ en-US ] = "The query does not create a result set, and thus cannot be part of another query.";
406};
407
408String STR_NO_DATASOURCE_OR_CONNECTION
409{
410    Text [ en-US ] = "Both the ActiveConnection and the DataSourceName parameter are missing or wrong - cannot initialize the query designer.";
411};
412