squirrel-sql-users — A subscriber only discussion list for SQuirreL

Re: [Squirrel-sql-users] problem editing

[Robert M. <rob...@gm...>]

Mark,

As far as the number formatting, try this:

General Preferences -> Data Type Controls

In the section called FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL

choose "use default format (3.14159)"

Rob

On 2/21/06, Maury Hammel <ml1...@sh...> wrote:
>
> Mark Neher wrote:
>
> > I downloaded and installed the snapshot referenced.  I have partial goo=
d
> > news -- some of the tables which I was unable to edit before work now
> > (including the minimal sample that I submitted last week), but I am
> > still unable to save an update to the rest.  As I get a chance, I will
> > try to determine what data conditions might cause these differences.
>
> If I understand the fix that Gerd implemented, then the tables where the
> update doesn't work are probably tables where you have multiple rows
> where date values that are on the same day (e.g. 2 Feb 2006 12:00:01 and
> 2 Feb 2006 11:48:33, etc.).
>
> The fix truncates the date when doing the comparison.  In such cases,
> the code is going to find (what it thinks are) duplicate rows, so it
> will not do the update.
>
>
> Maury
>
>
>
>
>
> -------------------------------------------------------
> 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=3Dlnk&kid=3D103432&bid=3D230486&dat=
=3D121642
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

Re: [Squirrel-sql-users] problem editing

[Maury H. <ml1...@sh...>]

Mark Neher wrote:

> I downloaded and installed the snapshot referenced.  I have partial good 
> news -- some of the tables which I was unable to edit before work now 
> (including the minimal sample that I submitted last week), but I am 
> still unable to save an update to the rest.  As I get a chance, I will 
> try to determine what data conditions might cause these differences.

If I understand the fix that Gerd implemented, then the tables where the 
update doesn't work are probably tables where you have multiple rows 
where date values that are on the same day (e.g. 2 Feb 2006 12:00:01 and 
2 Feb 2006 11:48:33, etc.).

The fix truncates the date when doing the comparison.  In such cases, 
the code is going to find (what it thinks are) duplicate rows, so it 
will not do the update.


Maury

Re: [Squirrel-sql-users] problem editing

[Mark N. <mar...@ho...>]

Hi All,

I downloaded and installed the snapshot referenced.  I have partial good 
news -- some of the tables which I was unable to edit before work now 
(including the minimal sample that I submitted last week), but I am still 
unable to save an update to the rest.  As I get a chance, I will try to 
determine what data conditions might cause these differences.

In a (probably) unrelated note, when I run the new snapshot, there seems to 
be some automatic formatting of numeric data.  Number fields are now 
formatted with commas (an ID field like 15000 now displays as 15,000) and 
float fields don't display numbers after the decimal point.  I don't 
remember reading anything about this, and don't see anything in the help 
screens about it.  Is there a way to turn this off ??  I cut and paste 
frequently and plain old numbers work better for that.

Thanks,

Mark


>From: Gerd Wagner <bir...@t-...>
>To: Gerd Wagner <bir...@t-...>
>CC: Mark Neher <mar...@ho...>,  SGR...@fl...,  
>squ...@li...,  
>Rob...@co...,  gw...@co...
>Subject: Re: [Squirrel-sql-users] problem editing
>Date: Sun, 19 Feb 2006 11:37:01 +0100
>
>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
>>
>

Re: [Squirrel-sql-users] Squirrel designer plugin ??

[Glenn G. <gw...@co...>]

Hi Gerd,
I would suggest that the Designer function not be included in the SQL 
Script plugin.  My reasoning is that the Designer could become a major 
functionality on its own, and putting it in the Script plugin would have 
two negative effects.  One is that people who want the Scripts plugin 
may not want the Designer and all of its complexity, and the other is 
that the potentially huge amount of Designer code could make it 
difficult to maintain the Scripts plugin.
Just my two bits. (I don't know if 2 bits is worth less than two cents, 
but it is certainly more international :-)).

Gerd Wagner wrote:

