|
From: Gerd W. <bir...@t-...> - 2006-02-18 16:33:12
|
Hi all,
Perhaps just another detail:
The where clause that SQuirreL generates to do the update and some
checks is:
WHERE NAME='junk' AND FILE_UPDATE_DATE={d '2006-02-18'}
A select with this where clause doesn't return a row (of course I did
the insert using sysdate on 2006-02-18).
Since the JDBC driver says the type of the FILE_UPDATE_DATE column is
java.sql.Types.DATE I'm pretty sure the where clause not matching is a
violation of the JDBC standard.
By the way:
If you do a
insert into license values ('junk', {d '2006-02-18'})
instead of
insert into license values ('junk', sysdate)
editing works.
Gerd
Mark Neher wrote:
> 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
>>>
>>
>
>
>
>
> -------------------------------------------------------
> 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
>
|
