Yes, but not enough. I want Base as a "proxy" database.I want to use the queries(or views, anything that is stored in Base, if you tell me I can already archive this using a view, it is really a good news:)) as views in the original database. The users of our application can treat the query just as a view in the Oracle. That is, I want it occurs in a FROM statement. We are building (very complex) reports of some oracle databases, but the DBAs won't allow us to create views in their databases, that is why we want this.
2006/4/28, Andrew Jensen <[EMAIL PROTECTED]>: > li pan wrote: > Thanks! I have read through your discussions, and here is my 2 cents. The > reason why I want this is because that we are using Base as a "datasource" > manager of our application. The feature we want most is a friendly guery > designer which can be used to design custom queries. The query designer is > amazing. But since the queries can only be viewed in Base. This is somewhat > a waste. > > Hello Ii Pan, > > I don't quite understand what you mean by this statement. > > If the queries can be queried by other applications, users can find a new > way to use Base. I know Access can do this. Oh yes we can't say it is cool > just because Access do this, but many user do use it this way. > > What do you mena by 'queried by other applications'? If you where to write > an applicaion in VB, C#, C++, Delphi, Java, or Delphi (Lazarus) you could > gain access to either the SQL command or the rowset returned by a Base query > object. > > I think if the queries can cache the data locally, it will be even > better. 2006/4/27, Frank Schönheit - Sun Microsystems > Germany <[EMAIL PROTECTED]>: > Hi Li Pan, > sorry, I mean a query(those designed by Base's query designer, not a view in > Oracle) called test > Yes, in this case "select * from test" will probably be possible after this > feature has been implemented. 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