> Hi,
>
> I've been thinking about a designer since I finished the Graph plugin 
> but I didn't have the time to start it. All the things Glenn mentions 
> are true. That's why I thought of starting with something that for a 
> first step allows you to
>
> - create new tables
> - create / delete foreign key constraints
> - create / delete indexes
> - add nullable columns to existing tables
>
> My idea is that the designer should not be part of the Graph plugin or 
> a new plugin but part of the SQL-Script plugin. My hope was the design 
> could be done in a dialog window that could be opened either from the 
> Object Tree or a Graph. Since the designer dialog is placed in the 
> SQL-Script plugin it will simply creates DDL-Scripts in the 
> SQL-Editor. The designer dialog only works with one table at a time.
>
> Within the Graph plugin the user should be able to design more than 
> one table before creating a DDL-Script. To do so the designer dialog 
> needs to allow exports and imports of its state. The Graph plugin must 
> be able to interpret this state and display it.
>
> Within a Graph the user should be able to:
> - Open the designer dialog for a table (tell the SQL-Script plugin to 
> open the dialog and display the import data provided by the Graph)
> - Script all changes done in the designer (tell the SQL-Script plugin 
> to script all import data the Graph provides).
>
>
> Perhaps those ideas can give you, Fabrice, or someone else the feeling 
> that it shouldn't be too hard to begin. Of course your own ideas are 
> needed and wanted too.
>
> As Glenn mentioned some changes to the core will be needed. Especially 
> some extensions to the way SQuirreL allows plugins to communicate 
> would be necessary. Best would be if the one who does the work does 
> the needed changes on the core too. I would surely be available for 
> questions and advice.
>
>
> Gerd
>
>
> Glenn Griffin wrote:
>
>> Hi Fabrice,
>>
>> That sounds like a very nice feature.  Would you like to build it? :-)
>>
>> The following random thoughts come to mind:
>>
>> - This should be do-able as a plug-in.  As with any plug-in, we may 
>> need to add some hooks to the core code for it to work, but that 
>> should not be a problem.
>>
>> - A graphical user interface for input is usually an order of 
>> magnitude more difficult to build than a display-only interface 
>> because the user needs to be able to not only grab and move objects, 
>> but also create objects, insert things into them, resize them, etc.  
>> Sounds like a lot of work, though the result could be worth it.
>>
>> - Automatically generating CREATE and ALTER statements is much more 
>> complicated than generating SELECTs because databases are much less 
>> standardized in defining the names of their data types and how they 
>> are defined.  I'm guessing that the kind of tool you are describing 
>> would need to have a strictly-maintained division between two sections:
>>    - DB-agnostic code that handles the user interface and makes calls 
>> to the.....
>>    - DB-specific code (in plugins?) that understands the data types 
>> in the particular DB.
>> For example, when the user wants to add a field to a table:
>>    - DB-agnostic code shows the "add field" button and gets the 
>> action command when the user clicks, and then calls the...
>>    - DB-specific code which returns a list of the names of all the 
>> data types within this DB...
>>    - so the DB-agnostic code can present that list to the user for 
>> selection
>> There will also be issues such as what options are allowed/required 
>> for each data type (null/not-null, field size, etc) and, in some 
>> cases, the exact syntax needed by the CREATE statement.
>>
>> - I recall from a long time ago that some DBs did not allow ALTER on 
>> tables after they were created.  May not be a problem any more, but 
>> something to look into.
>>
>> - A decision will be needed on what to do with the result of the 
>> design.  Is it output to text files for use by another tool, or is it 
>> executed by SQuirreL directly on the DB?  What happens to data 
>> already in the DB?  What kinds of warnings should be generated about 
>> changing the DB and possible loss of data?
>>
>> - It would be good to include comments on the fields and the ability 
>> to view and print the schema details, eg:
>>    integer                uid            // unique user id
>>    VARCHAR(6)    userId   // login and screen name
>>    VARCHAR(30)   userName   // full name of the user
>> etc.  Those comments can be critical to remind people of the format, 
>> range, limits or expected use of the fields.
>>
>> While it would probably be a lot of work, this could be a cool 
>> feature for the product!
>>
>> Glenn
>>
>> Fabrice GONNON wrote:
>>
>>> Hi,
>>>
>>> Squirrel is a fabulous product and last version with choice to
>>> integrate oracle plugin is very nice. Great work guy's ;o)
>>>
>>> I have a question:
>>> There is in Squirrel the graph vizualisation (very good).
>>> Is it planned or does exist a Designer plugin ? Because it is able to
>>> do a reverse representation, wuld it be easy to create a graph, and 
>>> then
>>> to applicate it to a database ??
>>> Or does somebody know a product that could do so ?
>>> There is a market for it because it seems that DBdesigner4 is no more
>>> supported :-( and Druid does work only to create and doesn't have
>>> reverse design...
>>>
>>> If so, Squirrel would be the best product for databases client queries
>>> AND design.
>>>
>>> Thank's again for your so good contribution.
>>>
>>> Fabrice.
>>>
>>> **********************************************************************
>>> This email and any files transmitted with it are confidential and
>>> intended solely for the use of the individual or entity to whom they
>>> are addressed. If you have received this email in error please notify
>>> the system manager.
>>> **********************************************************************
>>>
>>>
>>>
>>> -------------------------------------------------------
>>> 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
>>
>
>

Re: [Squirrel-sql-users] problem editing

[Glenn G. <gw...@co...>]

Hi All,

My recollection is that when I was building the DATE/TIME/TIMESTAMP data 
types, someone pointed me to a wonderful web site (whose URL I cannot 
find now) that described all the variations in DB implementations of SQL 
for those types.  The "{d 'date'}" form was supposedly the most 
"standard" and seemed to work for everyone at the time.
My guess is that the code described below should be safe for all DBs, 
and therefore should solve this Oracle-specific problem without causing 
other problems, but only TIME will tell :-).  (Sorry, I counldn't resist 
the pun.)

