Hi Andrew, > Looking at yor example in the General section of the document, line 46 > > SELECT * FROM "AllOrders" WHERE "AllOrders"."ShipDate" > IS NULL > > > Where AllOders is the name of a query, you show it double quoted just as > if it where a valid table name. But of course you can't send this actual > text to the engine, as it has no idea of what AllOrders is. Now suppose > you changed the Base application so that when a query is added to a > query the query name is represented differently. Perhaps: > > SELECT * FROM [AllOrders] "AllOrder" WHERE "AllOrders"."ShipDate" IS NULL
That might be possible, but violate the transparency requirement which I think is a good idea. Ideally, users shouldn't be concerned (at least not too much) whether they're just using a query or a table - both should look and feel the same when it comes to designing another query. With this requirement, which I consider important, changing the syntax to quote queries differently doesn't sound like a good idea to me. Also, changing the parser and tracking all the time whether something is a query or a table is more difficult to implement *bg* than just handling everything as if it were a table, and just substituting the queries immediately before sending the statement to the database. > ( as an aside I don't want to make the same > mistake I made earler when we talked about queries as views and I > offered an opinion about which approach would be less risky, or take > less man hours to implelement. I should aploogize for that series of > messages, you know the code base - not I - you know the team members - > not I - and you know what is on everyones plate - not I -. I am not sure > why I really thought I could offer a valid opinion on cost of > implemenation one way ot the other..) No problem. I enjoy this discussion, you have a good understanding of the matter and ask a lot of reasonable questions which force me to always question the current design, this way constantly improving it (hopefully). Thanks & 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]
