Re: Re: Can't open QueryDesign using marco in officebean

I use a datasource file.
I am sure it is a valid datasource file. It is not an XDataSource
object, but the I think the document says it is valid too.
I think maybe there is a different between our codes.
I used java to open a calc doc, and then I tried to open query
designer, then it failed.
But if I use java to open the datasource file, I can open the query designer.

If I run the same marco on the same document outside java, every thing is ok.


2006/5/29, Ocke Janssen <[email protected]>:
> I wrote a own program in Java, too. When connected to the office, I
> create a new connection to db of my choice and used this connection as
> parameter for the query designer.
> When you set the data source, does that mean you have an XDataSource
> object (or any other X-interface supported by the data source) at your
> fingers?
>
> - OJ
>
> li pan wrote:
> > Hmm, I have set DataSource for it, it can run.
> > But my poblem is, it can run in openoffice, but can't run in a
> > officebean embedded in java.
> >
> > 2006/5/29, Ocke Janssen <[email protected]>:
> >> Hi li pan,
> >>
> >> you have to insert a extra property in the loadComponentFromURL call.
> >> The querydesign needs a data source, a connection, or the registered
> >> name of the data source.
> >>
> >> The property names are:
> >> DataSource
> >> ActiveConnection
> >> DataSourceName
> >>
> >> Choose one of them and set the value accordingly. :-) I used the
> >> ActiveConnection property.
> >>
> >> Best regards,
> >>
> >> Ocke
> >>
> >> li pan wrote:
> >> > Well.The datasource is not the problem
> >> > I have fixed my datasource, it work well outside officebean.
> >> > But still won't work in officebean.
> >> > the query frame did appear, but nothing in it.
> >> > and
> >> > loadComponentFromURL
> >> > returned null
> >> >
> >> > 2006/5/26, li pan <[email protected]>:
> >> >> Sorry, the datasource I used was not valid.
> >> >> I think it would be better if I can get a error message.
> >> >>
> >> >> 2006/5/26, li pan <[email protected]>:
> >> >> > I tried different urls and only
> >> >> > ".component:DB/QueryDesign"
> >> >> > doesn't work
> >> >> >
> >> >> > ".component:DB/FormGridView" or "file:///F:\test.ods" work.
> >> >> >
> >> >> > Don't know why:(
> >> >> >
> >> >> >
> >> >> > 2006/5/26, li pan <[email protected]>:
> >> >> > > Hi
> >> >> > > I was trying to open QueryDesign using openbasic marco, like this
> >> >> > >
> >> >> > > QueryDesign = frame.loadComponentFromURL(
> >> >> ".component:DB/QueryDesign",
> >> >> > > "_self", 0, _Array( MakePropertyValue( "DataSourceName",
> >> >> dataSource )
> >> >> > > ) )
> >> >> > >
> >> >> > > It was OK. But if I run the marco in a officebean which is
> >> >> embedded in
> >> >> > > a java application, the QueryDesign won't open, and no error
> >> message
> >> >> > > will be given.
> >> >> > >
> >> >> > > I am using OpenOffice 2.0.1 on windows.
> >> >> > > Any idea?
> >> >> > >
> >> >> >
> >> >>
> >> >
> >> > ---------------------------------------------------------------------
> >> > To unsubscribe, e-mail: [email protected]
> >> > For additional commands, e-mail: [email protected]
> >> >
> >>
> >>
> >> --
> >> Ocke Janssen                      Tel: +49 40 23646 661, x66661
> >> Dipl. Inf(FH)                     Fax: +49 40 23646 550
> >> Sun Microsystems Inc.
> >> Nagelsweg 55                     mailto:[email protected]
> >> D-20097 Hamburg                   http://www.sun.com/staroffice
> >>
> >>                        Example isn't another way to teach,
> >>                        it is the only way to teach.
> >>                        Albert Einstein
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: [email protected]
> >> For additional commands, e-mail: [email protected]
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [email protected]
> > For additional commands, e-mail: [email protected]
> >
>
>
> --
> Ocke Janssen                      Tel: +49 40 23646 661, x66661
> Dipl. Inf(FH)                     Fax: +49 40 23646 550
> Sun Microsystems Inc.
> Nagelsweg 55                     mailto:[email protected]
> D-20097 Hamburg                   http://www.sun.com/staroffice
>
>                        Example isn't another way to teach,
>                        it is the only way to teach.
>                        Albert Einstein
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>