Page 1 of 1

Edit data in query

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

Re: Edit data in query

Posted: Tue Dec 04, 2007 10:54 pm
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

Re: Edit data in query

Posted: Thu Dec 06, 2007 11:17 am
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