diff options
Diffstat (limited to 'helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp')
-rwxr-xr-x | helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp | 97 |
1 files changed, 97 insertions, 0 deletions
diff --git a/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp b/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp new file mode 100755 index 0000000000..2031237c01 --- /dev/null +++ b/helpcontent2/source/text/shared/explorer/database/dabaadvpropdat.xhp @@ -0,0 +1,97 @@ +<?xml version="1.0" encoding="UTF-8"?>
+<!--*********************************************************************** + * + * The Contents of this file are made available subject to the terms of + * either of the following licenses + * + * - GNU Lesser General Public License Version 2.1 + * - Sun Industry Standards Source License Version 1.1 + * + * Sun Microsystems Inc., October, 2000 + * + * GNU Lesser General Public License Version 2.1 + * ============================================= + * Copyright 2000 by Sun Microsystems, Inc. + * 901 San Antonio Road, Palo Alto, CA 94303, USA + * + * This library is free software; you can redistribute it and/or + * modify it under the terms of the GNU Lesser General Public + * License version 2.1, as published by the Free Software Foundation. + * + * This library is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU + * Lesser General Public License for more details. + * + * You should have received a copy of the GNU Lesser General Public + * License along with this library; if not, write to the Free Software + * Foundation, Inc., 59 Temple Place, Suite 330, Boston, + * MA 02111-1307 USA + * + * + * Sun Industry Standards Source License Version 1.1 + * ================================================= + * The contents of this file are subject to the Sun Industry Standards + * Source License Version 1.1 (the "License"); You may not use this file + * except in compliance with the License. You may obtain a copy of the + * License at http://www.openoffice.org/license.html. + * + * Software provided under this License is provided on an "AS IS" basis, + * WITHOUT WARRUNTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, + * WITHOUT LIMITATION, WARRUNTIES THAT THE SOFTWARE IS FREE OF DEFECTS, + * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. + * See the License for the specific provisions governing your rights and + * obligations concerning the Software. + * + * The Initial Developer of the Original Code is: Sun Microsystems, Inc.. + * + * Copyright: 2000 by Sun Microsystems, Inc. + * + * All Rights Reserved. + * + * Contributor(s): _______________________________________ + * + * + ************************************************************************-->
+
+<helpdocument version="1.0">
+<meta>
+<topic id="textsharedexplorerdatabasedabaadvpropdatxml" indexer="include" status="PUBLISH">
+<title id="tit" xml-lang="en-US">Data Handling</title>
+<filename>text/shared/explorer/database/dabaadvpropdat.xhp</filename>
+</topic>
+<history>
+<created date="2004-07-30T11:21:39">Advanced Properties dialog Data handling tab page</created>
+<lastedited date="2004-08-12T10:33:39">dedr: reviewed</lastedited>
+</history>
+</meta>
+<body>
+<section id="data">
+<paragraph role="heading" id="par_idN10556" xml-lang="en-US" level="1" l10n="NEW"><link href="text/shared/explorer/database/dabaadvpropdat.xhp">Data Handling</link></paragraph>
+<paragraph role="paragraph" id="par_idN10566" xml-lang="en-US" l10n="NEW">Specifies the way you can work with data in a database.<comment>UFI: some text copied from shared\explorer\database\11020000.xhp</comment></paragraph>
+</section>
+<paragraph role="heading" id="par_idN1057B" xml-lang="en-US" level="2" l10n="NEW"><comment>how to get this: Edit Database AdvancedProp</comment></paragraph>
+<paragraph role="heading" id="par_idN10590" xml-lang="en-US" level="2" l10n="NEW">Use SQL92 naming constraints</paragraph>
+<paragraph role="paragraph" id="par_idN10594" xml-lang="en-US" l10n="NEW">Only allows characters that conform to the SQL92 naming convention in a name in a data source. All other characters are rejected. Each name must begin with a lowercase letter, an uppercase letter, or an underscore ( _ ). The remaining characters can be ASCII letters, numbers, and underscores.</paragraph>
+<paragraph role="heading" id="par_idN1059E" xml-lang="en-US" level="2" l10n="NEW">Append the table alias name in SELECT statements</paragraph>
+<paragraph role="paragraph" id="par_idN105A2" xml-lang="en-US" l10n="NEW">Appends the alias to the table name in SELECT statements.</paragraph>
+<paragraph role="heading" id="par_idN105A5" xml-lang="en-US" level="2" l10n="NEW">Use Outer Join syntax '{OJ }'</paragraph>
+<paragraph role="paragraph" id="par_idN105A9" xml-lang="en-US" l10n="NEW">Use escape sequences for outer joins. The syntax for this escape sequence is {oj outer-join}<comment>copied from shared\explorer\database\02010100.xhp</comment></paragraph>
+<paragraph role="paragraph" id="par_idN105BE" xml-lang="en-US" l10n="NEW">Example:</paragraph>
+<paragraph role="example" id="par_idN105C1" xml-lang="en-US" l10n="NEW">select Article.* from {oj item LEFT OUTER JOIN orders ON item.no=orders.ANR}</paragraph>
+<paragraph role="heading" id="par_idN105C4" xml-lang="en-US" level="2" l10n="NEW">Ignore the privileges from the database driver</paragraph>
+<paragraph role="paragraph" id="par_idN105C8" xml-lang="en-US" l10n="NEW">Ignores access privileges that are provided by the database driver.</paragraph>
+<paragraph role="heading" id="par_idN105CB" xml-lang="en-US" level="2" l10n="NEW">Replace named parameters with ?</paragraph>
+<paragraph role="paragraph" id="par_idN105CF" xml-lang="en-US" l10n="NEW">Replaces named parameters in a data source with a question mark (?).</paragraph>
+<paragraph role="heading" id="par_idN105D2" xml-lang="en-US" level="2" l10n="NEW">Display version columns (when available)</paragraph>
+<paragraph role="paragraph" id="par_idN105D6" xml-lang="en-US" l10n="NEW">Some databases assign version numbers to fields to track changes to records. The version number of a field is incremented by one each time the contents of the field are changed. <ahelp hid="HID_DSADMIN_SUPPRESS_VERSIONCL">Displays the internal version number of the record in the database table.</ahelp><comment>copied from shared\explorer\database\11090000.xhp</comment></paragraph>
+<paragraph role="heading" id="par_idN105FA" xml-lang="en-US" level="2" l10n="NEW">Use the catalog name in SELECT statements</paragraph>
+<paragraph role="paragraph" id="par_idN105FE" xml-lang="en-US" l10n="NEW">Uses the current data source of the catalog. This option is useful when the ODBC data source is a database server. Do not select this option if the ODBC data source is a dBase driver.<comment>copie from shared\explorer\database\11020000.xhp</comment></paragraph>
+<paragraph role="heading" id="par_idN10613" xml-lang="en-US" level="2" l10n="NEW">Use the schema name in SELECT statements</paragraph>
+<paragraph role="paragraph" id="par_idN10617" xml-lang="en-US" l10n="NEW">Allows you to use the schema name in SELECT statements.</paragraph>
+<paragraph role="heading" id="par_idN1061A" xml-lang="en-US" level="2" l10n="NEW">Create index with ASC or DESC statement</paragraph>
+<paragraph role="paragraph" id="par_idN1061E" xml-lang="en-US" l10n="NEW">Creates an index with ASC or DESC statements.</paragraph>
+<paragraph role="heading" id="par_idN10621" xml-lang="en-US" level="2" l10n="NEW">Comparison of Boolean values</paragraph>
+<paragraph role="paragraph" id="par_idN10625" xml-lang="en-US" l10n="NEW">Select the type of Boolean comparison that you want to use.</paragraph>
+</body>
+</helpdocument>
|