T__T( this is supposed to be a cring face)
Thanks!
You (and other guys there) are very friendly!
What is the time in Germany? I am considing get a "world clock".
But still a question(my oracle is down now, I can't test it)
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?
2006/4/28, Frank Schönheit - Sun Microsystems Germany
<[EMAIL PROTECTED]>:
> Hi Li Pan,
>
> > com.sun.star.sdbc.XRowSet xRowSet = (com.sun.star.sdbc.XRowSet) UnoRuntime
> > .queryInterface(com.sun.star.sdbc.XRowSet.class, rowSet);
> > ...
> > xProp.setPropertyValue("DataSourceName", getDatasource());
> > // datasource is "oradb"
> > xProp.setPropertyValue("Command", getStatement());
>
> Ah!
>
> Try
> xProp.setPropertyValue( "CommandType", _
> com.sun.star.sdb.CommandType.QUERY )
> xProp.setPropertyValue( "Command", <query_name> )
>
> This assumes that rowSet is an instance of the com.sun.star.sdb.RowSet
> [1] service - is it?
>
> Ciao
> Frank
>
> [1]http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/RowSet.html
>
> --
> - 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]
