|
From: Rob M. <Rob...@co...> - 2006-02-09 01:02:30
|
Maury Hammel wrote: > Glenn: > >> I can tell you what's going on inside Squirrel, but not why you are >> seeing this result. >> > [snip for brevity] > > Maybe I'm remembering this wrong, it has been quite a while since I've > looked at the source, but I thought you had implemented (or what is it > the Oracle plug-in?) something to use the ROWID (or other similar > column for other databases) for updates? I know SQuirreL displays the > ROWID in the Contents tab. Maury, Looking at DataSetUpdateableTableModelImpl.getWhereClause it doesn't appear that anything Oracle-specific is being used. 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 |
