dbaccess/source/ui/dlg/advancedsettings.src

   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
  28 #include "dbaccess_helpid.hrc"
  29 #include "dbu_dlg.hrc"
  30 #include "advancedsettings.hrc"
  31
  32 //-------------------------------------------------------------------------
  33
  34 #define AUTO_DATAHANDLING(AUTO_Y)                                                   \
  35     FixedLine FL_DATAHANDLING                                                       \
  36     {                                                                               \
  37         Pos = MAP_APPFONT ( RELATED_CONTROLS , AUTO_Y ) ;                           \
  38         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 2*RELATED_CONTROLS , FIXEDTEXT_HEIGHT ) ;        \
  39         Text [ en-US ] = "Options";                                                 \
  40     };
  41
  42 //-------------------------------------------------------------------------
  43
  44 #define AUTO_SQL92CHECK(AUTO_Y)                                                     \
  45     CheckBox CB_SQL92CHECK                                                          \
  46     {                                                                               \
  47         Pos     = MAP_APPFONT ( 6 , AUTO_Y) ;                                       \
  48         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
  49         TabStop = TRUE ;                                                            \
  50         HelpId = HID_DSADMIN_SQL92CHECK;                                            \
  51         Text[ en-US ] = "Use SQL92 naming constraints";                             \
  52     };
  53
  54 //-------------------------------------------------------------------------
  55
  56 #define AUTO_APPENDTABLEALIAS(AUTO_Y)                                               \
  57     CheckBox CB_APPENDTABLEALIAS                                                    \
  58     {                                                                               \
  59         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
  60         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12  , CHECKBOX_HEIGHT ) ;          \
  61         TabStop = TRUE ;                                                            \
  62         HelpId = HID_DSADMIN_APPENDTABLEALIAS;                                      \
  63         Text[ en-US ] = "Append the table alias name on SELECT statements";         \
  64     };
  65
  66 //-------------------------------------------------------------------------
  67
  68 #define AUTO_AS_BEFORE_CORR_NAME(AUTO_Y)                                            \
  69     CheckBox CB_AS_BEFORE_CORR_NAME                                                 \
  70     {                                                                               \
  71         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
  72         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12  , CHECKBOX_HEIGHT ) ;          \
  73         TabStop = TRUE ;                                                            \
  74         HelpId = HID_DSADMIN_AS_BEFORE_CORRELATION_NAME;                            \
  75         Text[ en-US ] = "Use keyword AS before table alias names";                  \
  76     };
  77
  78 //-------------------------------------------------------------------------
  79
  80 #define AUTO_ENABLEOUTERJOIN(AUTO_Y)                                                \
  81     CheckBox CB_ENABLEOUTERJOIN                                                     \
  82     {                                                                               \
  83         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
  84         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
  85         TabStop = TRUE ;                                                            \
  86         HelpId = HID_DSADMIN_ENABLEOUTERJOIN;                                       \
  87         Text [ en-US ] = "Use Outer Join syntax '{OJ }'";                           \
  88     };
  89
  90
  91 //-------------------------------------------------------------------------
  92
  93 #define AUTO_IGNOREDRIVER_PRIV(AUTO_Y)                                              \
  94     CheckBox CB_IGNOREDRIVER_PRIV                                                   \
  95     {                                                                               \
  96         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
  97         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
  98         TabStop = TRUE ;                                                            \
  99         HelpId = HID_DSADMIN_IGNOREDRIVER_PRIV;                                     \
 100         Text[ en-US ] = "Ignore the privileges from the database driver";           \
 101     };
 102
 103 //-------------------------------------------------------------------------
 104
 105 #define AUTO_PARAMETERNAMESUBST(AUTO_Y)                                             \
 106     CheckBox CB_PARAMETERNAMESUBST                                                  \
 107     {                                                                               \
 108         Pos     = MAP_APPFONT ( 6 , AUTO_Y) ;                                       \
 109         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
 110         TabStop = TRUE ;                                                            \
 111         HelpId = HID_DSADMIN_PARAMETERNAMESUBST;                                    \
 112         Text[ en-US ] = "Replace named parameters with '?'";                        \
 113     };
 114
 115 //-------------------------------------------------------------------------
 116
 117 #define AUTO_SUPPRESVERSIONCOLUMN(AUTO_Y)                                           \
 118     CheckBox CB_SUPPRESVERSIONCL                                                    \
 119     {                                                                               \
 120         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 121         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
 122         TabStop = TRUE ;                                                            \
 123         HelpId = HID_DSADMIN_SUPPRESS_VERSIONCL;                                    \
 124         Text [ en-US ] = "Display version columns (when available)";                \
 125     };
 126
 127 //-------------------------------------------------------------------------
 128
 129 #define AUTO_CATALOG(AUTO_Y)                                                        \
 130     CheckBox CB_CATALOG                                                             \
 131     {                                                                               \
 132         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 133         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
 134         TabStop = TRUE ;                                                            \
 135         HelpId = HID_DSADMIN_CATALOG;                                               \
 136         Text [ en-US ] = "Use catalog name in SELECT statements";                   \
 137     };
 138
 139
 140 //-------------------------------------------------------------------------
 141
 142 #define AUTO_SCHEMA(AUTO_Y)                                                         \
 143     CheckBox CB_SCHEMA                                                              \
 144     {                                                                               \
 145         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 146         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
 147         TabStop = TRUE ;                                                            \
 148         HelpId = HID_DSADMIN_SCHEMA;                                                \
 149         Text [ en-US ] = "Use schema name in SELECT statements";                    \
 150     };
 151
 152 //-------------------------------------------------------------------------
 153
 154 #define AUTO_IGNOREINDEXAPPENDIX(AUTO_Y)                                            \
 155     CheckBox CB_IGNOREINDEXAPPENDIX                                                 \
 156     {                                                                               \
 157         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 158         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12  , CHECKBOX_HEIGHT ) ;          \
 159         TabStop = TRUE ;                                                            \
 160         HelpId = HID_DSADMIN_IGNOREINDEXAPPENDIX;                                   \
 161         Text[ en-US ] = "Create index with ASC or DESC statement";                  \
 162     };
 163
 164 //-------------------------------------------------------------------------
 165
 166 #define AUTO_DOSLINEENDS(AUTO_Y)                                                    \
 167     CheckBox CB_DOSLINEENDS                                                         \
 168     {                                                                               \
 169         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 170         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
 171         TabStop = TRUE ;                                                            \
 172         HelpId = HID_DSADMIN_DOSLINEENDS;                                           \
 173         Text [ en-US ] = "End text lines with CR+LF";                               \
 174     };
 175
 176 //-------------------------------------------------------------------------
 177 #define AUTO_IGNORECURRENCY(AUTO_Y)                                                 \
 178     CheckBox CB_IGNORECURRENCY                                                      \
 179     {                                                                               \
 180         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 181         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
 182         TabStop = TRUE ;                                                            \
 183         HelpId = HID_DSADMIN_IGNORECURRENCY;                                        \
 184         Text [ en-US ] = "Ignore currency field information";                       \
 185     };
 186
 187 //-------------------------------------------------------------------------
 188
 189 #define AUTO_CHECKREQUIRED(AUTO_Y)                                                  \
 190     CheckBox CB_CHECK_REQUIRED                                                      \
 191     {                                                                               \
 192         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 193         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
 194         TabStop = TRUE ;                                                            \
 195         HelpId = HID_DSADMIN_CHECK_REQUIRED_FIELDS;                                 \
 196         Text [ en-US ] = "Form data input checks for required fields";            \
 197     };
 198
 199 #define AUTO_ESCAPE_DATETIME(AUTO_Y)                                                \
 200     CheckBox CB_ESCAPE_DATETIME                                                     \
 201     {                                                                               \
 202         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 203         Size    = MAP_APPFONT ( ADVANCED_PAGE_X -12 , CHECKBOX_HEIGHT ) ;           \
 204         TabStop = TRUE ;                                                            \
 205         HelpId = HID_DSADMIN_ESCAPE_DATETIME;                                       \
 206         Text [ en-US ] = "Use ODBC conformant date/time literals";                  \
 207     };
 208
 209
 210 #define AUTO_PRIMARY_KEY_SUPPORT(AUTO_Y)                                            \
 211     CheckBox CB_PRIMARY_KEY_SUPPORT                                                 \
 212     {                                                                               \
 213         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 214         Size    = MAP_APPFONT ( ADVANCED_PAGE_X - 12 , CHECKBOX_HEIGHT ) ;          \
 215         TabStop = TRUE ;                                                            \
 216         HelpId = HID_DSADMIN_PRIMARY_KEY_SUPPORT;                                   \
 217         Text [ en-US ] = "Supports primary keys";                                   \
 218     };
 219
 220 #define AUTO_RESPECTRESULTSETTYPE(AUTO_Y)                                            \
 221     CheckBox CB_RESPECTRESULTSETTYPE                                                 \
 222     {                                                                               \
 223         Pos     = MAP_APPFONT ( 6 , AUTO_Y ) ;                                      \
 224         Size    = MAP_APPFONT ( ADVANCED_PAGE_X - 12 , CHECKBOX_HEIGHT ) ;          \
 225         TabStop = TRUE ;                                                            \
 226         HelpId = HID_DSADMIN_RESPECTRESULTSETTYPE;                                   \
 227         Text [ en-US ] = "Respect the result set type from the database driver";                                   \
 228     };
 229
 230
 231 //-------------------------------------------------------------------------
 232
 233 #define WORKAROUND                                                                  \
 234         StringList [ en-US ] =                                                      \
 235         {                                                                           \
 236             < "Default" ; Default ; > ;                                             \
 237             < "SQL" ; Default ; > ;                                                 \
 238             < "Mixed" ; Default ; > ;                                               \
 239             < "MS Access" ; Default ; > ;                                           \
 240         };
 241
 242
 243 #define AUTO_BOOLEANCOMPARISON(AUTO_Y)                                              \
 244     FixedText FT_BOOLEANCOMPARISON                                                  \
 245     {                                                                               \
 246         Pos     = MAP_APPFONT ( START_X , AUTO_Y + ( LISTBOX_HEIGHT - CHECKBOX_HEIGHT ) / 2 ) ;   \
 247         Size    = MAP_APPFONT ( 100 , CHECKBOX_HEIGHT );                            \
 248         Text [ en-US ] = "Comparison of Boolean values";                            \
 249     };                                                                              \
 250     ListBox LB_BOOLEANCOMPARISON                                                    \
 251     {                                                                               \
 252         Pos     = MAP_APPFONT ( START_X + 100, AUTO_Y ) ;                           \
 253         Size    = MAP_APPFONT ( 60 , LISTBOX_HEIGHT ) ;                             \
 254         TabStop = TRUE ;                                                            \
 255         SvLook = TRUE;                                                              \
 256         DropDown = TRUE;                                                            \
 257         Border = TRUE;                                                              \
 258         HelpId = HID_DSADMIN_BOOLEANCOMPARISON;                                     \
 259         WORKAROUND                                                                  \
 260     };                                                                              \
 261
 262 #define AUTO_MAXROWSCAN(AUTO_Y)                                              \
 263     FixedText FT_MAXROWSCAN                                                  \
 264     {                                                                               \
 265         Pos     = MAP_APPFONT ( START_X , AUTO_Y + ( LISTBOX_HEIGHT - CHECKBOX_HEIGHT ) / 2 ) ;   \
 266         Size    = MAP_APPFONT ( 100 , CHECKBOX_HEIGHT );                            \
 267         Text [ en-US ] = "Rows to scan column types";                               \
 268     };                                                                              \
 269     NumericField NF_MAXROWSCAN                                                      \
 270     {                                                                               \
 271         Pos     = MAP_APPFONT ( START_X + 100, AUTO_Y ) ;                           \
 272         Size    = MAP_APPFONT ( 60 , EDIT_HEIGHT ) ;                                \
 273         TabStop = TRUE ;                                                            \
 274         NoThousandSep = TRUE;                                                       \
 275         Border = TRUE;                                                              \
 276         HelpId = HID_DSADMIN_MAXROWSCAN;                                            \
 277     };                                                                              \
 278
 279
 280 //-------------------------------------------------------------------------
 281
 282 TabPage PAGE_GENERATED_VALUES
 283 {
 284     HelpID = "dbaccess:TabPage:PAGE_GENERATED_VALUES";
 285     SVLook = TRUE ;
 286     Pos = MAP_APPFONT ( 0 , 0 ) ;
 287     Size = MAP_APPFONT ( ADVANCED_PAGE_X , ADVANCED_PAGE_Y ) ;
 288     Hide = TRUE;
 289
 290     FixedLine FL_SEPARATORAUTO
 291     {
 292         Pos = MAP_APPFONT ( 4, UNRELATED_CONTROLS ) ;
 293         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 2*RELATED_CONTROLS , FIXEDTEXT_HEIGHT ) ;
 294         Text [ en-US ] = "Settings";
 295     };
 296
 297     CheckBox CB_RETRIEVE_AUTO
 298     {
 299         Pos     = MAP_APPFONT ( 6 , UNRELATED_CONTROLS + FIXEDTEXT_HEIGHT + RELATED_CONTROLS) ;
 300         Size    = MAP_APPFONT ( ADVANCED_PAGE_X - 2*UNRELATED_CONTROLS , CHECKBOX_HEIGHT ) ;
 301         TabStop = TRUE ;
 302         HelpId = HID_DSADMIN_AUTORETRIEVEENABLED;
 303         Text [ en-US ] = "Re~trieve generated values";
 304     };
 305
 306     FixedText FT_AUTOINCREMENTVALUE
 307     {
 308         Pos     = MAP_APPFONT ( 15 , UNRELATED_CONTROLS + FIXEDTEXT_HEIGHT + 2*RELATED_CONTROLS + CHECKBOX_HEIGHT ) ;
 309         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 15 - 6 , FIXEDTEXT_HEIGHT ) ;
 310         Text[ en-US ] = "~Auto-increment statement";
 311     };
 312
 313     Edit ET_AUTOINCREMENTVALUE
 314     {
 315         Border = TRUE ;
 316         Pos     = MAP_APPFONT ( 15 , UNRELATED_CONTROLS + 2*FIXEDTEXT_HEIGHT + CHECKBOX_HEIGHT + 3*RELATED_CONTROLS ) ;
 317         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 15 - 2*UNRELATED_CONTROLS , EDIT_HEIGHT ) ;
 318         TabStop = TRUE ;
 319         HelpId = HID_DSADMIN_AUTOINCREMENTVALUE;
 320     };
 321
 322     FixedText FT_RETRIEVE_AUTO
 323     {
 324         Pos     = MAP_APPFONT ( 15 , UNRELATED_CONTROLS + 2*FIXEDTEXT_HEIGHT + CHECKBOX_HEIGHT + 4*RELATED_CONTROLS + EDIT_HEIGHT) ;
 325         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 15 - 6 , 10 ) ;
 326         Text [ en-US ] = "~Query of generated values";
 327     };
 328
 329     Edit ET_RETRIEVE_AUTO
 330     {
 331         Border = TRUE ;
 332         Pos     = MAP_APPFONT ( 15 , UNRELATED_CONTROLS + 3*FIXEDTEXT_HEIGHT + CHECKBOX_HEIGHT + 5*RELATED_CONTROLS + EDIT_HEIGHT ) ;
 333         Size = MAP_APPFONT ( ADVANCED_PAGE_X - 15 - 2*UNRELATED_CONTROLS, EDIT_HEIGHT ) ;
 334         TabStop = TRUE ;
 335         HelpId = HID_DSADMIN_RETRIEVE_AUTO;
 336     };
 337 };
 338
 339 //-------------------------------------------------------------------------
 340
 341 TabPage PAGE_ADVANCED_SETTINGS_SPECIAL
 342 {
 343     HelpID = "dbaccess:TabPage:PAGE_ADVANCED_SETTINGS_SPECIAL";
 344     SVLook = TRUE ;
 345     Pos = MAP_APPFONT ( 0 , 0 ) ;
 346     Size = MAP_APPFONT ( ADVANCED_PAGE_X , ADVANCED_PAGE_Y ) ;
 347     Hide = TRUE;
 348     AUTO_DATAHANDLING(            RELATED_CONTROLS )
 349     AUTO_SQL92CHECK(            1*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +                      RELATED_CONTROLS )
 350     AUTO_APPENDTABLEALIAS(      2*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  1*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 351     AUTO_AS_BEFORE_CORR_NAME(   3*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  2*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 352     AUTO_ENABLEOUTERJOIN(       4*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  3*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 353     AUTO_IGNOREDRIVER_PRIV(     5*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  4*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 354     AUTO_PARAMETERNAMESUBST(    6*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  5*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 355     AUTO_SUPPRESVERSIONCOLUMN(  7*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  6*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 356     AUTO_CATALOG(               8*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  7*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 357     AUTO_SCHEMA(                9*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  8*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 358     AUTO_IGNOREINDEXAPPENDIX(  10*RELATED_CONTROLS + FIXEDTEXT_HEIGHT +  9*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 359     AUTO_DOSLINEENDS(          11*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 10*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 360     AUTO_CHECKREQUIRED(        12*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 11*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 361     AUTO_IGNORECURRENCY(       13*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 12*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 362     AUTO_ESCAPE_DATETIME(      14*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 14*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 363     AUTO_PRIMARY_KEY_SUPPORT(  15*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 15*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 364     AUTO_RESPECTRESULTSETTYPE( 16*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 16*CHECKBOX_HEIGHT + RELATED_CONTROLS )
 365     AUTO_BOOLEANCOMPARISON(    17*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 15*CHECKBOX_HEIGHT + RELATED_CONTROLS + ( LISTBOX_HEIGHT - CHECKBOX_HEIGHT ) / 2 )
 366     AUTO_MAXROWSCAN(           18*RELATED_CONTROLS + FIXEDTEXT_HEIGHT + 15*CHECKBOX_HEIGHT + RELATED_CONTROLS + ( LISTBOX_HEIGHT - CHECKBOX_HEIGHT ) / 2 )
 367 };
 368
 369 //-------------------------------------------------------------------------
 370
 371 TabDialog DLG_DATABASE_ADVANCED
 372 {
 373     OutputSize = TRUE ;
 374     SVLook = TRUE ;
 375     Moveable = TRUE ;
 376     Closeable = TRUE ;
 377     Hide = TRUE;
 378     HelpId = HID_DSADMIN_ADVANCED;
 379
 380     TabControl 1
 381     {
 382         OutputSize = TRUE ;
 383         HelpId = HID_DSADMIN_TABCONTROL;
 384     };
 385
 386     String STR_GENERATED_VALUE
 387     {
 388         Text [ en-US ] = "Generated Values";
 389     };
 390
 391     String STR_DS_BEHAVIOUR
 392     {
 393         Text [ en-US ] = "Special Settings";
 394     };
 395
 396     Text [ en-US ] = "Advanced Settings" ;
 397 };