Drew Jensen escribió:
OK - not what I wanted, but something worth noting:
This change will allow you to open an existing query, in a query design
window using the active connection.
Sub Test( aQueryName as string, aConnection as variant )
oDesktop = createUnoService("com.sun.star.frame.Desktop")
Dim aURL as New com.sun.star.util.URL
aURL.Complete = ".component:DB/QueryDesign"
oDispatchObject = oDesktop.queryDispatch(_
aURL, _
"_BLANK",_
com.sun.star.frame.FrameSearchFlag.CREATE)
Dim aProps(2) as New com.sun.star.beans.PropertyValue
aProps(0).Name = "ActiveConnection"
aProps(0).Value = aConnection aProps(1).Name = "QueryDesignView"
aProps(1).Value = TRUE
aProps(2).Name = "CurrentQuery"
aProps(2).Value = aQueryName
oDispatchObject.dispatch(aURL, aProps)
End Sub
Now to get the FormGridView to load up with the data from a query and
I'm done!!!
look at this in public XComponent[] switchtoDataViewmode:
rDispatchArguments[4] = Properties.createProperty("ShowTreeView",
Boolean.FALSE);
476 rDispatchArguments[5] =
Properties.createProperty("ShowTreeViewButton", Boolean.FALSE);
477 rDispatchArguments[6] =
Properties.createProperty("ShowMenu", Boolean.TRUE);
this may get rid of the tree in the datasource browser, and show the menu...
NOTE to Frank: where is all this documented?
--
Ariel Constenla-Haile
La Plata, Argentina
[EMAIL PROTECTED]
[EMAIL PROTECTED]
http://www.ArielConstenlaHaile.com.ar/ooo/
"Aus der Kriegsschule des Lebens
- Was mich nicht umbringt,
macht mich härter."
Nietzsche Götzendämmerung, Sprüche und Pfeile, 8.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
