Andrew Jensen wrote:
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]


Believe it or not, i was so confused when i started trying to use other dbs other than MS because of the term "views" that i thought i'd never get it figured out.  i wanted to change to not only the "base" db used by OOo but to Postgresql because it would allow us to have multiple users on the one db, something about which our "IT" dept. has been complaining recently and telling us that we are going to have to purchase another db program??!!, something which i suspect will cost us in the thousands of dollars.  They say that all our crashes are bec. MS just doen't handle multiple users very well --  we've only got about 14 - 15 users on the thing but it crashes every couple of months or so anyway...

Well, guys, have a beautiful day!  :)
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to