Hmm.. Still need time to understand SingleSelectQueryComposer. But it seems to me that if I want to execute arbitrary SQL which has "query1" in its FROM, I will still get trouble. If there is "query on query", can I do this? Anyway, Thank you!
2006/4/28, Frank Schönheit - Sun Microsystems Germany <[EMAIL PROTECTED]>:
Hi Li Pan, > You (and other guys there) are very friendly! we're trying our best :) > What is the time in Germany? I am considing get a "world clock". 2:35 pm > If I use > xProp.setPropertyValue( "Command", <query_name> ) > , then what I get is "select * from query1"? > but my sql is not always as simple as this, > maybe "select id from query1" > maybe "select id from query1 where id > 4" > and can be much more complex, can I still do that? To a certain extent, you can also add those additional parts. For instance, set the "Filter" property of the RowSet to "id > 4" - this will then equal the statement you mentioned. Analogous, try the "Order" (and if you need it: "HavingClause", "GroupBy") property. If you need for complex statement assembly, the SingleSelectQueryComposer service might be for you: http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/SingleSelectQueryComposer.html. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- 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]
