Hi Andrew, > Just read over the new spec document and have a couple of questions, if > you don't mind.
Sure, that's why I announced it here :) > 1) If the user has created this query in the designer and then switches > the designer off I take it the SQL window will now display the text, > exactly as shown in the document: > > SELECT * FROM "AllOrders" WHERE "AllOrders"."ShipDate" IS NULL > > This would be possible because Base knows that the token 'AllOders' > referes to a query definiton, right? > > 2) The user at this point turns 'Run SQL Direct' on. Now what must > happen? Nothing. I think any magic applied when toggling the button will fail in 50% of all cases (as it's the usual crux with magic :). Not to mention that it becomes arbitrarly complex when switching back, as you outlined. The general statement is that in "Run SQL Direct" (wouldn't "Directly" be better English? Hmm.) mode, queries in queries are simply not supported. So, the user will get an error message here. I will try to explain this better in the next revision. > The next question is about section 1.3 Query Designer > [query vs. view icons] Ah, you're right. Seems we need different icons for both, or a different form of display. Somebody from the iTeam already suggested Tables +- Table 1 . +- Table n Queries +- Query 1 . +- Query m but I am not sure I like this idea. The data to be displayed here is not really tree-like by nature, and forcing it to be displayed as tree is somewhat unusable, IMO. Perhaps a (*) Tables ( ) Queries ( ) Both +--------------------------------------------+ | Table 1 | . .... . | Table n | . .... . +--------------------------------------------+ could do. 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]