Glenn

Gerd Wagner wrote:

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

[Squirrel-sql-users] =?ISO-8859-1?Q?R=E9p.=20:=20Re:=20[Squirrel-sql-users]=20Squirre?= =?ISO-8859-1?Q?l=20designer=20plugin=20=3F=3F?=

[Fabrice G. <Fab...@hc...>]

Thank you for your well done answers.

If I could, I would like to participate to this project, but I'm no
more developer :-S
But I keep contact for motivation, and follow your good job.... ;-))

Best Regards



>>> Gerd Wagner <bir...@t-...> 20.02.06 22:14:34 >>>
Hi,

I've been thinking about a designer since I finished the Graph plugin 
but I didn't have the time to start it. All the things Glenn mentions 
are true. That's why I thought of starting with something that for a 
first step allows you to

- create new tables
- create / delete foreign key constraints
- create / delete indexes
- add nullable columns to existing tables

My idea is that the designer should not be part of the Graph plugin or

a new plugin but part of the SQL-Script plugin. My hope was the design

could be done in a dialog window that could be opened either from the 
Object Tree or a Graph. Since the designer dialog is placed in the 
SQL-Script plugin it will simply creates DDL-Scripts in the SQL-Editor.

The designer dialog only works with one table at a time.

Within the Graph plugin the user should be able to design more than one

table before creating a DDL-Script. To do so the designer dialog needs

to allow exports and imports of its state. The Graph plugin must be
able 
to interpret this state and display it.

Within a Graph the user should be able to:
- Open the designer dialog for a table (tell the SQL-Script plugin to 
open the dialog and display the import data provided by the Graph)
- Script all changes done in the designer (tell the SQL-Script plugin
to 
script all import data the Graph provides).


Perhaps those ideas can give you, Fabrice, or someone else the feeling

that it shouldn't be too hard to begin. Of course your own ideas are 
needed and wanted too.

As Glenn mentioned some changes to the core will be needed. Especially

some extensions to the way SQuirreL allows plugins to communicate would

be necessary. Best would be if the one who does the work does the
needed 
changes on the core too. I would surely be available for questions and

advice.


Gerd


Glenn Griffin wrote:
> Hi Fabrice,
> 
> That sounds like a very nice feature.  Would you like to build it?
:-)
> 
> The following random thoughts come to mind:
> 
> - This should be do-able as a plug-in.  As with any plug-in, we may
need 
> to add some hooks to the core code for it to work, but that should
not 
> be a problem.
> 
> - A graphical user interface for input is usually an order of
magnitude 
> more difficult to build than a display-only interface because the
user 
> needs to be able to not only grab and move objects, but also create 
> objects, insert things into them, resize them, etc.  Sounds like a
lot 
> of work, though the result could be worth it.
> 
> - Automatically generating CREATE and ALTER statements is much more 
> complicated than generating SELECTs because databases are much less 
> standardized in defining the names of their data types and how they
are 
> defined.  I'm guessing that the kind of tool you are describing would

