Thread: [Squirrel-sql-users] 2.6x Oracle-Problems with script
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: LeO W. <le...@gm...> - 2009-01-28 10:28:03
|
I have installed the lastest snapshot 20090127_0130 and the changes are really nice. I like them really. On the other hand, don't know where to post tiny issues, like - CTRL-F: Search finds the item, but clicking on ESC returns the cursors position to somewhere, while pressing ENTER the cursor remains in the text-field. - Clossing sessions seems a tricky issue. Cause when I close a second session, I am unable to close the very first one. Therefore I cannot drop the user any more. This seems due to the new design. The main problem is a strange problem: I have a SQL-script, which I wanna execute. When I wanna execute it completely, all at once, I get the Message-box: Please input parameter values: Value for ':mi' with Quote Values: enabled (but this checkbox is not changeable). When I execute them bit by bit then Message-box is never shown. So, I guess it has to do something with the preevaluation. Since there is this check-box, I wonder, if this is some kind of preference-setting which could be enabled resp. disabled. If so, where to find it? Any ideas, about the strange behaviour between a complete execution and the piece-by-piece execution? LeO -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger |
From: Robert M. <rob...@gm...> - 2009-01-28 12:55:51
|
For the main problem that you mentioned, there is a plugin called "sqlparam" which allows you to embed parameters in your scripts that start with a colon (for example :mi). If this is not desired you can disable the plugin using "Plugins" -> "Summary" : uncheck "Load at Startup" for "sqlparam". Rob On Wed, Jan 28, 2009 at 5:27 AM, LeO Welsch <le...@gm...> wrote: > I have installed the lastest snapshot 20090127_0130 and the changes are really nice. I like them really. > > On the other hand, don't know where to post tiny issues, like > > - CTRL-F: Search finds the item, but clicking on ESC returns the cursors position to somewhere, while pressing ENTER the cursor remains in the text-field. > > - Clossing sessions seems a tricky issue. Cause when I close a second session, I am unable to close the very first one. Therefore I cannot drop the user any more. This seems due to the new design. > > The main problem is a strange problem: > > I have a SQL-script, which I wanna execute. When I wanna execute it completely, all at once, I get the Message-box: > > Please input parameter values: Value for ':mi' with Quote Values: enabled (but this checkbox is not changeable). > > When I execute them bit by bit then Message-box is never shown. So, I guess it has to do something with the preevaluation. Since there is this check-box, I wonder, if this is some kind of preference-setting which could be enabled resp. disabled. If so, where to find it? > > Any ideas, about the strange behaviour between a complete execution and the piece-by-piece execution? > > LeO > -- > Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger > > ------------------------------------------------------------------------------ > This SF.net email is sponsored by: > SourcForge Community > SourceForge wants to tell your story. > http://p.sf.net/sfu/sf-spreadtheword > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
From: LeO W. <le...@gm...> - 2009-01-28 15:42:45
|
Unloading the sqlparam and remove it solved the problem. Thx. The string ':mi' is only in the context of insert into PROFILE (DATE_CREATED) values (to_date('20-12-2007 14:15:14', 'dd-mm-yyyy hh24:mi:ss')); AND execution of them individually works fine. But somehow the whole script at once fails. And that's what is strange. Anyway, turnig off, works now. Thx. LeO -------- Original-Nachricht -------- > Datum: Wed, 28 Jan 2009 07:55:43 -0500 > Von: Robert Manning <rob...@gm...> > An: LeO Welsch <le...@gm...> > CC: squ...@li... > Betreff: Re: [Squirrel-sql-users] 2.6x Oracle-Problems with script > For the main problem that you mentioned, there is a plugin called > "sqlparam" which allows you to embed parameters in your scripts that > start with a colon (for example :mi). If this is not desired you can > disable the plugin using "Plugins" -> "Summary" : uncheck "Load at > Startup" for "sqlparam". > > Rob > > On Wed, Jan 28, 2009 at 5:27 AM, LeO Welsch <le...@gm...> wrote: > > I have installed the lastest snapshot 20090127_0130 and the changes are > really nice. I like them really. > > > > On the other hand, don't know where to post tiny issues, like > > > > - CTRL-F: Search finds the item, but clicking on ESC returns the cursors > position to somewhere, while pressing ENTER the cursor remains in the > text-field. > > > > - Clossing sessions seems a tricky issue. Cause when I close a second > session, I am unable to close the very first one. Therefore I cannot drop the > user any more. This seems due to the new design. > > > > The main problem is a strange problem: > > > > I have a SQL-script, which I wanna execute. When I wanna execute it > completely, all at once, I get the Message-box: > > > > Please input parameter values: Value for ':mi' with Quote Values: > enabled (but this checkbox is not changeable). > > > > When I execute them bit by bit then Message-box is never shown. So, I > guess it has to do something with the preevaluation. Since there is this > check-box, I wonder, if this is some kind of preference-setting which could be > enabled resp. disabled. If so, where to find it? > > > > Any ideas, about the strange behaviour between a complete execution and > the piece-by-piece execution? > > > > LeO > > -- > > Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit > allen: http://www.gmx.net/de/go/multimessenger > > > > > ------------------------------------------------------------------------------ > > This SF.net email is sponsored by: > > SourcForge Community > > SourceForge wants to tell your story. > > http://p.sf.net/sfu/sf-spreadtheword > > _______________________________________________ > > Squirrel-sql-users mailing list > > Squ...@li... > > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > > -- Psssst! Schon vom neuen GMX MultiMessenger gehört? Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger |