Re: [Squirrel-sql-users] SQLReplace Plugin

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

The plugin uses the message display window to tell you which of your
replace patterns was used, and what the replacement value used was.
So, you will know that the replacement was made before the query was
sent to the server. However, the original query text remains in the
SQL Editor, unaltered.

Rob

On 2/12/09, John Hardin <jh...@im...> wrote:
> On Wed, 11 Feb 2009, Matthew Dahlman wrote:
>
> > Thanks for the idea. It can't be exactly that, since the Replace-Rule
> > indicates that it is indeed changing $P{StartDate} to '2008-01-01'.
>
> I've not played with that plugin so forgive me if I'm asking obvious
> questions...
>
> Does the query tab display the query post-replacement? Or does it display
> the original query and the replacement rules that should be applied?
>
> If the latter, how do you *know* the replacement actually took place?
>
> > But after making that replacement then it doesn't execute the query.
> >
> > Does anyone have thoughts on how to figure out why the query doesn't get
> > run?
>
> What's your DB backend?
>
> Is there any way to tell it to trace or profile the connection?
>
> Worst case, try sniffing the network traffic and see whether the query is
> actually being sent to the DB, and if so, what the query text is (assuming
> the protocol sends it in the clear).
>
> > -----Original Message-----
> > From: John Hardin [mailto:jh...@im...]
> > Sent: Wednesday, 11 February, 2009 13:26
> > To: Matthew Dahlman
> > Cc: squ...@li...
> > Subject: Re: [Squirrel-sql-users] SQLReplace Plugin
> >
> > On Wed, 11 Feb 2009, Matthew Dahlman wrote:
> >
> >> But when I run this SQL nothing gets executed: select $P{StartDate} I
> >> can see in the execution window below that SQLReplace is working,
> >> since it shows this:
> >> Replace-Rule: $P{StartDate} = '2008-01-01'
> >>
> >> But the query doesn't get executed. Somewhere along the line the curly
> >> braces cause something not to work. I'm not sure how to troubleshoot it.
> >> I'm not even sure if the problem is with SQLReplace or if it's
> >> somewhere else in SQuirreL.
> >
> > Curly braces delimit comments in some SQL dialects (e.g. Informix), the
> > plugin might be treating that as a comment and not performing the
> > replacement.
> >
> > 'course, I'm just guessing.
>
> --
>  John Hardin KA7OHZ                    http://www.impsec.org/~jhardin/
>  jh...@im...    FALaholic #11174     pgpk -a jh...@im...
>  key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C  AF76 D822 E6E6 B873 2E79
> -----------------------------------------------------------------------
>   An AR-15 in civilian hands used to defend a home or business:
>     a High Velocity Assault Weapon with High Capacity Magazines
>   An AR-15 in Law Enforcement Officer hands used to murder six kids:
>     a Police-Style Patrol Rifle
> -----------------------------------------------------------------------
>  Today: Abraham Lincoln's and Charles Darwin's 200th Birthdays
>
> ------------------------------------------------------------------------------
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>