> need to have a strictly-maintained division between two sections:
>    - DB-agnostic code that handles the user interface and makes calls
to 
> the.....
>    - DB-specific code (in plugins?) that understands the data types
in 
> the particular DB.
> For example, when the user wants to add a field to a table:
>    - DB-agnostic code shows the "add field" button and gets the
action 
> command when the user clicks, and then calls the...
>    - DB-specific code which returns a list of the names of all the
data 
> types within this DB...
>    - so the DB-agnostic code can present that list to the user for 
> selection
> There will also be issues such as what options are allowed/required
for 
> each data type (null/not-null, field size, etc) and, in some cases,
the 
> exact syntax needed by the CREATE statement.
> 
> - I recall from a long time ago that some DBs did not allow ALTER on

> tables after they were created.  May not be a problem any more, but 
> something to look into.
> 
> - A decision will be needed on what to do with the result of the 
> design.  Is it output to text files for use by another tool, or is it

> executed by SQuirreL directly on the DB?  What happens to data
already 
> in the DB?  What kinds of warnings should be generated about changing

> the DB and possible loss of data?
> 
> - It would be good to include comments on the fields and the ability
to 
> view and print the schema details, eg:
>    integer                uid            // unique user id
>    VARCHAR(6)    userId   // login and screen name
>    VARCHAR(30)   userName   // full name of the user
> etc.  Those comments can be critical to remind people of the format,

