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

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