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

[Andrew Jensen]

Hi Frank, Just read over the new spec document and have a couple of questions, if you don't mind. The first couple are about user interaction. I will use the query text from line 46 of the document for an example. 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? If the select statement where sent to the back end, as is, it would be invalid. So the only thing that makes sense to me is that the application must at this point perform the substitution and display this: ( with formatting added here for clarity ) SELECT * FROM ( SELECT "Customers"."Name" AS "CustomerName", "Orders"."OrderDate", "Orders"."ShipDate", "OrderDetails"."Quantity", "Products"."Name" AS "ProductName" FROM "OrderDetails" "OrderDetails", "Orders" "Orders", "Products" "Products", "Customers" "Customers" WHERE ( "OrderDetails"."OrderID" = "Orders"."ID" AND "OrderDetails"."ProductID" = "Products"."ID" AND "Orders"."CustomerID" = "Customers"."ID" ) ) "AllOrders" WHERE "AllOrders"."ShipDate" IS NULL 3) The user turns 'Run SQL direct' off again. Now what is displayed? 4) The user now saves the query. Again, what is in the definition now? Would it change if the save happened while 'Run SQL Direct' was true. I know that the thinking is that this type of query may not require 'Run SQL Direct', the queston is - if one starts by bringing in a query and then switches modes will that be allowed. It seems to me that it should be, but not sure if you can then support a trip back. The next question is about section 1.3 Query Designer You are showing that queries will be displayed using the same icon as the Base main window. The mockup also shows tables using the same icon used for tables in the Base main window. My question then is about views. The current verson of the dociment doesn't mention views, and I take this to mean that support for them will remain as is. In the current application however the icon for a view is the same as a query, so a user will not have the icon as a reference point in the query designer. That's it for now...I have some questions on section 1.4 but need to think about this more clearly before asking them.. Thanks Drew