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
Edit data in query
Edit data in query
OOo 3.0.X on Ubuntu 8.x
Re: Edit data in query
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
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)
OpenOffice.org 4.1.2 on Windows 10 (Previously on Vista)
Re: Edit data in query
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
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