No, all the tables in our schema have a primary key. Thanks for the idea,
though.
Mark
>From: "Simon Grantham" <SGR...@fl...>
>To: <mar...@ho...>,<squ...@li...>
>Subject: Re: [Squirrel-sql-users] problem editing
>Date: Wed, 08 Feb 2006 14:53:02 -0500
>
>I'm guessing that the table you are trying to update has no primary key.
> In this circumstance, squirrel has no real way of knowing which record
>it is supposed to update. That is, you are blocked because an update
>command might update multiple records instead of just the one you
>edited.
>
>Just a guess though.
>
>Simon
>
>
> >>> "Mark Neher" <mar...@ho...> 08/02/2006 11:46 am >>>
>
>Hey All,
>
>I am having trouble editing in SQuirreL. If I make a table editable,
>it
>allows me to click in a cell and make changes. When I try to save the
>
>changes, a panel pops up saying
>
>"This row in the Database has been changed since you refreshed the
>data.
>No rows will be updated by this operation.
>Do you wish to proceed?"
>
>Clicking yes yields "No rows updated."; no cancels. Trying to edit
>using
>the popup rather than in the cell gives the same results.
>
>I don't see any mention of this in the help, or in the mailing lists
>online.
> Any ideas ?? BTW, I am running version 2.1 final on a Linux box, and
>
>attaching to an Oracle database.
>
>Thanks,
>
>Mark
>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: Splunk Inc. Do you grep through log
>files
>for problems? Stop! Download the new AJAX search engine that makes
>searching your log files as easy as surfing the web. DOWNLOAD
>SPLUNK!
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
>
>_______________________________________________
>Squirrel-sql-users mailing list
>Squ...@li...
>https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|