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]
