diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2005-10-19 09:12:30 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2005-10-19 09:12:30 +0000 |
| commit | 407a18581a1e1e2add1092d46484436a06cc8210 (patch) | |
| tree | b66cd3087e6fbbea9a336a334bf590106cc719db /helpcontent2/source/text/shared/guide/data_enter_sql.xhp | |
| parent | fbfe3fb1a2e9afaf5d77ec3f646e817c03975726 (diff) | |
INTEGRATION: CWS hc680qq1 (1.3.74); FILE MERGED
2005/10/18 14:09:10 ufi 1.3.74.3: RESYNC: (1.4-1.5); FILE MERGED
2005/09/20 20:51:04 ufi 1.3.74.2: RESYNC: (1.3-1.4); FILE MERGED
2005/09/13 13:15:00 ufi 1.3.74.1: firsttry
Diffstat (limited to 'helpcontent2/source/text/shared/guide/data_enter_sql.xhp')
| -rw-r--r-- | helpcontent2/source/text/shared/guide/data_enter_sql.xhp | 39 |
1 files changed, 17 insertions, 22 deletions
diff --git a/helpcontent2/source/text/shared/guide/data_enter_sql.xhp b/helpcontent2/source/text/shared/guide/data_enter_sql.xhp index c7cd4332bb..5ec38c0c82 100644 --- a/helpcontent2/source/text/shared/guide/data_enter_sql.xhp +++ b/helpcontent2/source/text/shared/guide/data_enter_sql.xhp @@ -5,9 +5,9 @@ * * $RCSfile: data_enter_sql.xhp,v $ * - * $Revision: 1.5 $ + * $Revision: 1.6 $ * - * last change: $Author: kz $ $Date: 2005-10-05 13:45:07 $ + * last change: $Author: rt $ $Date: 2005-10-19 10:12:30 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -42,11 +42,14 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-08-18T14:39:39">fpe: changed to match new database interface</lastedited> +<lastedited date="2005-09-06T15:52:33">fpe: changed to match new database interface</lastedited> </history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3152801"><bookmark_value>SQL; executing commands</bookmark_value> +<bookmark_value>queries;creating in SQL view</bookmark_value> +<bookmark_value>commands;SQL</bookmark_value> +<bookmark_value>executing;SQL commands</bookmark_value> </bookmark> <paragraph role="heading" id="hd_id3152801" xml-lang="en-US" level="1" l10n="U" oldref="67"><variable id="data_enter_sql"><link href="text/shared/guide/data_enter_sql.xhp" name="Executing SQL Commands">Executing SQL Commands</link> </variable></paragraph> @@ -61,32 +64,24 @@ <paragraph role="paragraph" id="par_id9448530" xml-lang="en-US" l10n="NEW">Choose <emph>Tools - SQL</emph>.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id6958830" xml-lang="en-US" l10n="NEW">In the <emph>Execute SQL statement</emph> dialog, enter the SQL statement and click <emph>Execute</emph>.</paragraph> -</listitem> -</list> -<paragraph role="heading" id="hd_id7130649" xml-lang="en-US" level="2" l10n="NEW">To edit a query using an SQL statement</paragraph> -<list type="ordered"> -<listitem> -<paragraph role="paragraph" id="par_id3155390" xml-lang="en-US" l10n="CHG" oldref="70">Choose <emph>File - Open</emph> to open the database file of the database for which you want to edit an SQL query.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3156343" xml-lang="en-US" l10n="CHG" oldref="89">Click the <emph>Queries</emph> icon.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id6176641" xml-lang="en-US" l10n="NEW">Click the query you want to edit.</paragraph> -</listitem> -<listitem> -<paragraph role="paragraph" id="par_id3151176" xml-lang="en-US" l10n="CHG" oldref="91">Choose <emph>Edit - Edit</emph>.</paragraph> +<paragraph role="paragraph" id="par_id3151176" xml-lang="en-US" l10n="U" oldref="91">Click the <emph>Create Query in SQL View</emph> icon +<image id="img_id3154071" src="res/commandimagelist/sc_dbnewquerysql.png" width="5.64mm" height="5.64mm"><alt id="alt_id3154071" xml-lang="en-US">Icon</alt> + </image> or</paragraph> +<paragraph role="paragraph" id="par_id3145786" xml-lang="en-US" l10n="U" oldref="92">Select an existing query from the list and click the <emph>Edit</emph> icon +<image id="img_id3156212" src="res/commandimagelist/sc_dbqueryedit.png" width="5.64mm" height="5.64mm"><alt id="alt_id3156212" xml-lang="en-US">Icon</alt> + </image>.</paragraph> </listitem> <listitem> <paragraph role="paragraph" id="par_id3083443" xml-lang="en-US" l10n="U" oldref="94">In the <emph>Query</emph> window, choose <emph>View - Switch Design View On/Off</emph>. Edit the SQL command.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id3152460" xml-lang="en-US" l10n="CHG" oldref="96">Choose <emph>View - Preview</emph> for a preview, if required.</paragraph> +<paragraph role="paragraph" id="par_id3152460" xml-lang="en-US" l10n="U" oldref="96">Click the <emph>Run</emph> icon +<image id="img_id3152886" src="res/commandimagelist/sc_sbanativesql.png" width="5.64mm" height="5.64mm"><alt id="alt_id3152886" xml-lang="en-US">Icon</alt> + </image>. The result of the query is displayed in the upper window.</paragraph> </listitem> <listitem> -<paragraph role="paragraph" id="par_id3149298" xml-lang="en-US" l10n="U" oldref="98">Click the <emph>Save</emph> icon -<image id="img_id3153159" src="res/commandimagelist/sc_save.png" width="0.222inch" height="0.222inch"><alt id="alt_id3153159" xml-lang="en-US">Icon</alt> +<paragraph role="paragraph" id="par_id3149298" xml-lang="en-US" l10n="U" oldref="98">Click the <emph>Save</emph> or <emph>Save As</emph> icon +<image id="img_id3153159" src="res/commandimagelist/sc_save.png" width="5.64mm" height="5.64mm"><alt id="alt_id3153159" xml-lang="en-US">Icon</alt> </image> to save the query.</paragraph> </listitem> </list> |