Frank Schönheit - Sun Microsystems Germany wrote:
Up to now, i haven't been able to open the query in Edit mode and insert a calculated field or column. Is this possible?4.We need to be able to create queries and the queries need to be editable, i.e. we need to be able to add another field instead of recreating the query from scratch. As far as i can tell, this is not yet possible.I suppose I didn't really get you here, since Base actually *is* able to edit existing queries. Can you elaborate?
5. create one or more forms through which we can input the information, delete it and/or alter it. Here, we pretty much use one form which we have created to input most of the data. On this form that other db program has allowed us to place buttons (or create menu items) which basically run reports or produce a letters or paper forms to be filled out by the family which contain the _current_ family's info. This was a very basic click (create button) and select (Which Query, Form or Report do you wish to run?) procedure. We are unable to do this in Base yet.In fact that's not possible ATM.6. and finally, some way of getting the information out. ... So i'm very happy to see that Base is finally coming along and now has a more powerful Report Writer. However it still seems to have a long way to go. We can't change the size of the second GUI column to make it smaller. We can't change the rulers so that they read in inches, for example. We don't know what they read in now.centimeters. This issue is known as problem 85303 now: http://www.openoffice.org/issues/show_bug.cgi?id=85303.It would be nice if the vertical ruler on the left hand side read all the way from the top of the form to the bottom, instead of being divided into sections.Sorry, this wouldn't work out: When you execute the report, it is *not* that all sections, as in the designer, are simply put after each other. That is, if in the designer, you have a report header of 2 inches, a detail band of 1 inches, and a report footer of 2 inches, then with one large ruler, the report footer would start at 3 inches. However, when you execute the report, then the report footer would start at "2 + ( n * 1 )" inches, since the detail section is *repeated* for every record which is printed. So, it doesn't make any sense to have one large ruler, it would prevent you numbers which are completely meaningless.Printing still seems to be an art; the printout still doesn't look like what is looks like in the layout screen.Not sure about this ... well, the basic idea of the designer (if this is what you mean with "layout screen") is to design different sections (report/page/group header/footer, detail section), and repeat those sections, as required by the reported data, multiple times. By concept, the printout cannot look like the design ... ... /me is confused. I suppose you mean something different, so could you please go into detail here?7. just before i went to sleep, i remembered this too and began to dispair that we'd ever find a db that could easily replace MSA. i remembered that Base is not multiuser.Indeed. Before Base becomes multi-user, we need to solve the file format problem, which was recently discussed in a sub thread initiated by Andreas Saeger. The current file format is simply unusable for multi user access. Thanks & Ciao Frank Thank you Frank. See #4 above. Thanks for the responses to the others and have a great afternoon! :)
smime.p7s
Description: S/MIME Cryptographic Signature
