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