> range, limits or expected use of the fields.
> 
> While it would probably be a lot of work, this could be a cool
feature 
> for the product!
> 
> Glenn
> 
> Fabrice GONNON wrote:
> 
>> Hi,
>>
>> Squirrel is a fabulous product and last version with choice to
>> integrate oracle plugin is very nice. Great work guy's ;o)
>>
>> I have a question:
>> There is in Squirrel the graph vizualisation (very good).
>> Is it planned or does exist a Designer plugin ? Because it is able
to
>> do a reverse representation, wuld it be easy to create a graph, and
then
>> to applicate it to a database ??
>> Or does somebody know a product that could do so ?
>> There is a market for it because it seems that DBdesigner4 is no
more
>> supported :-( and Druid does work only to create and doesn't have
>> reverse design...
>>
>> If so, Squirrel would be the best product for databases client
queries
>> AND design.
>>
>> Thank's again for your so good contribution.
>>
>> Fabrice.
>>
>>
**********************************************************************
>> This email and any files transmitted with it are confidential and
>> intended solely for the use of the individual or entity to whom
they
>> are addressed. If you have received this email in error please
notify
>> the system manager.
>>
**********************************************************************
>>
>>
>>
>> -------------------------------------------------------
>> 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

Re: [Squirrel-sql-users] Squirrel designer plugin ??

[Gerd W. <bir...@t-...>]

Hi,

I've been thinking about a designer since I finished the Graph plugin 
but I didn't have the time to start it. All the things Glenn mentions 
are true. That's why I thought of starting with something that for a 
first step allows you to

- create new tables
- create / delete foreign key constraints
- create / delete indexes
- add nullable columns to existing tables

My idea is that the designer should not be part of the Graph plugin or 
a new plugin but part of the SQL-Script plugin. My hope was the design 
could be done in a dialog window that could be opened either from the 
Object Tree or a Graph. Since the designer dialog is placed in the 
SQL-Script plugin it will simply creates DDL-Scripts in the SQL-Editor. 
The designer dialog only works with one table at a time.

Within the Graph plugin the user should be able to design more than one 
table before creating a DDL-Script. To do so the designer dialog needs 
to allow exports and imports of its state. The Graph plugin must be able 
to interpret this state and display it.

Within a Graph the user should be able to:
- Open the designer dialog for a table (tell the SQL-Script plugin to 
open the dialog and display the import data provided by the Graph)
- Script all changes done in the designer (tell the SQL-Script plugin to 
script all import data the Graph provides).


Perhaps those ideas can give you, Fabrice, or someone else the feeling 
that it shouldn't be too hard to begin. Of course your own ideas are 
needed and wanted too.

As Glenn mentioned some changes to the core will be needed. Especially 
some extensions to the way SQuirreL allows plugins to communicate would 
be necessary. Best would be if the one who does the work does the needed 
changes on the core too. I would surely be available for questions and 
advice.


Gerd


Glenn Griffin wrote:
> Hi Fabrice,
> 
> That sounds like a very nice feature.  Would you like to build it? :-)
> 
> The following random thoughts come to mind:
> 
> - This should be do-able as a plug-in.  As with any plug-in, we may need 
> to add some hooks to the core code for it to work, but that should not 
> be a problem.
> 
> - A graphical user interface for input is usually an order of magnitude 
> more difficult to build than a display-only interface because the user 
> needs to be able to not only grab and move objects, but also create 
> objects, insert things into them, resize them, etc.  Sounds like a lot 
> of work, though the result could be worth it.
> 
> - Automatically generating CREATE and ALTER statements is much more 
> complicated than generating SELECTs because databases are much less 
> standardized in defining the names of their data types and how they are 
> defined.  I'm guessing that the kind of tool you are describing would 
> need to have a strictly-maintained division between two sections:
>    - DB-agnostic code that handles the user interface and makes calls to 
> the.....
>    - DB-specific code (in plugins?) that understands the data types in 
> the particular DB.
> For example, when the user wants to add a field to a table:
>    - DB-agnostic code shows the "add field" button and gets the action 
> command when the user clicks, and then calls the...
>    - DB-specific code which returns a list of the names of all the data 
> types within this DB...
>    - so the DB-agnostic code can present that list to the user for 
> selection
> There will also be issues such as what options are allowed/required for 
> each data type (null/not-null, field size, etc) and, in some cases, the 
> exact syntax needed by the CREATE statement.
> 
> - I recall from a long time ago that some DBs did not allow ALTER on 
> tables after they were created.  May not be a problem any more, but 
> something to look into.
> 
> - A decision will be needed on what to do with the result of the 
> design.  Is it output to text files for use by another tool, or is it 
> executed by SQuirreL directly on the DB?  What happens to data already 
> in the DB?  What kinds of warnings should be generated about changing 
> the DB and possible loss of data?
> 
> - It would be good to include comments on the fields and the ability to 
> view and print the schema details, eg:
>    integer                uid            // unique user id
>    VARCHAR(6)    userId   // login and screen name
>    VARCHAR(30)   userName   // full name of the user
> etc.  Those comments can be critical to remind people of the format, 
> range, limits or expected use of the fields.
> 
> While it would probably be a lot of work, this could be a cool feature 
> for the product!
> 
> Glenn
> 
> Fabrice GONNON wrote:
> 
>> Hi,
>>
>> Squirrel is a fabulous product and last version with choice to
>> integrate oracle plugin is very nice. Great work guy's ;o)
>>
>> I have a question:
>> There is in Squirrel the graph vizualisation (very good).
>> Is it planned or does exist a Designer plugin ? Because it is able to
>> do a reverse representation, wuld it be easy to create a graph, and then
>> to applicate it to a database ??
>> Or does somebody know a product that could do so ?
>> There is a market for it because it seems that DBdesigner4 is no more
>> supported :-( and Druid does work only to create and doesn't have
>> reverse design...
>>
>> If so, Squirrel would be the best product for databases client queries
>> AND design.
>>
>> Thank's again for your so good contribution.
>>
>> Fabrice.
>>
>> **********************************************************************
>> This email and any files transmitted with it are confidential and
>> intended solely for the use of the individual or entity to whom they
>> are addressed. If you have received this email in error please notify
>> the system manager.
>> **********************************************************************
>>
>>
>>
>> -------------------------------------------------------
>> 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
> 

Re: [Squirrel-sql-users] problem editing

[Rob M. <Rob...@co...>]

Gerd Wagner wrote:
> 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!
Mark,

The install jar with Gerd's changes can be found here:

http://prdownloads.sourceforge.net/squirrel-sql/squirrel-sql-Snapshot-20060219_1100-install.jar?download

Rob

Re: [Squirrel-sql-users] problem editing

[Gerd W. <bir...@t-...>]

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
> 

Re: [Squirrel-sql-users] problem editing

[Gerd W. <bir...@t-...>]

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
> 

Re: [Squirrel-sql-users] problem editing

[Rob M. <Rob...@co...>]

Jack Eidsness wrote:
>
> I assume they are referring to one of the SQL standards out there, but 
> this normalization is apparently up to individual java developers (or 
> the jdbc driver developers?), and in the case of oracle jdbc, 
> undesirable.
>
> -Jack Eidsness
Jack,

According to SQL-92 the datetime types are:

DATE - Year, Month and Day components
TIME - Hour, Minute and Second components
TIMESTAMP - Year, Month, Day, Hour, Minute, Second components.

It seems correct then, that the hour, minute and second fields would be
"0" when one uses an Oracle's Date datatype.  I can recall switching to 
TIMESTAMPs
in the past when I needed this granularity. Either that, or simply 
storing millis
in a number field.

Rob

Re: [Squirrel-sql-users] Oracle and BIN$* tables

[Victor O. <vo...@gm...>]

The recyclebin feature is turned on. There are several ways and depths of
cleaning:

  PURGE TABLESPACE USERS;
  PURGE TABLESPACE USERS USER SPI;
  PURGE RECYCLEBIN;
  PURGE DBA_RECYCLEBIN; 

To directly drop without recyclebin:

  DROP TABLE <ZZZ> PURGE;

or disable the recyclebin.

Victor


Haug Bürger wrote:
> 
> Hello,
> 
> I'm using Squirrel 2.1 with an Oracle 10.2 database. I managed to 
> display the tables of my schema, only. But I can not get rid of the 
> BIN$* tables. Is there any chance to get rid of them? The list is long 
> enough anyway. I much prefer the Hora way of using letters to switch 
> between tables.
> 
> Regards
>         Haug

-- 
Telefonieren Sie schon oder sparen Sie noch?
NEU: GMX Phone_Flat http://www.gmx.net/de/go/telefonie

Re: [Squirrel-sql-users] Squirrel designer plugin ??

[Glenn G. <gw...@co...>]

Hi Fabrice,

That sounds like a very nice feature.  Would you like to build it? :-)

