[documentation-dev] Mid level Base tutorial
Mariano, I'll reply in more detail re licensing and formatting when I get home from vacation on March 1. Meanwhile I'm glad to see others stepping up to help with editing. --Jean - To unsubscribe, e-mail: dev-unsubscr...@documentation.openoffice.org For additional commands, e-mail: dev-h...@documentation.openoffice.org
Re: [documentation-dev] Mid Level Base Tutorial
Frank et al, Perhaps I yelled too soon! I have found an .odt file "OpenOffice.org Style Guide for US Documentation". This looks to be most of what I need. There is a sample Title Page included, and good advice for other things. I can get started with it, unless there is something else I need to know. Bill Frank Peters wrote: Bill, I am doing some proof reading and formatting for Mariano Casanova's tutorial. What I need is a template for the final document. I did have an stw file called "OOoUSDocument-template", but it seems I have lost it. I cannot seem to find anything like it on the web site now. Is there an odt version available? I am assuming this would be the appropriate format to use for the tutorial. Please correct me if there is a better way. I don't think that we have an agreed template for this sort of thing. But it would be good to have one. Is there something we could borrow from the OOoAuthors guys? Frank - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid Level Base Tutorial
Bill, I am doing some proof reading and formatting for Mariano Casanova's tutorial. What I need is a template for the final document. I did have an stw file called "OOoUSDocument-template", but it seems I have lost it. I cannot seem to find anything like it on the web site now. Is there an odt version available? I am assuming this would be the appropriate format to use for the tutorial. Please correct me if there is a better way. I don't think that we have an agreed template for this sort of thing. But it would be good to have one. Is there something we could borrow from the OOoAuthors guys? Frank -- Frank Peters Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid Level Base Tutorial
Frank, I am doing some proof reading and formatting for Mariano Casanova's tutorial. What I need is a template for the final document. I did have an stw file called "OOoUSDocument-template", but it seems I have lost it. I cannot seem to find anything like it on the web site now. Is there an odt version available? I am assuming this would be the appropriate format to use for the tutorial. Please correct me if there is a better way. Bill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level base tutorial
Mariano Casanova wrote: Any Base experts that can help me finish part III? Do you mean Base or Basic? You mentioned you'd need some Basic experience. Frank -- Frank Peters Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid level base tutorial
Frank and Mariano, I have the .odt downloads. I will get to work. Bill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid level base tutorial
Frank: Any Base experts that can help me finish part III? Mariano. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level base tutorial
Excellent. I see that your guys are set :-) Frank Mariano Casanova wrote: Hello William, and thank you for offering help. I am sending you parts I, II and III in ODT format. Please let me know if you have any trouble receiving them. Also, feel free to contact me for any reason. Mariano. --- [EMAIL PROTECTED] wrote: From: William Marchant <[EMAIL PROTECTED]> To: dev@documentation.openoffice.org Subject: Re: [documentation-dev] Mid level base tutorial Date: Mon, 04 Aug 2008 21:04:08 -0300 Frank, I have not been active for a while (several years I guess), but I still read the documentation mail. Mariano has a project which I think I am fitted to help with. I have downloaded all three parts of the Base tutorial. A cursory look at Part I shows me a number of places where proof reading would be useful. I can do that, as well as suggest some formatting. Mariano's downloads are PDF. Can I get ODT versions please? Bill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Frank Peters Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level base tutorial
Hello William, and thank you for offering help. I am sending you parts I, II and III in ODT format. Please let me know if you have any trouble receiving them. Also, feel free to contact me for any reason. Mariano. --- [EMAIL PROTECTED] wrote: From: William Marchant <[EMAIL PROTECTED]> To: dev@documentation.openoffice.org Subject: Re: [documentation-dev] Mid level base tutorial Date: Mon, 04 Aug 2008 21:04:08 -0300 Frank, I have not been active for a while (several years I guess), but I still read the documentation mail. Mariano has a project which I think I am fitted to help with. I have downloaded all three parts of the Base tutorial. A cursory look at Part I shows me a number of places where proof reading would be useful. I can do that, as well as suggest some formatting. Mariano's downloads are PDF. Can I get ODT versions please? Bill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level base tutorial
Frank, I have not been active for a while (several years I guess), but I still read the documentation mail. Mariano has a project which I think I am fitted to help with. I have downloaded all three parts of the Base tutorial. A cursory look at Part I shows me a number of places where proof reading would be useful. I can do that, as well as suggest some formatting. Mariano's downloads are PDF. Can I get ODT versions please? Bill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid level base tutorial
Frank: At this moment I am focusing on part III (and final) of the Mid Level Base Tutorial. Content of Parts I and II is basically completed and now requires prof reading and maybe layout design. Part III covers the specifics of coding with base the features discussed in parts I and II. It already analyzes the coding of the database and its structure of connections, focusing on the Create and Constraint SQL commands (thanks Drew!). Now is turn to create the forms for data input and the reports. According to Drew Jensen, the extra functionality required involves some ooBasic. I Need the assistance of someone who would know how to do this and would appreciate any volunteers. My goal is to finish this tutorial before September starts. The tutorial so far can be found here: http://documentation.openoffice.org/servlets/ProjectDocumentList?folderID=778&expandFolder=778&folderID=597 Thanks in advance. Mariano. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid level base tutorial
Frank: Thanks for your guidance. I have uploaded the three parts for the tutorial as promised. Parts I and II could benefit from a kind reader that spots technical errors or grammatical sins. I am still working on part II and, clearly, on part III. Part II requires that I include the reports for the example developed in the tutorial, which has been prepared in another document and will be added soon. But part III requires an expert that can explain to me how to produce the forms and reports the way that they are described in the tutorial. Drew Jensen helped me tremendously with the coding for the database and the relationships. He was also able to review my drafts for the forms and reports and told me that the desired functionality is possible using some ooBasic. I can only hope that Drew will return soon from his time off because he sure knows his craft. But in the mean time I really need you to help me get in touch with someone that can guide me through this. I really want to have a complete and useful tutorial soon. Thanks in advance. Mariano. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level base tutorial
Mariano Casanova wrote: I will convert the Tutorial to PDF and upload the files to the site you pointed. I will create a folder inside the Base folder with the three parts of the tutorial instead of one long file given that they are in different stages of completion at this moment. I do not see an "up-load" or "create new folder" links. How do I have access to them? When you're logged in you should see two links at the top of the Documents&Files page to create a folder and a file, but you need to be logged in. Frank -- Frank Peters Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid level base tutorial
Frank: I will convert the Tutorial to PDF and upload the files to the site you pointed. I will create a folder inside the Base folder with the three parts of the tutorial instead of one long file given that they are in different stages of completion at this moment. I do not see an "up-load" or "create new folder" links. How do I have access to them? Thanks for your help. M. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level base tutorial
Mariano Casanova wrote: Frank: ---Frank Peters ([EMAIL PROTECTED]) wrote: This has been a fun project and I have learned a lot. The goal has been to enable non-initiated users to build fairly complex databases with Base. I feel that we are very close to that objective. Any help in this last phase is deeply appreciated. Sure. Where can I find it? Frank At this moment, the body of the tutorial is in 3 .odt documents. The section that is not finished has text boxes and arrows(to call attention to segments where I need more info) but their layout is lost when I try to convert them to HTML. The same seems to happen to some tables I use throughout the tutorial. We can provide them as ODF and PDF to conserve layout. I have been offered space at a web-site but I don't know how to make the files available for download. I am sure that there is an easy way to allow access to these files (I just don't know it) so any instructions will be very welcomed. For now, you could upload them to documentation.openoffice.org at http://documentation.openoffice.org/servlets/ProjectDocumentList You can create a new subdirectory and upload the files. Let me know if you encounter any difficulties. I can then make themn available through the doc.oo.o website and link to them from the main page and from inside the wiki. Thanks Frank -- Frank Peters Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid level base tutorial
Frank: ---Frank Peters ([EMAIL PROTECTED]) wrote: >> This has been a fun project and I have learned a lot. The goal has >> been to enable non-initiated users to build fairly complex databases >> with Base. I feel that we are very close to that objective. Any help >> in this last phase is deeply appreciated. > >Sure. Where can I find it? >Frank At this moment, the body of the tutorial is in 3 .odt documents. The section that is not finished has text boxes and arrows(to call attention to segments where I need more info) but their layout is lost when I try to convert them to HTML. The same seems to happen to some tables I use throughout the tutorial. I have been offered space at a web-site but I don't know how to make the files available for download. I am sure that there is an easy way to allow access to these files (I just don't know it) so any instructions will be very welcomed. Mariano. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid Level Base Tutorial
Mariano, I am proud to announce the completion of 3/4 of the Base tutorial that advances to a medium level of complexity. Part I is being polished and part II is basically locked. That's great news. To be honest, I was fighting with Base myself lately and I cannot wait to have a look at the tutorial to learn more myself. Thank you and Drew so much for doing this! Part III, that concerns itself with the production of forms that use functions and some OObasic and reports that dump to Calc, is still on the works. Drew Jensen has helped me providing some invaluable technical information. I am hoping that a third party would want to read the drafts -with fresh eyes- and check on any technical information that I could have misinterpreted or any grammar sins I could have slipped. I would also need help with completing part III now that Drew is in fact taking some time off from this project. I see if I can have a look or find someone here to look at it. Frank, Once these pages have been reviwed by peers at dev-documentation, I would like to publish them through all available channels. I would appreciate your guidance to do this. I'd be happy to assist. This has been a fun project and I have learned a lot. The goal has been to enable non-initiated users to build fairly complex databases with Base. I feel that we are very close to that objective. Any help in this last phase is deeply appreciated. Sure. Where can I find it? Frank -- Frank Peters Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid Level Base Tutorial
I am proud to announce the completion of 3/4 of the Base tutorial that advances to a medium level of complexity. Part I is being polished and part II is basically locked. Part III, that concerns itself with the production of forms that use functions and some OObasic and reports that dump to Calc, is still on the works. Drew Jensen has helped me providing some invaluable technical information. I am hoping that a third party would want to read the drafts -with fresh eyes- and check on any technical information that I could have misinterpreted or any grammar sins I could have slipped. I would also need help with completing part III now that Drew is in fact taking some time off from this project. Frank, Once these pages have been reviwed by peers at dev-documentation, I would like to publish them through all available channels. I would appreciate your guidance to do this. This has been a fun project and I have learned a lot. The goal has been to enable non-initiated users to build fairly complex databases with Base. I feel that we are very close to that objective. Any help in this last phase is deeply appreciated. Mariano Casanova. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level Base tutorial
Mariano Casanova wrote: Just a short note to let you know that the work on the mid level Base tutorial is advancing, even if we are under the radar sometimes. There is a lot of information to digest, process, select and organize in educational terms. Drew Jensen has been invaluable help. Thanks for the status, Mariano. I am curious to see what you come up with. I already had a request for Base documentation. This is a severe gap in the doc set, so your efforts will be highly appreciated! Frank -- Frank Peters Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid level Base tutorial
Hi Frank, Just a short note to let you know that the work on the mid level Base tutorial is advancing, even if we are under the radar sometimes. There is a lot of information to digest, process, select and organize in educational terms. Drew Jensen has been invaluable help. Mariano - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level Base tutorial
Mariano Casanova wrote: Hi Drew, nice to hear from you. I am very excited about ending this job and being able to coordinate with you. Please let me know if you still have the forms and reports for the example or if you need them again. I think that they pretty much help delineated the end result desired. I will be waiting for you instructions. I think I have them all - but if it isn't that much of a problem could you just bundle the whole kit-n-caboodle into a zip file and attach it to a direct email at drewjensen.inbox AT gmail.com - that way I;m sure to have your latest product and won't waist any of your or my time working something outdated. Thanks Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid level Base tutorial
Hi Drew, nice to hear from you. I am very excited about ending this job and being able to coordinate with you. Please let me know if you still have the forms and reports for the example or if you need them again. I think that they pretty much help delineated the end result desired. I will be waiting for you instructions. Cheers, Mariano - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level Base tutorial
Mariano Casanova wrote: Hello Frank, I have not received response from Drew, either to my open letter on Jan 9th nor to mail sent to a personal account. Do you know if he is still participating or maybe on vacation? At this moment the tutorial aims to explain how to actually implement with BASE the options explored on the earlier part of the tutorial. Drew has explained to me that 00Basic and UNO coding are required. Drew, being the expert on these matters, was going to explain and teach me how to use them. I appreciate any information. Thanks, Mariano Casanova I missed the open letter - my fault. I can give you a couple of, pretty much, full time days starting tomorrow on this. I'll see how far I can get and put it all up for download. Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level Base tutorial
Hello Frank, I have not received response from Drew, either to my open letter on Jan 9th nor to mail sent to a personal account. Do you know if he is still participating or maybe on vacation? At this moment the tutorial aims to explain how to actually implement with BASE the options explored on the earlier part of the tutorial. Drew has explained to me that 00Basic and UNO coding are required. Drew, being the expert on these matters, was going to explain and teach me how to use them. I appreciate any information. Thanks, Mariano Casanova - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level Base tutorial
Hi Drew! I am happy to see that you are ready to continue with this project. We certainly didn't make it for the Nov. 15 date. Well, we do what we can. The last part of the tutorial has to do with explaining how to code the design that was developed in the previous parts of the tutorial. I am planing to start with the the input interface for clients and their phone numbers (this includes the MDs and psychiatrists tables too). The tricks here are including an automatic time stamp and having the ADD PHONE button work every time it is called. This single button is very important because is archetypical of all one-to-many conditions and a resource that people using base might use often. I understand that this will require using OOoBasic Script, which I find very exciting, and the use of the UNO object or something like this. Of course, I am counting on you to show me how to do it. What I have in mind is that I ask you as a layman and you answer as an expert. By the way, I remember that you said that the Phone number table would also require a one-to-many relationship with the Patient table (instead of the one-to-one I had declared. The complete set of cardinals I had declared was 1..n (from patient to phone record) and 1..1 (from phone record to patient). I am still confused as of why and hope that you can enlighten me. The other thing that we need is to show how to use the contents of a table to appear in a drop-down list, for example, the name of the psychiatrists, but then make sure that the Key and not the name is recorded as the foreign key. These four elements would be a good starting point. As you can see, I pretty much follow the questions I had for you related to the input forms drafts I sent you, skipping the ones that get repeated. You had offered joining on a virtual whiteboard or something like that. Let me know is this is still possible and how and when we could do it. Otherwise, your textual explanations and my constant questions would do. On a related note, Jane is working on a Base manual and she thinks that some of the text in our project could be useful. I am updating some elements in the tutorial (like deletion options and relationships) and would like you to review them before I send them to her. Just in case I don't hear from you before Thanksgiving day: Happy Thanksgiving Day!! Mariano - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level Base Tutorial
Mariano Casanova wrote: Hi Drew: Could you please comment on this text? Particularly if something is wrong or incomplete. Thanks! Mariano On table attributes of not null, unique and key Base allows you to specify certain attributes for the columns in your tables. In this tutorial we will consider the following options: Key: This option tells Base that this column will hold the primary key of the table. Base will prepare then to see it associated with other tables. Tells the database that this column is part of the key - it may be the entire key, or it may one of a set of columns that make up the key. In the case of Base these compound key columns must also be adjacent. Unique: When you specify this option, Base will make sure that records in this column are not repeated. If, for example, you specify that the 'surname' column be unique, then the second time you try to enter 'Dumas' Base will reject it as an invalid entry. It makes a lot of sense to make sure that a column set to KEY is also set to UNIQUE. Setting a column as part of the Primary Key automatically sets it to unique, no need to set this separately. Not null: This option means that records can not be left with this attribute empty. Base will display an error message if you try to enter a record that leaves a NO NULL column empty. This forces whomever is using your database to at least have the information requested in the NOT NULL columns if they want to entrer the record. For example, if you set the 'surname' and 'date of birth' as NOT NULL, then a user can not input a new author if he doesn't have at least the surname and the date of birth. Again, it makes sense that Key columns are also set to NOT NULL. This can be a little bit of a problem. For example you can tell the database engine that a column is NOT NULL and set a DEFAULT value. For instance a date field can be set as DEFAULT CURRENT_DATE, so that if a new record is entered and no value is given for this column it is automatically set to the current date. In all versions of Base up to and including the coming 2.3.1 release this caused a problem, because the GUI controls refused to allow you to send a NULL value to a column marked as NOT NULL, even if there was a default value setup for it. In version 2.4 this will finally be addressed in that a per database option will then be available to turn off this check, allowing NULLs to be sent to a column designated as NOT NULL. The other problem with this is that under Base there is no mechanism using the GUI table editor to set these default values for a column. In the GUI table editor there is a property 'Default Value', but this is a string only constant that will be used by UI controls in the Base front end, not the database engine proper. This problem is not addressed in the 2.4 release, so it is still necessary to enter default values at the database level via the SQL window. On the different deletion options and what they mean. Because being able to relate the object in one class to another object in another class is so important, and the strength of relational databases, special care must be placed on the subject or deleting records. Think about this: Let's say that there is an an author that wrote only one book and you discover that you no longer have that book in your collection. As you update your database and erase that title, what will happen to the 'author' information? Should it be deleted too? Should it be kept as an historical record or in case you find and buy that book again? Actually, both options are valid and you can chose the one that reflects the purpose of your database best. But your application will not know what to do unless you make explicit what your preference is. For this reason, when you are developing your application and defining relationships, Base will ask you how to handle the deletion of records and will offer you the following options. This is what they mean: No action: Base will not delete the record but... Delete Cascade: With this option, Base will delete the record you are requesting to delete and will also delete all other records that have the deleted record's key as a foreign key. This option is called cascade because it elicits the image of a deletion creating further deletions. Set Null: With this option, Base will delete the record you are requesting but will not delete the others related to it. Instead it will erase their foreign keys to reflect that they are no longer associated. Note that this requires that NUT NULL is not a condition of the foreign key column. Set Default: When deleting an object, the foreign key column of the associated tables will be populated with a default parameter that you previously specified. OK, just to be very clear on this. Let's assume two tables: Authors( AuthorID, Name, DOB) Library( AuthorID, BookID, Title, Published Date,.) Library.AuthorID is set a
Re: [documentation-dev] Mid level Base Tutorial
Hi Drew: Could you please comment on this text? Particularly if something is wrong or incomplete. Thanks! Mariano On table attributes of not null, unique and key Base allows you to specify certain attributes for the columns in your tables. In this tutorial we will consider the following options: Key: This option tells Base that this column will hold the primary key of the table. Base will prepare then to see it associated with other tables. Unique: When you specify this option, Base will make sure that records in this column are not repeated. If, for example, you specify that the 'surname' column be unique, then the second time you try to enter 'Dumas' Base will reject it as an invalid entry. It makes a lot of sense to make sure that a column set to KEY is also set to UNIQUE. Not null: This option means that records can not be left with this attribute empty. Base will display an error message if you try to enter a record that leaves a NO NULL column empty. This forces whomever is using your database to at least have the information requested in the NOT NULL columns if they want to entrer the record. For example, if you set the 'surname' and 'date of birth' as NOT NULL, then a user can not input a new author if he doesn't have at least the surname and the date of birth. Again, it makes sense that Key columns are also set to NOT NULL. On the different deletion options and what they mean. Because being able to relate the object in one class to another object in another class is so important, and the strength of relational databases, special care must be placed on the subject or deleting records. Think about this: Let's say that there is an an author that wrote only one book and you discover that you no longer have that book in your collection. As you update your database and erase that title, what will happen to the 'author' information? Should it be deleted too? Should it be kept as an historical record or in case you find and buy that book again? Actually, both options are valid and you can chose the one that reflects the purpose of your database best. But your application will not know what to do unless you make explicit what your preference is. For this reason, when you are developing your application and defining relationships, Base will ask you how to handle the deletion of records and will offer you the following options. This is what they mean: No action: Base will not delete the record but... Delete Cascade: With this option, Base will delete the record you are requesting to delete and will also delete all other records that have the deleted record's key as a foreign key. This option is called cascade because it elicits the image of a deletion creating further deletions. Set Null: With this option, Base will delete the record you are requesting but will not delete the others related to it. Instead it will erase their foreign keys to reflect that they are no longer associated. Note that this requires that NUT NULL is not a condition of the foreign key column. Set Default: When deleting an object, the foreign key column of the associated tables will be populated with a default parameter that you previously specified. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid level Base Tutorial
Drew: I received the UML design. First, I am not sure if the Account and TransactionType tables complement or replace my more modest Payment table. I have the feeling that they replace it, but it remains in the design. Let me know. Also, I don't see the change in the Patient phone table, other than it adds a primary key. I though I only needed the patient ID foreign key here. If this is not true, then I am missing something (and the therapist phone box will also require a primary key). Please let me know. The only change I want to do is to add a "Value" attribute in the Assignment table, to record the different fees the patients cold be charged (and to help calculate debits and credits) The last thing has to do with whether we need a Office table, to keep track of the use of office space for seeing clients. You did mention that in the past, while talking about limited resources. I have been trying to keep the table not too complicated. Please see the Draft of Reports for Tutorial document that I sent you for an analysis of options. After we decide on this, I will be ready to lock the design. I read your comments to the Forms I sent you. Now I know what can be done and what is it going to take. I am now sending you the draft of Reports that the tutorial aims to develop. with this, you should have a complete picture of the scope of the example in the tutorial, the skills it aims to teach and the tasks that remain for us to accomplish. I went to check on the forums as you suggested. I felt that the forum that you are working on developing is very clear to navigate and has a friendly feeling. However, it does not have much information yet. The other one had many more contributions but I found it to be somewhat cryptic and maybe it is somewhat difficult to understand for non-initiated people like me. So let's start simple. Can we build the form for the contact information? This one is rather straightforward except for the Add New Phone button. Of course, I want to focus on this element as the other elements like boxes and labels are covered in other tutorials. Well, I hope to make this the next step. But before, check on the document I sent you and on helping me decide to lock the design. I hope that your toes are doing better. Cheers, Mariano. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level Base Tutorial -- licensing question
Hi Jean, > Many authors want the protection and control of the PDL for their > work; I have no argument with anyone who does. However, the PDL > has some requirements that many of us think are a major nuisance > for user documentation, especially items that are updated > frequently to reflect changes in the software. I would like to learn what what these requirements are that make you oppose PDL. I don't want to get into an argument around license models but I'd like to understand better why our groups are using different licensing models (both of which are open source licenses). > Therefore, many of us prefer the Creative Commons Attribution > License (which allows easier reuse of material), so that is what has > been used for guides produced by OOoAuthors. As far as I know, the Base > Guide will be published under CC as well. > > So... you need to decide which license(s) you want your work to > come under. Actually, I don't think there is any reason why the > same material can't be published under more than one license, but > I am definitely not an authority on intellectual property. Frank -- Frank Peters, Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[documentation-dev] Mid-level Base Tutorial -- licensing question
Mariano, Regarding the tutorial you are writing, do you have a preference on the license under which it will be released? (If you have already stated a preference, I apologise for missing that note.) The OOoAuthors group uses the Creative Commons Attribution License for its user guides, but the main OpenOffice.org project requires the Public Documentation License (PDL) for editable work placed on the main website (PDFs can be under Creative Commons). Material on the wiki can be under either license. I recommend that you read these pages regarding licensing: http://www.openoffice.org/license.html http://www.openoffice.org/FAQs/faq-licensing.html Many authors want the protection and control of the PDL for their work; I have no argument with anyone who does. However, the PDL has some requirements that many of us think are a major nuisance for user documentation, especially items that are updated frequently to reflect changes in the software. Therefore, many of us prefer the Creative Commons Attribution License (which allows easier reuse of material), so that is what has been used for guides produced by OOoAuthors. As far as I know, the Base Guide will be published under CC as well. So... you need to decide which license(s) you want your work to come under. Actually, I don't think there is any reason why the same material can't be published under more than one license, but I am definitely not an authority on intellectual property. --Jean - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Jean Hollis Weber wrote: Joe Smith wrote: Are there any plans to include a section comparing, in practical terms, which database type to choose for some typical projects? [...] This is a critical choice that the current UI gives almost no help with. It then falls to written documentation to explain the concepts and assist in choosing the right one. This is a good topic to include in the Base Guide, which obviously will be rather more comprehensive than a tutorial. IIRC, the outline includes a section or chapter on planning. Ahh, yes! You are exactly right Jean. As a member of the peanut gallery ;-) I had conflated the goals of the two projects, and this is definitely an introductory concept more appropriate for the Guide. I absolutely understand the need to have a clear goal and audience and to stick to it--ruthlessly when necessary.
Re: [documentation-dev] Mid-level base tutorial
Jean, Your correct. That would be a good place for this, kind of the natural place I suppose. OK, which outline is being updated then...I am so easily confused sometimes...the file that you sent out or the wiki page? Drew On 9/27/07, Jean Hollis Weber <[EMAIL PROTECTED]> wrote: > Joe Smith wrote: > > > > Are there any plans to include a section comparing, in practical terms, > > which database type to choose for some typical projects? > > [...] > > This is a critical choice that the current UI gives almost no help with. > > It then falls to written documentation to explain the concepts and > > assist in choosing the right one. > > This is a good topic to include in the Base Guide, which > obviously will be rather more comprehensive than a tutorial. > IIRC, the outline includes a section or chapter on planning. > > --Jean > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Joe Smith wrote: Are there any plans to include a section comparing, in practical terms, which database type to choose for some typical projects? [...] This is a critical choice that the current UI gives almost no help with. It then falls to written documentation to explain the concepts and assist in choosing the right one. This is a good topic to include in the Base Guide, which obviously will be rather more comprehensive than a tutorial. IIRC, the outline includes a section or chapter on planning. --Jean - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Ah, I was just having a little fun - at your expense... Truth is those are good points, but this is Mariano's show and therefor his call on something like that. Not too mention, if it weren't for feature creep we would be having this conversation by chiseling glyphs in a slab of stone and hurling them with great exuberance at each other ;>) On 9/27/07, Joe Smith <[EMAIL PROTECTED]> wrote: > Andrew Jensen wrote: > > LOL - Joe in the software development world we would call that feature > > creep! > > Ouch. Well at least it was good for a chuckle. > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Andrew Jensen wrote: LOL - Joe in the software development world we would call that feature creep! Ouch. Well at least it was good for a chuckle.
Re: [documentation-dev] Mid-level base tutorial
LOL - Joe in the software development world we would call that feature creep! On 9/26/07, Joe Smith <[EMAIL PROTECTED]> wrote: > Andrew Jensen wrote: > > ... > > Finally, there should be some mention of the fact that Base is not > > actually married to the embedded HSQLdb engine at all. The fact that > > it ships with this is more a matter of convenience, the design of the > > module is such that additional database engines could be supported in > > both embedded and in client / server environments. Not to mention the > > support for working with a spreadsheet as a data store, text files and > > dBase files. In each of these cases the Base data type will map to > > slightly different data types in the engine. Perhaps though this is > > better left for an advanced treatment. > > ... > > Are there any plans to include a section comparing, in practical terms, > which database type to choose for some typical projects? > > E.g. if you need a database that's a single file and can be easily > e-mailed to another office, you probably want the embedded engine > (HSQLDB for now). > > Or, if you need a database that can be easily edited or massaged en > mass, a spreadsheet might be the best option (if you can live with the > no-update bug). > > Or, if you have 500,000 records, to be accessed concurrently by 20 > employees, you probably don't want to use csv files. > > This is a critical choice that the current UI gives almost no help with. > It then falls to written documentation to explain the concepts and > assist in choosing the right one. > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Andrew Jensen wrote: ... Finally, there should be some mention of the fact that Base is not actually married to the embedded HSQLdb engine at all. The fact that it ships with this is more a matter of convenience, the design of the module is such that additional database engines could be supported in both embedded and in client / server environments. Not to mention the support for working with a spreadsheet as a data store, text files and dBase files. In each of these cases the Base data type will map to slightly different data types in the engine. Perhaps though this is better left for an advanced treatment. ... Are there any plans to include a section comparing, in practical terms, which database type to choose for some typical projects? E.g. if you need a database that's a single file and can be easily e-mailed to another office, you probably want the embedded engine (HSQLDB for now). Or, if you need a database that can be easily edited or massaged en mass, a spreadsheet might be the best option (if you can live with the no-update bug). Or, if you have 500,000 records, to be accessed concurrently by 20 employees, you probably don't want to use csv files. This is a critical choice that the current UI gives almost no help with. It then falls to written documentation to explain the concepts and assist in choosing the right one.
Re: [documentation-dev] Mid-level base tutorial
Not a problem at all. There is a section on this in the HSQLdb users manual - a somewhat outdated version of which can be found on-line at http://hsqldb.org. The document included with the HSQLdb distribution package is actually more current then the wed site, and I will email a copy the latest one to you directly. There are few things to really cover for an intermediate level with this, IMO. One is that Hsqldb is a pure java implementation and each of those data types map directly to a java data type. In some cases multiple Base data types will map to a common java data type. Second - HSQldb has two modes of operations with respect to scalar values. Strict and relaxed - relaxed mode makes use of this multi-to-one mapping for some of the numeric types, so for instance you might have a field defined as a Small Int, in strict mode an attempt to write an Integer value would generate an error. Even though underneath the actual storage size allocated is an integer for both Small Int and Int. In relaxed mode the larger value would be accepted, quietly. Finally, there should be some mention of the fact that Base is not actually married to the embedded HSQLdb engine at all. The fact that it ships with this is more a matter of convenience, the design of the module is such that additional database engines could be supported in both embedded and in client / server environments. Not to mention the support for working with a spreadsheet as a data store, text files and dBase files. In each of these cases the Base data type will map to slightly different data types in the engine. Perhaps though this is better left for an advanced treatment. One other point thing, by way of preempting a later question. Default functions available with Base. The HSQldb documentation gives very terse treatment to the supplied data functions and stored procedures. You will find a more expansive coverage at here: http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures I have managed to get through the numeric, string and date time functions so far - for each there where two steps taken. 1 ) Reviewed the HSQLdb source code and extracted any pertinent information regarding boundary conditions. For those where the function is actually just a wrapper around JRE supplied library function I have used text from the java docs. In a couple of cases actually adding functions to the wiki document that the HSQLdb left out of their manual by oversight. 2 ) Tested each one in the three Base query modes. The GUI query designer, the SQL view of the query designer and when passed directly to the engine without any pre-processing. Not all functions are available in all nodes, or they may require slightly different syntax in different modes. These differences have been noted for each - but they are getting very close to full coverage with this last release of Base. At this point that document needs to be finished for the aggregate functions and to cover some of the quirks that HSQLdb imposes, and not found in most other engines. Finally it needs to cover the commands such as CASE WHEN, NULLIF and the like. There is nothing in the document yet but I have, I feel, a good set of examples already compiled for each. I was hoping that this work with you would be the perfect way to get that finished. The only thing I would need to point out is that my intention is to donate that document back to the HSQLdb project for use in there documentation also, as soon as it is finished. OK - enough for now. I'll get that HSQLdb users manual off to straight away. Drew On 9/26/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Frank has set up a OOo Docs Wiki where I intend to publish more polished > work. In the meantime I will accept Andrew's offer and will ask him for > details once I am ready to submit any material. > > Thank you all for your help and interest in this work! > > Andrew, I would like some help undewrstanding the variable types offered > by Base. I have not been able to find info about them and do not want to > make the assumption that they mean exactly what other database systems > understand them to be. > > I would appreciate any help on finding documentation about them or, if you > know their specs and how Base treats them, some lines from you. > > The variables are: > > Tiny Interger > Big Interger > Image (long var binary) > Binay (Varbinary) > Binary (fix) > Mamo (long var char) > Text(char) -fix > Text (varchar) > Text (varchar ignorecase) --> very interesting! > Number (numeric) > Decimal > Interger > Small Interger > Float > Real > Double > Boolean > Date > Time > Timestamp > Other -->?? > > I hope that this is not a headache for you. I truly believe that > understanding variable attributes is fundamental to a useful and reliable > data base design. > > Thanks again. > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands
Re: [documentation-dev] Mid-level base tutorial
Frank has set up a OOo Docs Wiki where I intend to publish more polished work. In the meantime I will accept Andrew's offer and will ask him for details once I am ready to submit any material. Thank you all for your help and interest in this work! Andrew, I would like some help undewrstanding the variable types offered by Base. I have not been able to find info about them and do not want to make the assumption that they mean exactly what other database systems understand them to be. I would appreciate any help on finding documentation about them or, if you know their specs and how Base treats them, some lines from you. The variables are: Tiny Interger Big Interger Image (long var binary) Binay (Varbinary) Binary (fix) Mamo (long var char) Text(char) -fix Text (varchar) Text (varchar ignorecase) --> very interesting! Number (numeric) Decimal Interger Small Interger Float Real Double Boolean Date Time Timestamp Other -->?? I hope that this is not a headache for you. I truly believe that understanding variable attributes is fundamental to a useful and reliable data base design. Thanks again. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Thanks, Drew. I thought that's what you meant, so thanks for confirming. Sounds ro me like your server is a good place for storing images for the working drafts of this document, since you and Mariano will be the main people working on it. --Jean Andrew Jensen wrote: yes, my server dishes up lots stuff to folks on the the forum, the wiki and as direct download via httpd addresses, the access I meant was for write / edit privileges. The other thing you are right about, and is a pleasure to see - is that this is a case of maybe too many options and not enough.. ;>0 On 9/25/07, Jean Hollis Weber <[EMAIL PROTECTED]> wrote: Putting them on the OOoAuthors website is another possibility. Whatever you guys choose, I think it should be somewhere that other people (such as me) can get to the figures too. Docs&Files & OOoAuthors both fulfill that request; an FTP server that allows others (without accounts) to view the directory and download the files would work too. --Jean Andrew Jensen wrote: If not, or maybe as an early alternative. I could set aside a slice on my ftp server and five Mariano an access account. Then link to these for the pages until the final files are ready to be moved to the wiki. On 9/25/07, Frank Peters <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: I will be adding drafts here as the writing progresses. I will also include links to the figures that I could need. I understand that I must harbor them elsewhere. You could upload them to the wiki, but that can be a bit cumbersome. Does anyone know if we could use the Documents & files section on the website for that? http://documentation.openoffice.org/servlets/ProjectDocumentList If that works, you can (after logging in) upload the figures there. Feel free to create a working directory for your purpose. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
yes, my server dishes up lots stuff to folks on the the forum, the wiki and as direct download via httpd addresses, the access I meant was for write / edit privileges. The other thing you are right about, and is a pleasure to see - is that this is a case of maybe too many options and not enough.. ;>0 On 9/25/07, Jean Hollis Weber <[EMAIL PROTECTED]> wrote: > Putting them on the OOoAuthors website is another possibility. > > Whatever you guys choose, I think it should be somewhere that > other people (such as me) can get to the figures too. Docs&Files > & OOoAuthors both fulfill that request; an FTP server that allows > others (without accounts) to view the directory and download the > files would work too. > > --Jean > > Andrew Jensen wrote: > > If not, or maybe as an early alternative. > > > > I could set aside a slice on my ftp server and five Mariano an access > > account. Then link to these for the pages until the final files are > > ready to be moved to the wiki. > > > > On 9/25/07, Frank Peters <[EMAIL PROTECTED]> wrote: > >> [EMAIL PROTECTED] wrote: > >> > >>> I will be adding drafts here as the writing progresses. > >>> > >>> I will also include links to the figures that I could need. I understand > >>> that I must harbor them elsewhere. > >> You could upload them to the wiki, but that can be a bit cumbersome. > >> > >> Does anyone know if we could use the Documents & files section on > >> the website for that? > >> http://documentation.openoffice.org/servlets/ProjectDocumentList > >> > >> If that works, you can (after logging in) upload the figures there. > >> Feel free to create a working directory for your purpose. > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Putting them on the OOoAuthors website is another possibility. Whatever you guys choose, I think it should be somewhere that other people (such as me) can get to the figures too. Docs&Files & OOoAuthors both fulfill that request; an FTP server that allows others (without accounts) to view the directory and download the files would work too. --Jean Andrew Jensen wrote: If not, or maybe as an early alternative. I could set aside a slice on my ftp server and five Mariano an access account. Then link to these for the pages until the final files are ready to be moved to the wiki. On 9/25/07, Frank Peters <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote: I will be adding drafts here as the writing progresses. I will also include links to the figures that I could need. I understand that I must harbor them elsewhere. You could upload them to the wiki, but that can be a bit cumbersome. Does anyone know if we could use the Documents & files section on the website for that? http://documentation.openoffice.org/servlets/ProjectDocumentList If that works, you can (after logging in) upload the figures there. Feel free to create a working directory for your purpose. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
If not, or maybe as an early alternative. I could set aside a slice on my ftp server and five Mariano an access account. Then link to these for the pages until the final files are ready to be moved to the wiki. On 9/25/07, Frank Peters <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > I will be adding drafts here as the writing progresses. > > > > I will also include links to the figures that I could need. I understand > > that I must harbor them elsewhere. > > You could upload them to the wiki, but that can be a bit cumbersome. > > Does anyone know if we could use the Documents & files section on > the website for that? > http://documentation.openoffice.org/servlets/ProjectDocumentList > > If that works, you can (after logging in) upload the figures there. > Feel free to create a working directory for your purpose. > > Frank > > > Drew, do you know if a Base application can distinguish between users > > (like through some kind of log-in page) and therefore, grant them > > different access to forms, reports (or other privileges)? > > > > Mariano. > > > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > -- > Frank Peters > Documentation Project Co-Lead > > The OOo Documentation Project: > SIGN UP - PARTICIPATE - CONTRIBUTE > IT'S FREE! NO OBLIGATIONS! > http://documentation.openoffice.org > http://wiki.services.openoffice.org/wiki/Documentation > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
[EMAIL PROTECTED] wrote: I will be adding drafts here as the writing progresses. I will also include links to the figures that I could need. I understand that I must harbor them elsewhere. You could upload them to the wiki, but that can be a bit cumbersome. Does anyone know if we could use the Documents & files section on the website for that? http://documentation.openoffice.org/servlets/ProjectDocumentList If that works, you can (after logging in) upload the figures there. Feel free to create a working directory for your purpose. Frank Drew, do you know if a Base application can distinguish between users (like through some kind of log-in page) and therefore, grant them different access to forms, reports (or other privileges)? Mariano. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Frank Peters Documentation Project Co-Lead The OOo Documentation Project: SIGN UP - PARTICIPATE - CONTRIBUTE IT'S FREE! NO OBLIGATIONS! http://documentation.openoffice.org http://wiki.services.openoffice.org/wiki/Documentation - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
That's fine, Drew. Thanks. We will drop this feature for now and focus on the other features. I will adjust the outline correspondingly. Mariano > Oh darn, that is too brief an answer to that question. > > The engine supports it, when used as an embedded engine in a Base file > however it is not directly supported. Using code to wrap around your > database solution one can take advantage of it again, but given this it > most likely would be more of an advanced subject. > > This support is a planned, maybe, feature for 3.x...so that is a good 12 > months off still. > [truncated] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Oh darn, that is too brief an answer to that question. The engine supports it, when used as an embedded engine in a Base file however it is not directly supported. Using code to wrap around your database solution one can take advantage of it again, but given this it most likely would be more of an advanced subject. This support is a planned, maybe, feature for 3.x...so that is a good 12 months off still. On 9/25/07, Andrew Jensen <[EMAIL PROTECTED]> wrote: > Hi, > > For the target reader you have in mind the best answer is no. > > On 9/25/07, [EMAIL PROTECTED] > <[EMAIL PROTECTED]> wrote: > > > I created a wiki page: > > > http://wiki.services.openoffice.org/wiki/Documentation/Dashboard/Tutorials/Base_(Mariano) > > > > > > Feel free to add content. > > > > > > Frank > > > > Thanks Frank! > > > > I will be adding drafts here as the writing progresses. > > > > I will also include links to the figures that I could need. I understand > > that I must harbor them elsewhere. > > > > Drew, do you know if a Base application can distinguish between users > > (like through some kind of log-in page) and therefore, grant them > > different access to forms, reports (or other privileges)? > > > > Mariano. > > > > > > - > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Hi, For the target reader you have in mind the best answer is no. On 9/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I created a wiki page: > > http://wiki.services.openoffice.org/wiki/Documentation/Dashboard/Tutorials/Base_(Mariano) > > > > Feel free to add content. > > > > Frank > > Thanks Frank! > > I will be adding drafts here as the writing progresses. > > I will also include links to the figures that I could need. I understand > that I must harbor them elsewhere. > > Drew, do you know if a Base application can distinguish between users > (like through some kind of log-in page) and therefore, grant them > different access to forms, reports (or other privileges)? > > Mariano. > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
> I created a wiki page: > http://wiki.services.openoffice.org/wiki/Documentation/Dashboard/Tutorials/Base_(Mariano) > > Feel free to add content. > > Frank Thanks Frank! I will be adding drafts here as the writing progresses. I will also include links to the figures that I could need. I understand that I must harbor them elsewhere. Drew, do you know if a Base application can distinguish between users (like through some kind of log-in page) and therefore, grant them different access to forms, reports (or other privileges)? Mariano. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Jean Hollis Weber wrote: I imagine that, as the writing progresses, it should be posted here. I also imagine that any questions I could have should also be posted here. If this is not the proper channel, please re-direct me. Please don't post drafts or diagrams to the list; attachments are a problem for many people. Put them somewhere on the web and post a link here. Discussion about the draft or diagram can take place on the list, and any questions are best sent to the list. The official way to handle drafts and other attachments is to put them on the OOoDocumentation website, by attaching them to an "issue". One of us can instruct you how to do that, if you're not already familiar with the IssueTracker process. You'll only need one "issue" for the tutorial; you (and others) can attach any number of drafts and other items (eg links to other info) to the issue. Another (relatively new) way is to use the OOoDocs wiki for developing the draft. Again, discussion could take place on this list, with the text on the wiki. If you want to use the wiki, it might be a good idea to have Frank or someone set up the initial page to make sure it's in the right place in the hierarchy. I created a wiki page: http://wiki.services.openoffice.org/wiki/Documentation/Dashboard/Tutorials/Base_(Mariano) Feel free to add content. Frank - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
On Fri, 21 Sep 2007, Joe Smith wrote: > [EMAIL PROTECTED] wrote: > > The tutorial is aimed to persons that have little or no knowledge in > > database design and that need to develop a functional application of > > mid-level complexity. This application would stand alone in their > > computers (as opposed to becoming a front end for a MySQL application > > harbored in some server with multiple users, for example). > > ... > > Such a document would fill a huge, huge gap, speaking as someone who > knows just enough about databases to get into trouble, and who gave up > banging his head against the wall trying to get Base to do solve simple > real-world tasks. > > I hope that the tutorial will be based around a real, working > downloadable database that actually does something useful, so that > people can see how to implement something they will use in real life. > Drew's tutorial example on oooforum was essential for me to get started, > but it never quite made it all the way to completion as a database > application, and I could never cross that last 20% of the distance to > get Base to do what I wanted. > > If a picture is worth a thousand words, a complete working example is > worth a whole book. > You may want to link the tutorial to http://www.geekgirls.com/databases_from_scratch_3.htm, which is just about the best explanation of database design and normalization that I've ever read. > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- J. David Eisenberg http://catcode.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Hi Jean, Marano, et al Mariano is the author I am just a helper, so it is his decision on how he want to work, IssueZilla or wiki or both. Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
[EMAIL PROTECTED] wrote: The tutorial is aimed to persons that have little or no knowledge in database design and that need to develop a functional application of mid-level complexity. This application would stand alone in their computers (as opposed to becoming a front end for a MySQL application harbored in some server with multiple users, for example). ... Such a document would fill a huge, huge gap, speaking as someone who knows just enough about databases to get into trouble, and who gave up banging his head against the wall trying to get Base to do solve simple real-world tasks. I hope that the tutorial will be based around a real, working downloadable database that actually does something useful, so that people can see how to implement something they will use in real life. Drew's tutorial example on oooforum was essential for me to get started, but it never quite made it all the way to completion as a database application, and I could never cross that last 20% of the distance to get Base to do what I wanted. If a picture is worth a thousand words, a complete working example is worth a whole book.
Re: [documentation-dev] Mid-level base tutorial
Mariano wrote: I imagine that, as the writing progresses, it should be posted here. I also imagine that any questions I could have should also be posted here. If this is not the proper channel, please re-direct me. Please don't post drafts or diagrams to the list; attachments are a problem for many people. Put them somewhere on the web and post a link here. Discussion about the draft or diagram can take place on the list, and any questions are best sent to the list. The official way to handle drafts and other attachments is to put them on the OOoDocumentation website, by attaching them to an "issue". One of us can instruct you how to do that, if you're not already familiar with the IssueTracker process. You'll only need one "issue" for the tutorial; you (and others) can attach any number of drafts and other items (eg links to other info) to the issue. Another (relatively new) way is to use the OOoDocs wiki for developing the draft. Again, discussion could take place on this list, with the text on the wiki. If you want to use the wiki, it might be a good idea to have Frank or someone set up the initial page to make sure it's in the right place in the hierarchy. It's really up to you and Drew which method you prefer to use during the writing and review stage; each method has its advantages and disadvantages. Eventually we want to have all the material available in several forms (including the wiki). --Jean - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Hi Drew, The tutorial is aimed to persons that have little or no knowledge in database design and that need to develop a functional application of mid-level complexity. This application would stand alone in their computers (as opposed to becoming a front end for a MySQL application harbored in some server with multiple users, for example). If it is possible to implement different security profiles for access to data and data manipulation (as proposed in 3.14 of the outline) then the assumption is that this application could be accessed by more than one user. If it turns out that the application can not differentiate between users without the use of massive coding, then this point will be dropped and the tutorial will assume that the application would have only one user. Your comments are always welcomed. Besides, changes in the outline are easier to implement now than later. Right now I am finishing the research that would allow me to start fleshing out the outline and that can help me find an example that will have educational value. When I find one, I will post it here as a UML diagram so we can discuss its merits. In the mean time, I would appreciate if you can tell me whether point 3.14 is possible or not and what would it require. The basic idea is that the application would grant different privileges (write or read, or access to all reports/forms or to certain reports/forms only) depending on who logs in. I am happy to know that you are interested in participating. Cheers, Mariano - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [documentation-dev] Mid-level base tutorial
Hello Mariano, I received your direct email with the first draft outline for the tutorial and have been waiting to see your post in the mailing list to respond. First - it is a very clean concise outline, IMO and I for one would be drawn to read it. However my first question would be - Who is this tutorial being written for? I have a number of comments, but they are premised on the target reader being an end user creating a Base embedded database for personal use ( One for use at work but only for themselves falls in that category to me ). If that is not your target audience then I won't waist your time with those comments. Otherwise, I am extremely excited to see someone working on this and will be quite happy to help. Till later, Drew On 9/19/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I would first like to thank Frank Petters, Scott Carr, Jean Weber and > Andrew Jensen for a warm reception and guiding me to this mailing list. > > My name is Mariano Casanova and I would like to help in the development of > a mid-level tutorial for Base. I have drafted a proposal centered on the > problem of establishing and using primary keys for populating and > retrieving records in several tables. I understand that Jean has already > posted the outline. My goal is that anyone that can read and has access to > a computer with OOo (regardless of their scholarly level) could understand > and apply these notions. Teaming up with someone fluent in the current > version of Base is fundamental so I can make the proper questions, draft > the proper examples and have him/her review the technical aspects of the > tutorial. Jane has suggested Andrew Jensen for this task and I hope that > he will be interested. > > I imagine that, as the writing progresses, it should be posted here. I > also imagine that any questions I could have should also be posted here. > If this is not the proper channel, please re-direct me. > > Again, thank you for the very welcoming reception. > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
[documentation-dev] Mid-level base tutorial
I would first like to thank Frank Petters, Scott Carr, Jean Weber and Andrew Jensen for a warm reception and guiding me to this mailing list. My name is Mariano Casanova and I would like to help in the development of a mid-level tutorial for Base. I have drafted a proposal centered on the problem of establishing and using primary keys for populating and retrieving records in several tables. I understand that Jean has already posted the outline. My goal is that anyone that can read and has access to a computer with OOo (regardless of their scholarly level) could understand and apply these notions. Teaming up with someone fluent in the current version of Base is fundamental so I can make the proper questions, draft the proper examples and have him/her review the technical aspects of the tutorial. Jane has suggested Andrew Jensen for this task and I hope that he will be interested. I imagine that, as the writing progresses, it should be posted here. I also imagine that any questions I could have should also be posted here. If this is not the proper channel, please re-direct me. Again, thank you for the very welcoming reception. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]