Re: Powerbuilder and DisableBind=1

I don't know why, but when you do this, the sql preview event allows you to view the actual values of data going into the sql commands. Otherwise, all you get is :1,:2, etc.

-Powerbuilder Folk.

On Thu, 14 Jan 1999 16:39:41 -0600, "Kevin Brand" <kevin.brandx_at_tel.gte.com> wrote:

>
>Why would anybody want to do this in a large OLTP application built in
>powerbuilder?
>
>Setting this global parameter at connect time disables the use of bind
>variables, which causes all the usual problems associated with heavy use of
>literal SQL.
>
>Any Powerbuilder folks out there that might have some insight into why a
>developer would want to use this, globally?
>
>I can understand the need in certain DSS systems and possibly other queries
>where we want to inform the optimizer as best we can ( specific value and
>value ranges instead of "blind" variables ), but system wide, I think not.
>
>-Kevin
Received on Fri Jan 22 1999 - 22:32:33 CST