Customer Reviews

Database Programming with OpenOffice.org Base & Basic

5 star:		(3)
4 star:		(2)
3 star:		(0)
2 star:		(0)
1 star:		(2)

 

 

You probably know how difficult it is to find a good book on OpenOffice.org Base and Basic.

I scoured the Internet for tutorials, wikis, helps, ANYTHING to get me going! (the OpenOffice doc sites are still a dark underworld to me) To make matters worse, I'm so addicted to IDE's that gently hold my hand with their inline API suggestions that OpenOffice.org's IDE stoic silence was about as easy to love as a tree! To make matters even worse, I've spent the last 8 or so years buried in Java; I could hardly remember how to speak Basic from those good 'ol years of GWBasic, QBasic, VB3.0, and VB6.0 (long, long ago!).

Suffice it to say, this book is EXACTLY what I needed.

It's not an API reference book for sure. But it takes you by the hand and leads you through the valleys and over the mountains of database development with OpenOffice.org Base and the Basic programming language. If you want to step above the simple database wizards and become more of a wizard yourself, this book is what you need. In my estimation (and I'm not a rich fellow, I have to count my dollars), this book is worth the price.

Thanks, Roberto and Cecilia for a great book! You must make a great team too! :)

I've been away from development for a few years, but have worked with Java, JavaScript, ASP, JSP, Lotus Notes/Domino, and SQL before. I was hoping for a book that would bridge the gap between being able to create forms and relational databases in Base (which I could do) and learning how all of the form elements could be accessed and manipulated. The book very briefly touches on how to access the value of a listbox's selection, but doesn't spend any time on how the various different form elements differ in properties and methods, nor does it include a reference to the full properties and methods of the handful of objects used in its examples. This is doubly exasperating because you can't find such a reference anywhere else, either.

My search for a helpful guide continues.

Most of the book is logical. Occasionally, he skips important steps. For example, on page 136 he has a step-by-step discussion on how to link a master and slave field. In one sentence he glosses over about seven steps, which took me a couple hours to figure out--only after re-reading the chapter about two times, did I figure out how to accomplish this.

The author assumes the reader knows more than he/she should. If you are technically savvy, you will benefit from this book. Otherwise, you may need to use other sources as well.

It's really a good book. You can read clearly examples of usually operations with OODB (inert, update, delete...)

I thing is for programer that makes db application with MS Access and want to migrate to open OS

As with so many books of this type, I did not find it to be helpful. I am a rank amateur at programming OpenOffice products. Instead of working with elementary and helpful examples, he starts off with step 17. It would be more useful if he started with step #1.

This is a fantastic book.

I use this book to program in Java. I feel it is as good at instructing Java and C++ for an experienced programmer as it does for the Basic programming language. I do not know Basic very well but the code examples act as concise pseudo-code which lets me know where to start and where I need to go. As I will explain latter it is easier to read the example code for understanding than it is to read Java or C++ code fragments.

If you do not know anything about programming OOo with Java, you will need to download and install the SDK from OOo web site and I strongly recommend downloading the Developer Guide PDF. Of note: OOo Developer Guide 2.3 seems to be missing documentation for mail merges which this book contains a section which was very useful. Also, you must study and run several of the example programs provided in the SDK so you understand and are comfortable with the UnoRuntime.queryInterface method.

Programming Java with OOo is challenging at the very beginning... this is because of the UNO architecture which OOo has used for it's API. Once you are past this short initial learning stage, things become much smoother. The main thing to learn is that unlike Basic, Java is very concerned with type... We know this of course (if you are a Java programmer) but where it gets tricky is that with UNO you are rarely given the Base Object but an Interface instead. It is something like working with a client/server system. When you create an instance in Java you get a picture into a base object, but it is like the base object is locked away on the server and you just have this controller. If you want to change to a different interface (get a different set of controls) which this object supports then you need ask the UNO Runtime for that particular interface for this particular object (the interface and the object are parameters to the UnoRuntime.queryInterface method, which then returns an object of the type you wanted... hopefully, or there is an exception, then you cast that object to the type you know it is... it isn't pretty). Programming with this form looks strange at first but it is a requirement. Basic does not require type safety so it's like you are working with the object directly because you have the sum of all the interfaces at your disposal (there are A LOT of interfaces). What this means for programmers of type safe languages is that you need to have a browser window open to OOo API guide to keep track of what type of object you are working with so you can produce the correct interface for each method call.

There are two more things a Java programmer may need:

1) If you are a Netbeans fan as I am, then you had best install the [...] (you will need the SDK downloaded already and an installed version of OOo), this will allow you to create OOo projects with all required libraries (you get the option of creating an OOo project after installing).

2) Someone to ask questions of, I have found the people at [...] very helpful.

I know this review is aimed at Java and applies somewhat to C++ programmers but it is important for them to know that this book is valuable to them as well. Some may also wonder what an external programming language offers over Basic... I would say that it is possible to do more than script an open running OOo instance but to use OOo in "headless" mode and co-opt it's functionality for the internal use of your projects.

I think it would be good if the author could add a small section on Java programming explaining some of the things mentioned here, I think it would only take a few pages and help a lot of programmers. For the value it has given me, and the great reduction in searching the web and for it's vastly superior readability to the Developers guide I give it five stars.

Thank you Roberto and Cecilia and best of luck to everyone on their projects.
Ken.

This 349 page manual tells you everything that you wanted to know about designing an OpenOffice database and for writing associated programs in the Basic language.