Update ooo320-m1
[ooovba.git] / dbaccess / source / ui / dlg / advancedsettings.src
blob13ed94809045a031f43747662f42d1159ae17274
1 /*************************************************************************
2  *
3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4  * 
5  * Copyright 2008 by Sun Microsystems, Inc.
6  *
7  * OpenOffice.org - a multi-platform office productivity suite
8  *
9  * $RCSfile: advancedsettings.src,v $
10  * $Revision: 1.6 $
11  *
12  * This file is part of OpenOffice.org.
13  *
14  * OpenOffice.org is free software: you can redistribute it and/or modify
15  * it under the terms of the GNU Lesser General Public License version 3
16  * only, as published by the Free Software Foundation.
17  *
18  * OpenOffice.org is distributed in the hope that it will be useful,
19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
21  * GNU Lesser General Public License version 3 for more details
22  * (a copy is included in the LICENSE file that accompanied this code).
23  *
24  * You should have received a copy of the GNU Lesser General Public License
25  * version 3 along with OpenOffice.org.  If not, see
26  * <http://www.openoffice.org/license.html>
27  * for a copy of the LGPLv3 License.
28  *
29  ************************************************************************/
31 #include "dbaccess_helpid.hrc"
32 #include "dbu_dlg.hrc"
33 #include "advancedsettings.hrc"
35 //-------------------------------------------------------------------------
37 #define AUTO_DATAHANDLING(AUTO_Y)                                                   \
38     FixedLine FL_DATAHANDLING                                                       \
39     {                                                                               \
40         Pos = MAP_APPFONT ( RELATED_CONTROLS , AUTO_Y ) ;                           \
41         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 2*RELATED_CONTROLS , FIXEDTEXT_HEIGHT ) ;        \
42         Text [ en-US ] = "Options";                                                 \
43     };
45 //-------------------------------------------------------------------------
47 #define AUTO_SQL92CHECK(AUTO_Y)                                                     \
48     CheckBox CB_SQL92CHECK                                                          \
49     {                                                                               \
50         Pos     = MAP_APPFONT ( 6 , AUTO_Y) ;                                       \
51         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
52         TabStop = TRUE ;                                                            \
53         HelpId = HID_DSADMIN_SQL92CHECK;                                            \
54         Text[ en-US ] = "Use SQL92 naming constraints";                             \
55     };
57 //-------------------------------------------------------------------------
59 #define AUTO_APPENDTABLEALIAS(AUTO_Y)                                               \
60     CheckBox CB_APPENDTABLEALIAS                                                    \
61     {                                                                               \
62         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
63         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12  , CHECKBOX_HEIGHT ) ;          \
64         TabStop = TRUE ;                                                            \
65         HelpId = HID_DSADMIN_APPENDTABLEALIAS;                                      \
66         Text[ en-US ] = "Append the table alias name on SELECT statements";         \
67     };
69 //-------------------------------------------------------------------------
71 #define AUTO_AS_BEFORE_CORR_NAME(AUTO_Y)                                            \
72     CheckBox CB_AS_BEFORE_CORR_NAME                                                 \
73     {                                                                               \
74         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
75         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12  , CHECKBOX_HEIGHT ) ;          \
76         TabStop = TRUE ;                                                            \
77         HelpId = HID_DSADMIN_AS_BEFORE_CORRELATION_NAME;                            \
78         Text[ en-US ] = "Use keyword AS before table alias names";                  \
79     };
81 //-------------------------------------------------------------------------
83 #define AUTO_ENABLEOUTERJOIN(AUTO_Y)                                                \
84     CheckBox CB_ENABLEOUTERJOIN                                                     \
85     {                                                                               \
86         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
87         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
88         TabStop = TRUE ;                                                            \
89         HelpId = HID_DSADMIN_ENABLEOUTERJOIN;                                       \
90         Text [ en-US ] = "Use Outer Join syntax '{OJ }'";                           \
91     };
94 //-------------------------------------------------------------------------
96 #define AUTO_IGNOREDRIVER_PRIV(AUTO_Y)                                              \
97     CheckBox CB_IGNOREDRIVER_PRIV                                                   \
98     {                                                                               \
99         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
100         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
101         TabStop = TRUE ;                                                            \
102         HelpId = HID_DSADMIN_IGNOREDRIVER_PRIV;                                     \
103         Text[ en-US ] = "Ignore the privileges from the database driver";           \
104     };
106 //-------------------------------------------------------------------------
108 #define AUTO_PARAMETERNAMESUBST(AUTO_Y)                                             \
109     CheckBox CB_PARAMETERNAMESUBST                                                  \
110     {                                                                               \
111         Pos     = MAP_APPFONT ( 6 , AUTO_Y) ;                                       \
112         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
113         TabStop = TRUE ;                                                            \
114         HelpId = HID_DSADMIN_PARAMETERNAMESUBST;                                    \
115         Text[ en-US ] = "Replace named parameters with '?'";                        \
116     };
118 //-------------------------------------------------------------------------
120 #define AUTO_SUPPRESVERSIONCOLUMN(AUTO_Y)                                           \
121     CheckBox CB_SUPPRESVERSIONCL                                                    \
122     {                                                                               \
123         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
124         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
125         TabStop = TRUE ;                                                            \
126         HelpId = HID_DSADMIN_SUPPRESS_VERSIONCL;                                    \
127         Text [ en-US ] = "Display version columns (when available)";                \
128     };
130 //-------------------------------------------------------------------------
132 #define AUTO_CATALOG(AUTO_Y)                                                        \
133     CheckBox CB_CATALOG                                                             \
134     {                                                                               \
135         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
136         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
137         TabStop = TRUE ;                                                            \
138         HelpId = HID_DSADMIN_CATALOG;                                               \
139         Text [ en-US ] = "Use catalog name in SELECT statements";                   \
140     };
143 //-------------------------------------------------------------------------
145 #define AUTO_SCHEMA(AUTO_Y)                                                         \
146     CheckBox CB_SCHEMA                                                              \
147     {                                                                               \
148         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
149         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
150         TabStop = TRUE ;                                                            \
151         HelpId = HID_DSADMIN_SCHEMA;                                                \
152         Text [ en-US ] = "Use schema name in SELECT statements";                    \
153     };
155 //-------------------------------------------------------------------------
157 #define AUTO_IGNOREINDEXAPPENDIX(AUTO_Y)                                            \
158     CheckBox CB_IGNOREINDEXAPPENDIX                                                 \
159     {                                                                               \
160         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
161         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12  , CHECKBOX_HEIGHT ) ;          \
162         TabStop = TRUE ;                                                            \
163         HelpId = HID_DSADMIN_IGNOREINDEXAPPENDIX;                                   \
164         Text[ en-US ] = "Create index with ASC or DESC statement";                  \
165     };
167 //-------------------------------------------------------------------------
169 #define AUTO_DOSLINEENDS(AUTO_Y)                                                    \
170     CheckBox CB_DOSLINEENDS                                                         \
171     {                                                                               \
172         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
173         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
174         TabStop = TRUE ;                                                            \
175         HelpId = HID_DSADMIN_DOSLINEENDS;                                           \
176         Text [ en-US ] = "End text lines with CR+LF";                               \
177     };
179 //-------------------------------------------------------------------------
180 #define AUTO_IGNORECURRENCY(AUTO_Y)                                                                                             \
181     CheckBox CB_IGNORECURRENCY                                                                                                          \
182     {                                                                                                                                                           \
183         Pos             = MAP_APPFONT ( 6 , AUTO_Y ) ;                                                                          \
184         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;                       \
185         TabStop = TRUE ;                                                                                                                        \
186         HelpId = HID_DSADMIN_IGNORECURRENCY;                                                                            \
187         Text [ en-US ] = "Ignore currency field information";                                           \
188     };
190 //-------------------------------------------------------------------------
192 #define AUTO_CHECKREQUIRED(AUTO_Y)                                                  \
193     CheckBox CB_CHECK_REQUIRED                                                      \
194     {                                                                               \
195         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
196         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
197         TabStop = TRUE ;                                                            \
198         HelpId = HID_DSADMIN_CHECK_REQUIRED_FIELDS;                                 \
199         Text [ en-US ] = "Form data input checks for required fields";            \
200     };
202 #define AUTO_ESCAPE_DATETIME(AUTO_Y)                                                \
203     CheckBox CB_ESCAPE_DATETIME                                                     \
204     {                                                                               \
205         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
206         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
207         TabStop = TRUE ;                                                            \
208         HelpId = HID_DSADMIN_ESCAPE_DATETIME;                                       \
209         Text [ en-US ] = "Use ODBC conformant date/time literals";            \
210     };
213 //-------------------------------------------------------------------------
215 #define WORKAROUND                                                                  \
216         StringList [ en-US ] =                                                      \
217         {                                                                           \
218             < "Default" ; Default ; > ;                                             \
219             < "SQL" ; Default ; > ;                                                 \
220             < "Mixed" ; Default ; > ;                                               \
221             < "MS Access" ; Default ; > ;                                           \
222         };                                                                          
225 #define AUTO_BOOLEANCOMPARISON(AUTO_Y)                                              \
226     FixedText FT_BOOLEANCOMPARISON                                                  \
227     {                                                                               \
228         Pos     = MAP_APPFONT ( START_X , AUTO_Y + ( LISTBOX_HEIGHT - CHECKBOX_HEIGHT ) / 2 ) ;   \
229         Size    = MAP_APPFONT ( 100 , CHECKBOX_HEIGHT );                            \
230         Text [ en-US ] = "Comparison of Boolean values";                            \
231     };                                                                              \
232     ListBox LB_BOOLEANCOMPARISON                                                    \
233     {                                                                               \
234         Pos     = MAP_APPFONT ( START_X + 100, AUTO_Y ) ;                           \
235         Size    = MAP_APPFONT ( 60 , LISTBOX_HEIGHT ) ;                             \
236         TabStop = TRUE ;                                                            \
237         SvLook = TRUE;                                                              \
238         DropDown = TRUE;                                                            \
239         Border = TRUE;                                                              \
240         HelpId = HID_DSADMIN_BOOLEANCOMPARISON;                                     \
241         WORKAROUND                                                                  \
242     };                                                                              \
244 //-------------------------------------------------------------------------
246 TabPage PAGE_GENERATED_VALUES
248     SVLook = TRUE ;
249     Pos = MAP_APPFONT ( 0 , 0 ) ;
250     Size = MAP_APPFONT ( ADVANCED_PAGE_X , ADVANCED_PAGE_Y ) ;
251     Hide = TRUE;
253     FixedLine FL_SEPARATORAUTO
254     {
255         Pos = MAP_APPFONT ( 4, UNRELATED_CONTROLS ) ;
256         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 2*RELATED_CONTROLS , FIXEDTEXT_HEIGHT ) ;
257         Text [ en-US ] = "Settings";
258     };
260     CheckBox CB_RETRIEVE_AUTO
261     {
262         Pos     = MAP_APPFONT ( 6 , UNRELATED_CONTROLS + FIXEDTEXT_HEIGHT + RELATED_CONTROLS) ;
263         Size    = MAP_APPFONT ( ADVANCED_PAGE_X - 2*UNRELATED_CONTROLS , CHECKBOX_HEIGHT ) ;
264         TabStop = TRUE ;
265         HelpId = HID_DSADMIN_AUTORETRIEVEENABLED;
266         Text [ en-US ] = "Re~trieve generated values";
267     };
269     FixedText FT_AUTOINCREMENTVALUE
270     {
271         Pos     = MAP_APPFONT ( 15 , UNRELATED_CONTROLS + FIXEDTEXT_HEIGHT + 2*RELATED_CONTROLS + CHECKBOX_HEIGHT ) ;
272         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 15 - 6 , FIXEDTEXT_HEIGHT ) ;
273         Text[ en-US ] = "~Auto-increment statement";
274     };
276     Edit ET_AUTOINCREMENTVALUE
277     {
278         Border = TRUE ;
279         Pos     = MAP_APPFONT ( 15 , UNRELATED_CONTROLS + 2*FIXEDTEXT_HEIGHT + CHECKBOX_HEIGHT + 3*RELATED_CONTROLS ) ;
280         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 15 - 2*UNRELATED_CONTROLS , EDIT_HEIGHT ) ;
281         TabStop = TRUE ;
282         HelpId = HID_DSADMIN_AUTOINCREMENTVALUE;
283     };
285     FixedText FT_RETRIEVE_AUTO
286     {
287         Pos     = MAP_APPFONT ( 15 , UNRELATED_CONTROLS + 2*FIXEDTEXT_HEIGHT + CHECKBOX_HEIGHT + 4*RELATED_CONTROLS + EDIT_HEIGHT) ;
288         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 15 - 6 , 10 ) ;
289         Text [ en-US ] = "~Query of generated values";
290     };
292     Edit ET_RETRIEVE_AUTO
293     {
294         Border = TRUE ;
295         Pos     = MAP_APPFONT ( 15 , UNRELATED_CONTROLS + 3*FIXEDTEXT_HEIGHT + CHECKBOX_HEIGHT + 5*RELATED_CONTROLS + EDIT_HEIGHT ) ;
296         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 15 - 2*UNRELATED_CONTROLS, EDIT_HEIGHT ) ;
297         TabStop = TRUE ;
298         HelpId = HID_DSADMIN_RETRIEVE_AUTO;
299     };
302 //-------------------------------------------------------------------------
304 TabPage PAGE_ADVANCED_SETTINGS_SPECIAL
306     SVLook = TRUE ;
307     Pos = MAP_APPFONT ( 0 , 0 ) ;
308     Size = MAP_APPFONT ( ADVANCED_PAGE_X , ADVANCED_PAGE_Y ) ;
309     Hide = TRUE;
310     AUTO_DATAHANDLING(            RELATED_CONTROLS )
311     AUTO_SQL92CHECK(            1*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +                      RELATED_CONTROLS )
312     AUTO_APPENDTABLEALIAS(      2*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  1*CHECKBOX_HEIGHT + RELATED_CONTROLS )
313     AUTO_AS_BEFORE_CORR_NAME(   3*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  2*CHECKBOX_HEIGHT + RELATED_CONTROLS )
314     AUTO_ENABLEOUTERJOIN(       4*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  3*CHECKBOX_HEIGHT + RELATED_CONTROLS )
315     AUTO_IGNOREDRIVER_PRIV(     5*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  4*CHECKBOX_HEIGHT + RELATED_CONTROLS )
316     AUTO_PARAMETERNAMESUBST(    6*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  5*CHECKBOX_HEIGHT + RELATED_CONTROLS )
317     AUTO_SUPPRESVERSIONCOLUMN(  7*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  6*CHECKBOX_HEIGHT + RELATED_CONTROLS )
318     AUTO_CATALOG(               8*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  7*CHECKBOX_HEIGHT + RELATED_CONTROLS )
319     AUTO_SCHEMA(                9*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  8*CHECKBOX_HEIGHT + RELATED_CONTROLS )
320     AUTO_IGNOREINDEXAPPENDIX(  10*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  9*CHECKBOX_HEIGHT + RELATED_CONTROLS )
321     AUTO_DOSLINEENDS(          11*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 10*CHECKBOX_HEIGHT + RELATED_CONTROLS )
322     AUTO_CHECKREQUIRED(        12*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 11*CHECKBOX_HEIGHT + RELATED_CONTROLS )
323     AUTO_IGNORECURRENCY(       13*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 12*CHECKBOX_HEIGHT + RELATED_CONTROLS )
324     AUTO_ESCAPE_DATETIME(       14*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 14*CHECKBOX_HEIGHT + RELATED_CONTROLS )
325     AUTO_BOOLEANCOMPARISON(    15*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 13*CHECKBOX_HEIGHT + RELATED_CONTROLS + ( LISTBOX_HEIGHT - CHECKBOX_HEIGHT ) / 2 )
328 //-------------------------------------------------------------------------
330 TabDialog DLG_DATABASE_ADVANCED
331 {                                                                           
332     OutputSize = TRUE ;
333     SVLook = TRUE ;
334     Moveable = TRUE ;
335     Closeable = TRUE ;
336     Hide = TRUE;
337     HelpId = HID_DSADMIN_ADVANCED;
338     
339     TabControl 1
340     {
341         OutputSize = TRUE ;
342         HelpId = HID_DSADMIN_TABCONTROL;
343         SingleLine=TRUE;
344     };
345     
346     String STR_GENERATED_VALUE
347     {
348         Text [ en-US ] = "Generated Values";
349     };
350     
351     String STR_DS_BEHAVIOUR
352     {
353         Text [ en-US ] = "Special Settings";
354     };
355     
356     Text [ en-US ] = "Advanced Properties" ;