summaryrefslogtreecommitdiff
path: root/wizards
diff options
context:
space:
mode:
authorJean-Pierre Ledure <jp@ledure.be>2022-12-15 16:00:09 +0100
committerJean-Pierre Ledure <jp@ledure.be>2022-12-15 16:26:25 +0000
commit8a67d717099179bf77bf75d9e7437280e335439e (patch)
tree75a8c6e229962a60f063af0bdc0745d81040cd24 /wizards
parent1c5c31b006f8515bfea440bbcf286f8b4b840aac (diff)
ScriptForge - (SF_Datasheet) minor changes in comments
No effect on code execution. Hence no cherry-picks to previous release(s). Change-Id: I724c05ee2807e2783655cbb8889a721a5a5e1b75 Reviewed-on: https://gerrit.libreoffice.org/c/core/+/144224 Tested-by: Jean-Pierre Ledure <jp@ledure.be> Reviewed-by: Jean-Pierre Ledure <jp@ledure.be> Tested-by: Jenkins
Diffstat (limited to 'wizards')
-rw-r--r--wizards/source/sfdatabases/SF_Datasheet.xba8
-rw-r--r--wizards/source/sfdocuments/SF_Base.xba2
2 files changed, 5 insertions, 5 deletions
diff --git a/wizards/source/sfdatabases/SF_Datasheet.xba b/wizards/source/sfdatabases/SF_Datasheet.xba
index a7835e21ffbc..681f9549b814 100644
--- a/wizards/source/sfdatabases/SF_Datasheet.xba
+++ b/wizards/source/sfdatabases/SF_Datasheet.xba
@@ -21,7 +21,7 @@ Option Explicit
&apos;&apos;&apos; In the context of ScriptForge, a datasheet may be opened automatically by script code :
&apos;&apos;&apos; - either by reproducing the behaviour of the user interface
&apos;&apos;&apos; - or at any moment. In this case the Base document may or may not be opened.
-&apos;&apos;&apos; Additionally, any SELECT SQL statement may trigger the datasheet display.
+&apos;&apos;&apos; Additionally, any SELECT SQL statement may define the datasheet display.
&apos;&apos;&apos;
&apos;&apos;&apos; The proposed API allows for either datasheets (opened manually of by code) in particular
&apos;&apos;&apos; to know which cell is selected and its content.
@@ -30,8 +30,8 @@ Option Explicit
&apos;&apos;&apos; 1) From an open Base document
&apos;&apos;&apos; Set ui = CreateScriptService(&quot;UI&quot;)
&apos;&apos;&apos; Set oBase = ui.getDocument(&quot;/home/user/Documents/myDb.odb&quot;)
-&apos;&apos;&apos; Set oSheet1 = oBase.OpenTable(&quot;Customers&quot;) &apos; or OpenQuery(...)
-&apos;&apos;&apos; Set oSheet2 = oBase.Datasheets(&quot;Products&quot;) &apos; when the datasheet has been opened manually
+&apos;&apos;&apos; Set oSheet = oBase.OpenTable(&quot;Customers&quot;) &apos; or OpenQuery(...)
+&apos;&apos;&apos; &apos; May be executed also when the given table is already open
&apos;&apos;&apos; 2) Independently from a Base document
&apos;&apos;&apos; Set oDatabase = CreateScriptService(&quot;Database&quot;, &quot;/home/user/Documents/myDb.odb&quot;)
&apos;&apos;&apos; Set oSheet = oDatabase.OpenTable(&quot;Customers&quot;)
@@ -709,8 +709,8 @@ Try:
Set _ControlModel = _ControlView.getModel()
End With
- &apos; Retrieve the parent database instance
With _TabControllerModel
+ &apos; Retrieve the parent database instance
Select Case _ParentType
Case &quot;BASE&quot;
Set _ParentDatabase = [_Parent].GetDatabase(.User, .Password)
diff --git a/wizards/source/sfdocuments/SF_Base.xba b/wizards/source/sfdocuments/SF_Base.xba
index eb39c86e851f..8970b7c05b96 100644
--- a/wizards/source/sfdocuments/SF_Base.xba
+++ b/wizards/source/sfdocuments/SF_Base.xba
@@ -520,7 +520,7 @@ Public Function OpenQuery(Optional ByVal QueryName As Variant _
&apos;&apos;&apos; QueryName: a valid Query name as a case-sensitive string
&apos;&apos;&apos; DesignMode: when True the query is opened in design mode (Default = False)
&apos;&apos;&apos; Returns:
-&apos;&apos;&apos; A Datasheet class instance if the query could be opened and DesignMode = False, otherwise False
+&apos;&apos;&apos; A Datasheet class instance if the query could be opened and DesignMode = False, otherwise Nothing
&apos;&apos;&apos; Exceptions:
&apos;&apos;&apos; Query name is invalid
&apos;&apos;&apos; Example: