Edit data in query
Posted: Tue Dec 04, 2007 8:59 pm
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
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