Re: [dba-users] Queries in Queries: new spec version

[Fred Frazelle]

Frank Schönheit - Sun Microsystems Germany wrote: 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 It would seem to me that The general statement is that in "Run SQL Direct" (wouldn't "Directly" might be better with "Run in SQL mode" Have a great afternoon! be better English? Hmm.) mode, --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]