Fred Frazelle wrote:

'because at work we pretty much put the db together and then just work with it. .....

I did not mean to be overly assertive Fred,

Actually your response offers plenty of information. First - somethingt that Frank has mentioned a couple of times - that of whom the target user for Base is. I would say that for someone that is going to build one application and then "....almost forget how we put it together", just changing from having to work with three terms ( tables, views and queries ) to being able to work with just two ( tables and queries ) would have to be a big plus. Eliminating even one step, no matter how small, would also be a big plus. Bottom line is that I know, from pervious messages here, that Frank and his team are diligently working towards an application that addresses your needs.

The main thing we used this for was what you mentioned above: the ability to be able to update any of the columns. The other thing which we use quite a bit is the replaceable parameters option.
   i hope this helps.


Precisely my point. I spent more then a couple of hours this weekend thinking about this, and trying to come up with use case scenarios where having the ability to base a query on a query would offer some real enhancement for a non-IT specific office user. ( Perhaps not a good discription of the user, but hopefully everyone understands what I mean ) I keep running into a situation where the real benefit is not this feature at all, but rather some tangenical functionality. For example having the designer be a bit smater, or the fact that when a calculated field is in a result set, as the update command should not it trys to write data to the calculated field. The fact that one must have a left outer join in order to make a result set, joining two tables, updatable but then not allowing multile outer joins - so a thind table can not be part of this query. Anyway, I am beginning to ramble - and I have much of these comments in a document I am finaliziing and will put up for whatever use it may be later this week.

Drew





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to