|
From: Gerd W. <bir...@t-...> - 2006-02-19 10:36:16
|
Hi again,
Mark, since it is Oracle and after a night of desperate doubt ;-) I
decided to introduce a bit of Oracle specific code: According to Maury's
suggestion now for Oracle the generated where clause will be
WHERE NAME='junk' AND trunc(FILE_UPDATE_DATE)={d '2006-02-19'}
This worked alright on my Oracle 10g database. It would be nice if you
could try out if it worked for you and tell us. You can get the new code
from CVS or from the next weekly snapshot.
Rob, could you please give Mark a pointer whether my code made it to
this weekends snapshot or not. Thanks!
Gerd
Gerd Wagner wrote:
> 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
>>
>
>
>
> -------------------------------------------------------
> 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
>
|
