Arthur Fuller
artful at rogers.com
Fri Feb 28 07:56:00 CST 2003
Can a claim have two Open events? If so, then multiple rows are being returned from the query, which will pose a problem. If so, try changing the query to count the Open events for each claim. That way you'll end up with only one row per claim. With that list, you should be able to update each claim. If it still fails, you could always use that first query in the IN() clause of your update query (but obviously this will be slower). HTH, Arthur -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] Sent: February 27, 2003 2:29 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Operation must use an updateable query Arthur, This isn't an SQL database. 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 Arthur Fuller Sent: Thursday, February 27, 2003 10:03 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Operation must use an updateable query Does your SQL fail in QA as well, or just in Access? You may be able to sidestep the problem by creating a view first that retrieves the claims of interest, then join that to the claims table, then change the query into an update query. -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of John W. Colby Sent: February 26, 2003 10:20 AM To: AccessD 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 -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 5060 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030228/894ccffb/attachment-0001.bin>