1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd"> 3cdf0e10cSrcweir<script:module xmlns:script="http://openoffice.org/2000/script" script:name="dbaccess_ODatasourceBrowser" script:language="StarBasic"> 4cdf0e10cSrcweir 5cdf0e10cSrcweir 6cdf0e10cSrcweir'************************************************************************* 7cdf0e10cSrcweir' 8*b40b12b0SAndrew Rist' Licensed to the Apache Software Foundation (ASF) under one 9*b40b12b0SAndrew Rist' or more contributor license agreements. See the NOTICE file 10*b40b12b0SAndrew Rist' distributed with this work for additional information 11*b40b12b0SAndrew Rist' regarding copyright ownership. The ASF licenses this file 12*b40b12b0SAndrew Rist' to you under the Apache License, Version 2.0 (the 13*b40b12b0SAndrew Rist' "License"); you may not use this file except in compliance 14*b40b12b0SAndrew Rist' with the License. You may obtain a copy of the License at 15*b40b12b0SAndrew Rist' 16*b40b12b0SAndrew Rist' http://www.apache.org/licenses/LICENSE-2.0 17*b40b12b0SAndrew Rist' 18*b40b12b0SAndrew Rist' Unless required by applicable law or agreed to in writing, 19*b40b12b0SAndrew Rist' software distributed under the License is distributed on an 20*b40b12b0SAndrew Rist' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 21*b40b12b0SAndrew Rist' KIND, either express or implied. See the License for the 22*b40b12b0SAndrew Rist' specific language governing permissions and limitations 23*b40b12b0SAndrew Rist' under the License. 24cdf0e10cSrcweir' 25cdf0e10cSrcweir'************************************************************************* 26cdf0e10cSrcweir 27cdf0e10cSrcweir 28cdf0e10cSrcweir 29*b40b12b0SAndrew Rist 30*b40b12b0SAndrew Rist 31cdf0e10cSrcweir' Be sure that all variables are dimensioned: 32cdf0e10cSrcweiroption explicit 33cdf0e10cSrcweir 34cdf0e10cSrcweir 35cdf0e10cSrcweir' REQUIRED VARIABLES for interface/service tests: 36cdf0e10cSrcweir 37cdf0e10cSrcweir' variable for XComponent 38cdf0e10cSrcweirGlobal oComponentInstance As Object 39cdf0e10cSrcweir 40cdf0e10cSrcweir' variable for XFormController 41cdf0e10cSrcweirGlobal otherWin As Object 42cdf0e10cSrcweir 43cdf0e10cSrcweir' variable for XDispatchProvider 44cdf0e10cSrcweirGlobal dispatchUrl As String 45cdf0e10cSrcweir 46cdf0e10cSrcweir' variable for frame.XController 47cdf0e10cSrcweirGlobal oFrameToAttach As Object 48cdf0e10cSrcweirGlobal oModelToAttach As Object 49cdf0e10cSrcweirGlobal bHasNoViewData As Boolean 50cdf0e10cSrcweirGlobal oObjToSuspend As Object 51cdf0e10cSrcweirGlobal bHasNoModel As Boolean 52cdf0e10cSrcweir 53cdf0e10cSrcweir' variables for awt.XTabController 54cdf0e10cSrcweirGlobal oXTabControllerModel as Object 55cdf0e10cSrcweirGlobal oXTabControllerContainer as Object 56cdf0e10cSrcweir 57cdf0e10cSrcweir' variable for lang.XInitialization 58cdf0e10cSrcweirGlobal aInitArgs As Variant 59cdf0e10cSrcweir 60cdf0e10cSrcweir 61cdf0e10cSrcweirSub CreateObj() 62cdf0e10cSrcweir 63cdf0e10cSrcweir'************************************************************************* 64cdf0e10cSrcweir' COMPONENT: 65cdf0e10cSrcweir' dbaccess.ODatasourceBrowser 66cdf0e10cSrcweir'************************************************************************* 67cdf0e10cSrcweirOn Error Goto ErrHndl 68cdf0e10cSrcweir Dim cntrlr As Object 69cdf0e10cSrcweir Dim frame1 As Object, frame2 As Object 70cdf0e10cSrcweir Dim url As new com.sun.star.util.URL 71cdf0e10cSrcweir Dim dispatcher As Object 72cdf0e10cSrcweir Dim oShape As Object, oDrawPage As Object, oModel As Object 73cdf0e10cSrcweir Dim oController As Object, oCtrll As Object 74cdf0e10cSrcweir Dim params(2) as new com.sun.star.beans.PropertyValue 75cdf0e10cSrcweir Dim list1 as object, ctrl as object 76cdf0e10cSrcweir 77cdf0e10cSrcweir' oDoc = utils.createDocument("swriter", cObjectName) 78cdf0e10cSrcweir oDoc = StarDesktop.loadComponentFromUrl("private:factory/swriter", "_blank",0 , args()) 79cdf0e10cSrcweir 80cdf0e10cSrcweir wait(500) 81cdf0e10cSrcweir 82cdf0e10cSrcweir cntrlr = oDoc.getCurrentController() 83cdf0e10cSrcweir frame1 = StarDesktop.getCurrentFrame() 84cdf0e10cSrcweir url.Complete = ".component:DB/DataSourceBrowser" 85cdf0e10cSrcweir dispatcher = frame1.queryDispatch(url, "_beamer", 12) 86cdf0e10cSrcweir dispatcher.dispatch(url, DimArray()) 87cdf0e10cSrcweir 88cdf0e10cSrcweir frame2 = frame1.findFrame("_beamer", 4) 89cdf0e10cSrcweir frame2.setName("ODatasourceBrowser") 90cdf0e10cSrcweir 91cdf0e10cSrcweir oObj = frame2.getController() 92cdf0e10cSrcweir 93cdf0e10cSrcweir ' now initialize the browser to make him displaying a table in its gtrid. 94cdf0e10cSrcweir ' This is required for activating of this control 95cdf0e10cSrcweir params(0).Name = "DataSourceName" 96cdf0e10cSrcweir params(0).Value = "Bibliography" 97cdf0e10cSrcweir params(1).Name = "CommandType" 98cdf0e10cSrcweir params(1).Value = com.sun.star.sdb.CommandType.TABLE 99cdf0e10cSrcweir params(2).Name = "Command" 100cdf0e10cSrcweir params(2).Value = "biblio" 101cdf0e10cSrcweir 102cdf0e10cSrcweir oObj.initialize(params()) 103cdf0e10cSrcweir ' waiting while data loading ... 104cdf0e10cSrcweir wait(2000) 105cdf0e10cSrcweir 106cdf0e10cSrcweir'setting variable for XComponent 107cdf0e10cSrcweir oComponentInstance = oObj 108cdf0e10cSrcweir 109cdf0e10cSrcweir'setting variable for XDispatchProvider 110cdf0e10cSrcweir dispatchUrl = ".uno:DataSourceBrowser/FormLetter" 111cdf0e10cSrcweir 112cdf0e10cSrcweir'setting variable for XController 113cdf0e10cSrcweir oFrameToAttach = frame1 114cdf0e10cSrcweir oModelToAttach = oDoc 115cdf0e10cSrcweir bHasNoViewData = true 116cdf0e10cSrcweir oObjToSuspend = oObj 117cdf0e10cSrcweir bHasNoModel = true 118cdf0e10cSrcweir 119cdf0e10cSrcweir'setting variables for awt.XTabController and for XFormController 120cdf0e10cSrcweir oShape = toolkittools.createUNOControlShape("CommandButton", "UnoControlButton") 121cdf0e10cSrcweir toolkittools.addShape(oShape) 122cdf0e10cSrcweir oDrawPage = oDoc.getDrawPage() 123cdf0e10cSrcweir 124cdf0e10cSrcweir oModel = oShape.getControl() 125cdf0e10cSrcweir oController = oDoc.getCurrentController() 126cdf0e10cSrcweir otherWin = oController.getControl(oModel) 127cdf0e10cSrcweir oXTabControllerContainer = otherWin.getContext() 128cdf0e10cSrcweir oXTabControllerModel = oDrawPage.getForms().getByIndex(0) 129cdf0e10cSrcweir 130cdf0e10cSrcweir' setting variable for lang.XInitialization 131cdf0e10cSrcweir aInitArgs = params() 132cdf0e10cSrcweir 133cdf0e10cSrcweirExit Sub 134cdf0e10cSrcweirErrHndl: 135cdf0e10cSrcweir Test.Exception() 136cdf0e10cSrcweirEnd Sub 137cdf0e10cSrcweir</script:module> 138