source/text/sbasic/shared/03/sf_dataset.xhp | 42 ++++++++++++++-------------- 1 file changed, 21 insertions(+), 21 deletions(-)
New commits: commit ef45f87dbeeaada230b31b5790fc1542a3c236f4 Author: Stanislav Horacek <[email protected]> AuthorDate: Sun Dec 10 14:42:19 2023 +0100 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Dec 17 15:42:45 2023 +0100 localize bookmarks and code comments in SF Dataset service Change-Id: I0d2fbcbb88f97930c60f1eafa26efa4997bf965d Reviewed-on: https://gerrit.libreoffice.org/c/help/+/160540 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/sbasic/shared/03/sf_dataset.xhp b/source/text/sbasic/shared/03/sf_dataset.xhp index 47158a535e..a3b7ae61a3 100644 --- a/source/text/sbasic/shared/03/sf_dataset.xhp +++ b/source/text/sbasic/shared/03/sf_dataset.xhp @@ -18,7 +18,7 @@ <body> <section id="SFDatabases-sf_dataset"> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id261582733781987"> + <bookmark xml-lang="en-US" branch="index" id="bm_id261582733781987"> <bookmark_value>Dataset service</bookmark_value> </bookmark> </section> @@ -42,7 +42,7 @@ <embed href="text/sbasic/shared/03/lib_ScriptForge.xhp#importLibs"/> <paragraph role="paragraph" id="par_id411700851985942">The <literal>Dataset</literal> service is invoked using the <literal>CreateDataset</literal> method, which can be called either from a <literal>Database</literal> service instance or from another <literal>Dataset</literal> instance.</paragraph> - + <embed href="text/sbasic/shared/00000003.xhp#In_Basic"/> <paragraph role="paragraph" id="par_id771700853155061">The following example creates a <literal>Dataset</literal> from the table "Customers" stored in a database file.</paragraph> <bascode> @@ -61,7 +61,7 @@ <bascode> <paragraph role="bascode" localize="false" id="bas_id141700853757638">oNewDataset = oDataset.CreateDataset(Filter := "[City]='New York'")</paragraph> </bascode> - + <embed href="text/sbasic/shared/00000003.xhp#In_Python"/> <pycode> <paragraph role="pycode" localize="false" id="pyc_id61701127356712">database = CreateScriptService("Database", r"C:\MyDatabase.odb")</paragraph> @@ -348,7 +348,7 @@ <section id="CloseDataset"> <comment> CloseDataset ---------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92158919969883"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92158919969883"> <bookmark_value>Dataset service;CloseDataset</bookmark_value> </bookmark> <h2 id="hd_id201589199698251" localize="false">CloseDataset</h2> @@ -375,7 +375,7 @@ <section id="CreateDataset"> <comment> CreateDataset -------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92158919969443"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92158919969443"> <bookmark_value>Dataset service;CreateDataset</bookmark_value> </bookmark> <h2 id="hd_id201589199660251" localize="false">CreateDataset</h2> @@ -390,26 +390,26 @@ <embed href="text/sbasic/shared/00000003.xhp#functexample"/> <embed href="text/sbasic/shared/00000003.xhp#In_Basic"/> <bascode> - <paragraph role="bascode" localize="false" id="bas_id721701180069642">' Use an empty string to remove the current filter</paragraph> + <paragraph role="bascode" id="bas_id721701180069642">' Use an empty string to remove the current filter</paragraph> <paragraph role="bascode" localize="false" id="bas_id191701180070057">oNewDataset = oDataset.CreateDataset(Filter := "")</paragraph> - <paragraph role="bascode" localize="false" id="bas_id981701180070457">' Examples of common filters</paragraph> + <paragraph role="bascode" id="bas_id981701180070457">' Examples of common filters</paragraph> <paragraph role="bascode" localize="false" id="bas_id217011800710769">oNewDataset = oDataset.CreateDataset(Filter := "[Name] = 'John'")</paragraph> <paragraph role="bascode" localize="false" id="bas_id341701180070985">oNewDataset = oDataset.CreateDataset(Filter := "[Name] LIKE 'A'")</paragraph> - <paragraph role="bascode" localize="false" id="bas_id371701180071169">' It is possible to append additional conditions to the current filter</paragraph> + <paragraph role="bascode" id="bas_id371701180071169">' It is possible to append additional conditions to the current filter</paragraph> <paragraph role="bascode" localize="false" id="bas_id817011802603460">oNewDataset = oDataset.CreateDataset(Filter := "(" & oDataset.Filter & ") AND [Name] LIKE 'A'")</paragraph> </bascode> <embed href="text/sbasic/shared/00000003.xhp#In_Python"/> <pycode> - <paragraph role="pycode" id="pyc_id221701180362978">new_dataset = dataset.CreateDataset(filter = "")</paragraph> - <paragraph role="pycode" id="pyc_id581701180363338">new_dataset = dataset.CreateDataset(filter = "[Name] = 'John'")</paragraph> - <paragraph role="pycode" id="pyc_id261701180365275">new_dataset = dataset.CreateDataset(filter = "[Name] LIKE 'A'")</paragraph> - <paragraph role="pycode" id="pyc_id481701180365786">new_dataset = dataset.CreateDataset(filter = f"({dataset.Filter}) AND [Name] LIKE 'A'")</paragraph> + <paragraph role="pycode" localize="false" id="pyc_id221701180362978">new_dataset = dataset.CreateDataset(filter = "")</paragraph> + <paragraph role="pycode" localize="false" id="pyc_id581701180363338">new_dataset = dataset.CreateDataset(filter = "[Name] = 'John'")</paragraph> + <paragraph role="pycode" localize="false" id="pyc_id261701180365275">new_dataset = dataset.CreateDataset(filter = "[Name] LIKE 'A'")</paragraph> + <paragraph role="pycode" localize="false" id="pyc_id481701180365786">new_dataset = dataset.CreateDataset(filter = f"({dataset.Filter}) AND [Name] LIKE 'A'")</paragraph> </pycode> </section> <section id="Delete"> <comment> Delete --------------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id9215369969883"> + <bookmark xml-lang="en-US" branch="index" id="bm_id9215369969883"> <bookmark_value>Dataset service;Delete</bookmark_value> </bookmark> <h2 id="hd_id201589199650151" localize="false">Delete</h2> @@ -432,7 +432,7 @@ <section id="ExportValueToFile"> <comment> ExportValueToFile ----------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92153179969443"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92153179969443"> <bookmark_value>Dataset service;ExportValueToFile</bookmark_value> </bookmark> <h2 id="hd_id201589196160251" localize="false">ExportValueToFile</h2> @@ -460,7 +460,7 @@ <section id="GetRows"> <comment> GetRows -------------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92158910859443"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92158910859443"> <bookmark_value>Dataset service;GetRows</bookmark_value> </bookmark> <h2 id="hd_id201589199660414" localize="false">GetRows</h2> @@ -500,7 +500,7 @@ <section id="GetValue"> <comment> GetValue ------------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92153179971743"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92153179971743"> <bookmark_value>Dataset service;GetValue</bookmark_value> </bookmark> <h2 id="hd_id201589196152051" localize="false">GetValue</h2> @@ -525,7 +525,7 @@ <section id="Insert"> <comment> Insert ---------------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92153179527743"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92153179527743"> <bookmark_value>Dataset service;Insert</bookmark_value> </bookmark> <h2 id="hd_id201589196824051" localize="false">Insert</h2> @@ -570,7 +570,7 @@ <section id="MoveFirstLast"> <comment> MoveFirstLast -------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92159920571743"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92159920571743"> <bookmark_value>Dataset service;MoveFirst</bookmark_value> <bookmark_value>Dataset service;MoveLast</bookmark_value> </bookmark> @@ -598,7 +598,7 @@ <section id="MoveNextPrevious"> <comment> MoveNextPrevious ------------------------------------------------------------------------------------ </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92157026521743"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92157026521743"> <bookmark_value>Dataset service;MoveNext</bookmark_value> <bookmark_value>Dataset service;MovePrevious</bookmark_value> </bookmark> @@ -630,7 +630,7 @@ <section id="Reload"> <comment> Reload --------------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92157026521993"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92157026521993"> <bookmark_value>Dataset service;Reload</bookmark_value> </bookmark> <h2 id="hd_id201589196152548" localize="false">Reload</h2> @@ -659,7 +659,7 @@ <section id="Update"> <comment> Update --------------------------------------------------------------------------------------------- </comment> - <bookmark xml-lang="en-US" localize="false" branch="index" id="bm_id92157026521088"> + <bookmark xml-lang="en-US" branch="index" id="bm_id92157026521088"> <bookmark_value>Dataset service;Update</bookmark_value> </bookmark> <h2 id="hd_id201589196157828" localize="false">Update</h2>
