Re: SQL+ question

It's Saturday evening, and sadly we are still working, so let's keep it friendly at least!

The point is to not edit the sql statement (which often comes over as a single huge long text line) but to run it by setting the parameters for it externally. I know in DNS you can say "using" and list the bind variable. What about regular SQL?

ianal Vista wrote:
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in
> news:to24825sgvsi9ucd6o2m7fvp28s1uitk8r_at_4ax.com:
>
> > On Sat, 03 Jun 2006 19:40:49 GMT, ianal Vista
> > <ianal_vista_at_hotmail.com> wrote:
> >
> >>Did you ever bother to try something like the following:
> >>
> >>select * from T where Col1 = 1234;
> >
> > Which would convert the query into one using hardcoded literals with a
> > potentially different execution path.
> >
>
>
> What does this point have to do the OP desire to get results set?
>
> >Sometimes I like to take a look at the result set by inspecting the sql
> >string in the code at runtime and then pasting it into sql+.
Received on Sat Jun 03 2006 - 20:12:01 CDT