William Hindman
wdhindman at bellsouth.net
Wed Feb 26 10:59:59 CST 2003
...look under "update data from a query" in your help file ...lots of gotchas and work arounds. William Hindman ----- Original Message ----- From: "John W. Colby" <jcolby at colbyconsulting.com> To: <accessd at databaseadvisors.com> Sent: Wednesday, February 26, 2003 11:20 AM Subject: RE: [AccessD] Operation must use an updateable query > It seems to me that the query pulling the ID of the records to be updated > could be inserted as a sequel statement into an IN clause? > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > -----Original Message----- > From: accessd-admin at databaseadvisors.com > [mailto:accessd-admin at databaseadvisors.com]On Behalf Of William Hindman > Sent: Wednesday, February 26, 2003 11:06 AM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Operation must use an updateable query > > > JC > > ...sounds like you are using a query based on tables with a m2m relationship > ...which would make the query non-updateable ...this usually requires either > rewriting the query or writing code to do the updates you want ...lots of > sample code in the Help and KB re this ...HTH :) > > William Hindman > > ----- Original Message ----- > From: "John W. Colby" <jcolby at colbyconsulting.com> > To: "AccessD" <AccessD at databaseadvisors.com> > Sent: Wednesday, February 26, 2003 10:19 AM > Subject: [AccessD] Operation must use an updateable query > > > > I have a database where a claim table has an event child table. The event > > table may have an event such as Open for a set of claims. In order to > > discover which claims have an open event I have a query that pulls out > that > > event and has the claim id exposed. now I want to update a field in every > > claim that has an open event (as an example). Trying to do so generates > the > > infamous "Operation must use an updateable query". this is one I have > > banged into before and never really understood why I get it, not how to > > reliably not get it. > > > > Update a field in the parent table, if it has a related record in the > child > > table. It sounds so simple. How is it done? > > > > John W. Colby > > Colby Consulting > > www.ColbyConsulting.com > > > > ---------------------------------------------------- > > Is email taking over your day? Manage your time with eMailBoss. > > Try it free! http://www.eMailBoss.com > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > ---------------------------------------------------- > Is email taking over your day? Manage your time with eMailBoss. > Try it free! http://www.eMailBoss.com >