[discuss] Re: Open Office Help
NoOp
> Gerard G wrote:
>> Would you recomend me some usefull help for Open Office.
>> I would like to find some EXAMPLE concerning :
>> 1.) simple form to set parameters,
>> 2.) generating a query with parameters from form,
>> 3.) executing a query, ( generating or updating a table )
>> 4.) making a report based on the table from point 3.)
>> 5.) Passing back some data from the result of query 3.) back to the form to adjust parameters.
>>
>> May you send me some usefull internet links for that .
>> The normal help has to much information and it's quite difficult to find these really important.
>> I would like also to read sth about implementation of the transactions mechanism in Open Office.
>>
>>
>>
>> With kind regards,
>> Gerard GÅ‚owacki
>>
>>
>>
>>
>
> There is no real database application in OpenOffice.org. Having some
> database running on a server you may connect a Base document to it, so
> the database data are accessible and printable from office documents.
Interesting...
http://www.openoffice.org/product/base.html
So this is wrong eh?
Crossposting removed.
---------------------------------------------------------------------
To unsubscribe, e-mail: discuss-u...@openoffice.org
For additional commands, e-mail: discus...@openoffice.org
Andreas Saeger
> On 11/17/2009 07:33 AM, Andreas Saeger wrote:
>> Gerard G wrote:
>>> Would you recomend me some usefull help for Open Office.
>>> I would like to find some EXAMPLE concerning :
>>> 1.) simple form to set parameters,
>>> 2.) generating a query with parameters from form,
>>> 3.) executing a query, ( generating or updating a table )
>>> 4.) making a report based on the table from point 3.)
>>> 5.) Passing back some data from the result of query 3.) back to the form to adjust parameters.
>>>
>>> May you send me some usefull internet links for that .
>>> The normal help has to much information and it's quite difficult to find these really important.
>>> I would like also to read sth about implementation of the transactions mechanism in Open Office.
>>>
>>>
>>>
>>> With kind regards,
>>> Gerard GÅ‚owacki
>>>
>>>
>>>
>>>
>> There is no real database application in OpenOffice.org. Having some
>> database running on a server you may connect a Base document to it, so
>> the database data are accessible and printable from office documents.
>
> Interesting...
> http://www.openoffice.org/product/base.html
> So this is wrong eh?
>
> Crossposting removed.
Base is a collection of modules and 3rd-party software built around
ODF-documents. I made quite a few small and medium databases with it. I
use two of my databases daily.
I used to develop(semi-professional) with MS Access 97/2000.
I'm a main contributor on
http://user.services.openoffice.org/en/forum/viewforum.php?f=13
I'm very familiar with the misconceptions, high flying expectations and
common problems related to Base.
- It is not what it looks like.
- You are the one to design the database backend and nothing in Base
will support your in your very own design decisions.
- Base forms provide very simplistic (thus difficult) tools to built
input tools for relations. But you have to be familiar with the abstract
concepts of the underlying database.
- Many things do not work as you might expect and you have to find your
own way to get the maximum out of the offered tool set.
- It will never be enough for a smart looking database application
unless you start programming, which is extremely difficult.
- Nevertheless, Base is a useful complement to the other office
component. It outperforms every "spreadsheet solution" on the fly. Just
do not expect anything like MS Access. Not even close.
jonathon
> http://www.openoffice.org/product/base.html
> So this is wrong eh?
Misleading.
Whilst it provides what it says it provides, it does not do so in a
maker that makes it usable by non-programmers.
jonathon
--
Ethical conduct is a vice.
Corrupt conduct is a virtue.
Guiding principles of the legal and ethical system of Nacarima.