Edit data in query

Creating tables and queries
Post Reply
micha137
Posts: 33
Joined: Mon Dec 03, 2007 12:25 pm
Location: Wedel/Germany

Edit data in query

Post by micha137 »

Hi there,

When using queries I think I used to be able to edit the data from within a query and sometimes I couldn't.
Presently I want to do exactly that.
Purpose is to update a date field in a table with data from an old calc sheet (converted to a temporary table) where "dates" were put in in arbitrary inconsistent text string format so irregular that automated conversion is not feasible.
So I made up a query joining the two tables and presenting the "wild format" date field from the converted calc sheet right next to the empty date field of the target table. But now base won't let me edit the target field of the table in the query-view.

Is there some rule when I can edit fields in a query and when not or am I just remembering wrongly and it is never possible?

Unfortunately, the OO-help pages on base seem to be rather "thin" and superficial compared to the other OO-modules help sections....

regards
micha 137
OOo 3.0.X on Ubuntu 8.x
User avatar
kabing
Volunteer
Posts: 678
Joined: Fri Nov 23, 2007 12:05 am
Location: Midwest, USA

Re: Edit data in query

Post by kabing »

I can't give you a definitive answer, but my experience has been that queries can be edited if they are based on only one table. If the query contains fields from more than one table, I have not been able to edit it.

Maybe you can get what you want by creating a form with a main form based on one table and a subform on the other table?

kabing
NeoOffice (app store version) OpenOffice.org 4.1 and LibreOffice 4.3 on Mac OS X El Capitan
OpenOffice.org 4.1.2 on Windows 10 (Previously on Vista)
micha137
Posts: 33
Joined: Mon Dec 03, 2007 12:25 pm
Location: Wedel/Germany

Re: Edit data in query

Post by micha137 »

thanks kabin,

I did it this way and it worked nicely :) (Main form was the Query containing the join, subform was the table).

regards
micha137
OOo 3.0.X on Ubuntu 8.x
Post Reply