Re: problem editing

Hi Mark,

could please create a script of your table together with some inserts 
that would allow me to reproduce your problem.

To create the table DDL script right mouse click the table in the Object 
Tree and choose the "Create Table Script" menu.

To create the insert script write a "SELECT * FROM <yourTable> ... " 
statement that selects a few rows from your table, place the caret in 
the statement, hit ctrl+t and choose the sql2ins entry in the tools popup.

Thanks

Gerd

Mark Neher wrote:
> 
> No, all the tables in our schema have a primary key.  Thanks for the 
> idea, though.
> 
> Mark
> 
> 
>> From: "Simon Grantham" <SGRANTHA <at> flemingc.on.ca>
>> To: <markneher <at> hotmail.com>,<squirrel-sql-users <at> lists.sourceforge.net>
>> 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" <markneher <at> hotmail.com> 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
>> Squirrel-sql-users <at> lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 
> 
> 
> 
> -------------------------------------------------------
> 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
> Squirrel-sql-users <at> lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
> 

-------------------------------------------------------
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