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]