The following random thoughts come to mind:

- This should be do-able as a plug-in.  As with any plug-in, we may need 
to add some hooks to the core code for it to work, but that should not 
be a problem.

- A graphical user interface for input is usually an order of magnitude 
more difficult to build than a display-only interface because the user 
needs to be able to not only grab and move objects, but also create 
objects, insert things into them, resize them, etc.  Sounds like a lot 
of work, though the result could be worth it.

- Automatically generating CREATE and ALTER statements is much more 
complicated than generating SELECTs because databases are much less 
standardized in defining the names of their data types and how they are 
defined.  I'm guessing that the kind of tool you are describing would 
need to have a strictly-maintained division between two sections:
    - DB-agnostic code that handles the user interface and makes calls 
to the.....
    - DB-specific code (in plugins?) that understands the data types in 
the particular DB.
For example, when the user wants to add a field to a table:
    - DB-agnostic code shows the "add field" button and gets the action 
command when the user clicks, and then calls the...
    - DB-specific code which returns a list of the names of all the data 
types within this DB...
    - so the DB-agnostic code can present that list to the user for 
selection
There will also be issues such as what options are allowed/required for 
each data type (null/not-null, field size, etc) and, in some cases, the 
exact syntax needed by the CREATE statement.

- I recall from a long time ago that some DBs did not allow ALTER on 
tables after they were created.  May not be a problem any more, but 
something to look into.

- A decision will be needed on what to do with the result of the 
design.  Is it output to text files for use by another tool, or is it 
executed by SQuirreL directly on the DB?  What happens to data already 
in the DB?  What kinds of warnings should be generated about changing 
the DB and possible loss of data?

- It would be good to include comments on the fields and the ability to 
view and print the schema details, eg:
    integer                uid            // unique user id
    VARCHAR(6)    userId   // login and screen name
    VARCHAR(30)   userName   // full name of the user
etc.  Those comments can be critical to remind people of the format, 
range, limits or expected use of the fields.

While it would probably be a lot of work, this could be a cool feature 
for the product!

Glenn

Fabrice GONNON wrote:

