Re: [Squirrel-sql-users] Does SQuirreL not understand "&&" notation?

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

And thanks goes to Dieter Engelhardt for writing that plugin :)

Cheers,

Rob

On Tue, Aug 18, 2009 at 7:54 PM, KARR, DAVID (ATTCINW)<dk...@at...> wrote:
>> -----Original Message-----
>> From: Robert Manning [mailto:rob...@gm...]
>> Sent: Tuesday, August 18, 2009 4:50 PM
>> To: KARR, DAVID (ATTCINW)
>> Cc: squ...@li...
>> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
>> notation?
>>
>> I feel that I must tell you the help documentation is very terse.
>> However, it's easy to configure:
>>
>> File -> Global Preferences -> SQLReplace
>>
>> add key = value and click 'Save'
>
> Perfect.  Works like a charm.
>
> Thanks.
>
>> On Tue, Aug 18, 2009 at 5:54 PM, KARR, DAVID (ATTCINW)<dk...@at...>
>> wrote:
>> >> -----Original Message-----
>> >> From: Robert Manning [mailto:rob...@gm...]
>> >> Sent: Tuesday, August 18, 2009 2:37 PM
>> >> To: KARR, DAVID (ATTCINW)
>> >> Cc: squ...@li...
>> >> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand "&&"
>> >> notation?
>> >>
>> >> Actually, the sqlreplace plugin will let you replace *ANY* pattern
>> >> with another.  So, for example this works:
>> >>
>> >> SELECT * FROM BIGINT_TYPE_TABLE where MYID = &&val;
>> >>
>> >> when SQL Replace plugin is configured with the following pattern
>> >> replacement:
>> >>
>> >> &&val = 1
>> >>
>> >> If the scripts only have a few "unique" variables (or non-unique
>> >> variables with the same value) then
>> >> this could work.
>> >
>> > Oh.  I didn't realize that.  I'll see if I can figure out the doc for
>> it and experiment with that.
>> >
>> >> And yes, the Oracle plugin already handles some very common SQL*Plus
>> >> syntax.
>> >> So, you can submit a feature request.  If you can give specific test
>> >> cases that would be helpful.
>> >
>> > Ok, thanks.
>> >
>> >> On Tue, Aug 18, 2009 at 12:04 PM, KARR, DAVID
>> (ATTCINW)<dk...@at...>
>> >> wrote:
>> >> >> -----Original Message-----
>> >> >> From: Robert Manning [mailto:rob...@gm...]
>> >> >> Sent: Tuesday, August 18, 2009 4:19 AM
>> >> >> To: KARR, DAVID (ATTCINW)
>> >> >> Cc: squ...@li...
>> >> >> Subject: Re: [Squirrel-sql-users] Does SQuirreL not understand
>> "&&"
>> >> >> notation?
>> >> >>
>> >> >> This is an SQL*Plus feature - it is Oracle-specific and not
>> standard
>> >> >> SQL (http://www.orafaq.com/node/515)
>> >> >>
>> >> >> I'm not sure, but you may be able to use the SQLParam or
>> SQLReplace
>> >> >> plugins to setup the values for the variables that are in your
>> >> script.
>> >> >
>> >> > It doesn't appear as if these will help, as they apparently
>> require a
>> >> specific syntax in the script.
>> >> >
>> >> >> On Mon, Aug 17, 2009 at 11:32 AM, KARR, DAVID
>> >> (ATTCINW)<dk...@at...>
>> >> >> wrote:
>> >> >> > I tried to load a SQL script for Oracle that references
>> variables
>> >> >> with
>> >> >> > the "&&" notation.  SQuirreL failed to grok it.  Is this a
>> known
>> >> >> > limitation?  I'm installing SQL Developer right now to verify
>> the
>> >> >> script
>> >> >> > works there at least.
>> >> >> >
>> >> >> > ---------------------------------------------------------------
>> ---
>> >> ---
>> >> >> ---------
>> >> >> > Let Crystal Reports handle the reporting - Free Crystal Reports
>> >> 2008
>> >> >> 30-Day
>> >> >> > trial. Simplify your report design, integration and deployment
>> -
>> >> and
>> >> >> focus on
>> >> >> > what you do best, core application coding. Discover what's new
>> >> with
>> >> >> > Crystal Reports now.  http://p.sf.net/sfu/bobj-july
>> >> >> > _______________________________________________
>> >> >> > Squirrel-sql-users mailing list
>> >> >> > Squ...@li...
>> >> >> > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>> >> >> >
>> >> >
>> >
>