[Libreoffice-commits] core.git: wizards/source
Jean-Pierre Ledure
jp at ledure.be
Sun Nov 29 08:44:31 PST 2015
wizards/source/access2base/DoCmd.xba | 10 +++++++++-
1 file changed, 9 insertions(+), 1 deletion(-)
New commits:
commit eb61c7f98583c50e392dc6272ee2496e7551f0f0
Author: Jean-Pierre Ledure <jp at ledure.be>
Date: Sun Nov 29 17:42:17 2015 +0100
Access2Base - OpenQuery for action queries
Change-Id: I6691c01e8a078b14ca753c916c950c958953671f
diff --git a/wizards/source/access2base/DoCmd.xba b/wizards/source/access2base/DoCmd.xba
index b5c0e9f..a10e624 100644
--- a/wizards/source/access2base/DoCmd.xba
+++ b/wizards/source/access2base/DoCmd.xba
@@ -2086,7 +2086,7 @@ Dim oDatabase As Object
If oDatabase._DbConnect <> DBCONNECTBASE Then Goto Error_NotApplicable
Dim sObjects() As String, sObjectName As String, oController As Object, oObject As Object
-Dim i As Integer, bFound As Boolean, lComponent As Long
+Dim i As Integer, bFound As Boolean, lComponent As Long, oQuery As Object
' Check existence of object and find its exact (case-sensitive) name
Select Case psObjectType
@@ -2110,12 +2110,20 @@ Dim i As Integer, bFound As Boolean, lComponent As Long
Next i
If Not bFound Then Goto Trace_NotFound
+ If psObjectType = "Query" Then ' Processing for action query
+ Set oQuery = Application._CurrentDb().QueryDefs(pvObjectName)
+ If oQuery.pType <> dbQSelect Then
+ _OpenObject = oQuery.Execute()
+ GoTo Exit_Function
+ End If
+ End If
Set oController = oDatabase.Document.CurrentController
Set oObject = oController.loadComponent(lComponent, sObjectName, ( pvView = acViewDesign ))
_OpenObject = True
Exit_Function:
Set oObject = Nothing
+ Set oQuery = Nothing
Set oController = Nothing
Exit Function
Error_Function:
More information about the Libreoffice-commits
mailing list