|
From: Mark N. <mar...@ho...> - 2006-02-17 15:26:09
|
I'm back !! And I've found a reproducible bare bones case. The common
thing in all of the rows that I can't edit is a non-null DATE field. Using
the following stripped down table definition:
CREATE TABLE LICENSE
(
NAME VARCHAR2(80),
FILE_UPDATE_DATE DATE
);
and the following data:
insert into license values ('test', null);
insert into license values ('junk', sysdate);
I can edit the 'test' row, as the DATE is null, but I get the previously
mentioned errors when I try to save an edit in the 'junk' row. This is
reproducible in each table in our schema that has a DATE field. BTW, the
same problem doesn't affect TIMESTAMP fields; I can edit rows with non-null
TIMESTAMP data.
Hope this helps,
Mark
>From: Gerd Wagner <bir...@t-...>
>To: Mark Neher <mar...@ho...>
>CC: SGR...@fl..., squ...@li...
>Subject: Re: [Squirrel-sql-users] problem editing
>Date: Wed, 08 Feb 2006 22:26:54 +0100
>
>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" <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
>>
>>
>>
>>
>>-------------------------------------------------------
>>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
>>
>
|