>Hi,
>
>Squirrel is a fabulous product and last version with choice to
>integrate oracle plugin is very nice. 
>Great work guy's ;o)
>
>I have a question:
>There is in Squirrel the graph vizualisation (very good).
>Is it planned or does exist a Designer plugin ? Because it is able to
>do a reverse representation, wuld it be easy to create a graph, and then
>to applicate it to a database ??
>Or does somebody know a product that could do so ?
>There is a market for it because it seems that DBdesigner4 is no more
>supported :-( and Druid does work only to create and doesn't have
>reverse design...
>
>If so, Squirrel would be the best product for databases client queries
>AND design.
>
>Thank's again for your so good contribution.
>
>Fabrice.
>
>**********************************************************************
>This email and any files transmitted with it are confidential and
>intended solely for the use of the individual or entity to whom they
>are addressed. If you have received this email in error please notify
>the system manager.
>**********************************************************************
>
>
>
>-------------------------------------------------------
>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
>
>  
>

Re: [Squirrel-sql-users] problem editing

[Jack E. <ja...@pe...>]

Perhaps with another RDBMS, java.sql.Date ends up working as if it has 
no time-of-day.  Almost all of my experience is with Oracle.  After 
sending my previous mail, I noticed this text in the javadocs:

"To conform with the definition of SQL DATE, the millisecond values 
wrapped by a java.sql.Date instance must be 'normalized' by setting the 
hours, minutes, seconds, and milliseconds to zero in the particular time 
zone with which the instance is associated."

I assume they are referring to one of the SQL standards out there, but 
this normalization is apparently up to individual java developers (or 
the jdbc driver developers?), and in the case of oracle jdbc, undesirable.

-Jack Eidsness

Maury Hammel wrote:
> Jack Eidsness wrote:
>> I don't have any real help for your actual problem, but as a matter of 
>> nitpicking, java.sql.Date granularity down to milliseconds.
> 
> Yep, you're right.  Maybe I was thinking of java.sql.Types.DATE?
> 
> Anyway, I know Glenn and I had a discussion about this when he 
> implemented the extra stuff in the Data Type Controls tab in the Global 
> Preferences.  The Oracle DATE column is identified as a type 91, and a 
> type 91 doesn't allow time in the formatting.
> 
> 
> Maury
> 
> 
> 
> -------------------------------------------------------
> 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

Re: [Squirrel-sql-users] problem editing

[Maury H. <ml1...@sh...>]

Jack Eidsness wrote:
> I don't have any real help for your actual problem, but as a matter of 
> nitpicking, java.sql.Date granularity down to milliseconds.

Yep, you're right.  Maybe I was thinking of java.sql.Types.DATE?

Anyway, I know Glenn and I had a discussion about this when he 
implemented the extra stuff in the Data Type Controls tab in the Global 
Preferences.  The Oracle DATE column is identified as a type 91, and a 
type 91 doesn't allow time in the formatting.


Maury

Re: [Squirrel-sql-users] problem editing

[Jack E. <ja...@pe...>]

I don't have any real help for your actual problem, but as a matter of 
nitpicking, java.sql.Date granularity down to milliseconds.

-Jack Eidsness

Maury Hammel wrote:
> 
> 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.
> 
> This is probably due to the disagreement between Oracle and Java/JDBC 
> about dates.  In Java/JDBC, a DATE (i.e. java.sql.Date) doesn't have a 
> time value.  In Oracle it can.  I'm guessing that that it would work if 
> you changed the insert to:
> 
> insert into license values ('junk', trunc(sysdate));
> 
> 
> Maury
> 
> 
> 
> -------------------------------------------------------
> 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

Re: [Squirrel-sql-users] Re: problem editing

[Maury H. <ml1...@sh...>]

Mark:

> You're right !!  That does make a difference.  Regrettably, that doesn't 
> solve my problem, as we do store time information in our DATE fields.

Yes, it's going to be a problem with just about every Oracle database -- 
I haven't seen too many that actually use the TIMESTAMP data type. 
Unfortunately, the Oracle JDBC driver identifies a DATE column as a 
java.sql.Date, so SquirreL handles them that way.

I don't think it will be able to be fixed without some Oracle-specific 
coding -- maybe that could be added to the Oracle plug-in?


Maury

Re: [Squirrel-sql-users] Re: problem editing

[Maury H. <mh...@cr...>]

Mark:

> You're right !!  That does make a difference.  Regrettably, that doesn't 
> solve my problem, as we do store time information in our DATE fields.

Yes, it's going to be a problem with just about every Oracle database -- 
I haven't seen too many that actually use the TIMESTAMP data type. 
Unfortunately, the Oracle JDBC driver identifies a DATE column as a 
java.sql.Date, so SquirreL handles them that way.

I don't think it will be able to be fixed without some Oracle-specific 
coding -- maybe that could be added to the Oracle plug-in?


Maury
-- 

Maury Hammel
Technical Associate

Cronus Technologies Inc. (CTI)
250 - 2nd Ave. South
Saskatoon, SK  S7K 1K9  Canada

t. 306.652.5798 x107

http://www.cfactor.net

[Squirrel-sql-users] Squirrel designer plugin ??

[Fabrice G. <Fab...@hc...>]

Hi,

Squirrel is a fabulous product and last version with choice to
integrate oracle plugin is very nice. 
Great work guy's ;o)

I have a question:
There is in Squirrel the graph vizualisation (very good).
Is it planned or does exist a Designer plugin ? Because it is able to
do a reverse representation, wuld it be easy to create a graph, and then
to applicate it to a database ??
Or does somebody know a product that could do so ?
There is a market for it because it seems that DBdesigner4 is no more
supported :-( and Druid does work only to create and doesn't have
reverse design...

If so, Squirrel would be the best product for databases client queries
AND design.

Thank's again for your so good contribution.

Fabrice.

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************

[Squirrel-sql-users] Re: problem editing

[Mark N. <mar...@ho...>]

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

>This is probably due to the disagreement between Oracle and Java/JDBC about 
>dates.  In Java/JDBC, a DATE (i.e. java.sql.Date) doesn't have a time 
>value.  In Oracle it can.  I'm guessing that that it would work if you 
>changed the insert to:

>insert into license values ('junk', trunc(sysdate));


>Maury



You're right !!  That does make a difference.  Regrettably, that doesn't 
solve my problem, as we do store time information in our DATE fields.

Mark

Re: [Squirrel-sql-users] problem editing

[Maury H. <ml1...@sh...>]

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.

This is probably due to the disagreement between Oracle and Java/JDBC 
about dates.  In Java/JDBC, a DATE (i.e. java.sql.Date) doesn't have a 
time value.  In Oracle it can.  I'm guessing that that it would work if 
you changed the insert to:

insert into license values ('junk', trunc(sysdate));


Maury

Re: [Squirrel-sql-users] problem editing

[Mark N. <mar...@ho...>]

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

[Squirrel-sql-users] I can not see PACKAGES in object tab

[Mrinal G. <mkg...@ro...>]

Hi,
   
  I can not see PACKAGES in object tab. Only PROCEDURES are available.

Re: [Squirrel-sql-users] problem editing

[Rob M. <Rob...@co...>]

Mark Neher wrote:
>
> Rob, I just tried this feature and set it to use the primary key 
> only.  This didn't make a difference, unfortunately.  I'll try to post 
> a table definition as a couple folks have suggested, but I probably 
> won't get a chance to do so for a couple days.  BTW, our schema 
> contains some 300 tables, and I have only turned up a handful that 
> have this problem; most of them I can edit and update just fine.  I 
> haven't been able to find a common thread among the ones that fail...
Yes, the table definition will be useful ( also a test row that fails 
would be very useful as well)
That would allow us to step through the code and see exactly what is 
happening.

Rob

Re: [Squirrel-sql-users] problem editing

[Mark N. <mar...@ho...>]

Rob, I just tried this feature and set it to use the primary key only.  This 
didn't make a difference, unfortunately.  I'll try to post a table 
definition as a couple folks have suggested, but I probably won't get a 
chance to do so for a couple days.  BTW, our schema contains some 300 
tables, and I have only turned up a handful that have this problem; most of 
them I can edit and update just fine.  I haven't been able to find a common 
thread among the ones that fail...

Mark


=========================================

Mark,

One other thing to note that no one else has mentioned here - there is a
way to
limit what columns are used in the where clause that is used to build
the update statement.  The
"Limit cell edit WHERE clause size" can be used to restrict which
columns are used.  Right click
on the table to access this menu item.  Maybe just using the primary key
field(s) in this case
might help?

Rob