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!!!
could this be the answer?
http://lxr.go-oo.org/source/installation/wizards/com/sun/star/wizards/db/CommandMetaData.java#452
It is one of the wizards (I have them as a NB project, but I'm to tired
to research right now)
--
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]
