when I said a view named "foo" it should be a query named "foo" I guess my problem has nothing to do with calc. it is because that a query can't appear in other query's FROM statement.
2006/4/24, li pan <[EMAIL PROTECTED]>: > sorry for my late response. > > I created a Base document which connect to Oracle, and registered it > as .a datasource of openoffice > then I created a Calc document. the Calc document has some macros to > read data from the database. I was using sdbc. > now everything was OK. > but if I create a view named "foo" in the Base document(the > datasource), and havn't save in as a view in the Oracle db. > then every sql like "select * from foo" won't work. It said the > table/view didn't exist. Yes it did not exist in the Oracle db, but it > exist in the datasource, so I would like my sql statements can query > from the view named "foo" > > > 2006/4/19, Frank Schönheit - Sun Microsystems Germany > <[EMAIL PROTECTED]>: > > Hi Li, > > > > > Hi, if I have created a "query" in Base(but didn't save it as a view > > > to the backend database), how can I query it from Calc's macro? > > > I am using Base as my database frontend now.I connect to Oracle/MySQL > > > databases through Base, but if I try to query this Base from Calc > > > using SDBC, any queries I created can't be found. SDBC says" the > > > table/view doesn't exist". > > > > How exactly do you want to access the query in Calc? What are you doing? > > > > Ciao > > Frakn > > > > -- > > - 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]
