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

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