|
From: Mark N. <mar...@ho...> - 2006-02-09 15:47:58
|
Rob, I just tried this feature and set it to use the primary key only. This didn't make a difference, unfortunately. I'll try to post a table definition as a couple folks have suggested, but I probably won't get a chance to do so for a couple days. BTW, our schema contains some 300 tables, and I have only turned up a handful that have this problem; most of them I can edit and update just fine. I haven't been able to find a common thread among the ones that fail... Mark ========================================= Mark, One other thing to note that no one else has mentioned here - there is a way to limit what columns are used in the where clause that is used to build the update statement. The "Limit cell edit WHERE clause size" can be used to restrict which columns are used. Right click on the table to access this menu item. Maybe just using the primary key field(s) in this case might help? Rob |
