"other applications", I mean Calc
But I did get a error, its says the query doesn't exist.
Sorry if it is just a Newbie's mistake. I will try to describe my case:
I have a server "oracleserver", which hosts an oracledb
I have a client computer, on this computer, I create a odb file
"oradb" which connect to the oracleserver
I type into a cell of a calc "=SQL(select id from table1)"
the funtion "SQL" is written by me as a java plugin for Calc, its code
looks like:
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());
// statement is the sql
xRowSet.execute();
then I get the result(in the java plugin).
But if I create a Query named "query1" in the odb,
and I try "=SQL(select id from query1)"
Base will report "query1 doesn't exist", indeed I have looked at the
stack trace, it is the oracle driver which report "query1 doesn't
exist"
Thanks you!
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
