Issue 42463

Hi,

I reassign this issue to User Experience for evaluating.

Bye Marc

Hi 

Any further info on this request? I'm not going to be able to persuade Access
users to use OpenOffice Base, until this kind of functionality is available,
also as result of this, if they can't replace access, there will be no need for
them to repace the rest of the MS Office. When I first heard the OpenOffice were
going to include a database application, I immediately started pushing open
office once more, but having shown the base application to the Access users,
they are not prepared to change as it stands at the moment.

Hi 

Any further info on this request? As it's been about 5 months since I last asked
for an update, and 8 months since I first submitted this request I just thought
I'd ask. I know I'm not alone in asking for this feature to be included in
base., ans as I stated before, I'm not going to be able to persuade Access
users to use OpenOffice Base, until this kind of functionality is available,
also as result of this, if they can't replace access, there will be no need for
them to repace the rest of the MS Office. When I first heard the OpenOffice were
going to include a database application, I immediately started pushing open
office once more, but having shown the base application to the Access users,
they are not prepared to change as it stands at the moment.

Any progress on this issue

I have absolutely no chance of persuading my boss to migrate until this
functionality is available with base

The ask your boss to fund a developer implementing this :)

Hi All

Has it really been that long since I origianlly created this issue.

Oh well, thougt I'd bring it up again, as I was so dissappointed when I
installed OO3 beta, only to find that this key feature is still lacking from OO
Base.


Please, please,please look into adding this ability, as at the moment, I'm still
having to use MS Access 97, which does have this functionality.

The need to use MS Access is 'only' reason I have not been able to ditch my MS
installation.

Thanks

Tony

please let the version nummber for the first discovery.

Also in Base you can update, append and delete with queries under "Tools -> SQL..."

Hi 

I know you can manually write delete queries etc using Tools -> SQl etc

But, the functionality I'm looking for, and still have to make use of in MS
Office 97, is the ability to design the update, delete, append querys in the QBE
window, so as it stands, I'll have to stick with my 11 year old version of MS
Office.

As for the first version I noticed this issue, this issu has always been in OO.

Cheers

Tony

Please let version on 2.0 where the issue is created.

In my opinion it is a good idea to separate functions which should the user use
and functions which should use by a DB admin.

Hi Ok

It can be left at version 2. However, the functionality that I'm looking for is
invaluable, and is 1 of the 2 reasons I still have to use MS, and not move
across to Linux full time.

Unfortunately, whereas OOCalc,Writer,Impress are very good, and sometimes better
that the equivalent MS office offerings, I still find Base to be noticably
lacking, even in comparison to MS Office 97.

If the functionality of OOBase can reach that of MS Access 97, I, and I imagine
many other will be better placed to replace MS Office with OpenOffice
completely, but until users can design queries, other that select, using the
same QBE as they can when designing a select query, it can't fully replace MS
Access.

I'm really sorry, because I am really trying to get the company I work for to
switch to OO, but the Access equivalanet(BASE) is a hinderance.

The functionality may appear trivial to a skilled SQL developer, but is too much
of a drain on your everday user, especially when they counteract any argument
with, well I can create my update query almost instantly in Access, with little
or no typing.

Regards

Any update on this, is it in the pipeline for a future release?

Cheers

this is what you ask for

This issues has been around for a long time.  The database on OOo is not being
used by most OOo users because it lacks crucial components.  People that are SQL
savvy can write their own queries without have to use a tools like OOo to manage
data in a database.  However, typical office workers that can use MS Access to
update, select, delete or insert data cannot do this using Open Office.

I personally has this problem at all sites where we are involved. Like someone
else said, it's the reason why people are not able to move to OOo from MS
Office... :-(

You can do Insert, Update and Delete Statements via SQL.

Of course update, insert and delete queries can be done by writing SQL, but so
can select queries.  The reality is that many users of MS Access use these via
the graphical interface since it's substantially faster and more intuitive to do
arbitrary SQL operations that way.  Why do we have so many arguments against
this, yet so many people want this?  They are not DBA's, but just normal office
people that don't ever get to these forums so state their desire for the
functionality.  They simple try Open Office Base, find it lacking and write it
off as being inferior to MS Access.

What can we do to get this functionality?

I have to strongly (very strongly) agree with tony_52.  I am a college 
professor who has taught Access for fifteen years (and taught dBase, rBase, 
Oracle, and SQL prior to that).  I am currently writing a book on Access and 
Open Office Base (my fifth book - others are best selling textbooks used in 
over 250 colleges around the country).  I was HOPING that I could replace 
Access with Open Office Base in my Office Applications course at the college 
(and my next book), but without this very basic functionality (especially 
crosstab queries, which are ESSENTIAL to any business person using a database) 
there is no hope for OO Base to even come close to being in general use by 
business people.  

I know all these things are possible with SQL commands, which are the bread and 
butter of any technologists.  But the people who use Access are not 
technologists - they are business people.  They need the menu items to perform 
the esoteric SQL commands just as Access provides menu items or wizards to 
perform these tasks.  

PLEASE consider this request.  It will make a HUGE difference in the 
acceptability of Open Office by any business office in the world.  Currently, I 
can't recommend Open Office to my clients (did I mention I'm the CEO of a 
consulting firm, too?) or my students because of this deficiency.

So - I reiterate Tony's request.  Please AT LEAST enable the following types of 
queries to be created in the Query: Crosstab, Make table, Update, Append, 
Delete.  It may not make a big difference to the technically literate, but 
since 90% of the population (and 100% of my students) who use computers are not 
technically literate, we have to accommodate them as well.   

Thanks for letting me vent.
CJ Rhoads
CJRhoads at ETMAssociates.com 

*** Issue 42463 has been confirmed by votes. ***

It seems this issue has fallen away. I am also evaluating what to use in replacement of Access. I feel base has the potential to do this, but must have the tools requested in previous comments to be at all attractive. For DB query writing savvy users, the current Base is ok, but as mentioned, 95% of the potential users would use Base over Access if they could build different types of queries on the fly. I often build 10-15 queries to dig into data different ways, then delete them after receiving my results. This work would be too painful to do typing each query out longhand just for a few answers to questions I have.

Is there any chance to make this function be available? I would like to help coding it, but I am not a strong enough programmer.

Also, I would love to see a programing possibility similar to Access, but better. I envision each form/object on the form etc. could be named. Then from a single programing editor, all objects could be referenced by name for action/property. Similar to Access, but move the "form" code out to a central location. I believe it would be far easier to have no code "on the form" and have it all in a central location (by module if user wanted to subdivide). question.. what language?