Re: Re: Can't open QueryDesign using marco in officebean
"li pan" <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
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] > >