Re: Powerbuilder and DisableBind=1

From: Reid Lai <reidlai_at_hk.super.net>
Date: Tue, 26 Jan 1999 20:13:30 +0800
Message-ID: <36ADB16A.95664D8B@hk.super.net>

Hi Kevin,

When you see the sql statement in SQLPreview event, you may find the sql statement like the following:

UPDATE your_table SET col_1 = :1, col_3 = :2, col_6 = :3

This statement is prepared by using row status and item status of the first modified rows in this datawindow. This statement will be used by the following modified rows. Could you
see the problem?

Suppose a user is modifying the first, the second, and the third row in a datawindow. The user changed the following rows and columns:

1st row -> column 1, column 3, column 6
2nd row -> column 1, column 3, column 6
3rd row -> column 1, column 3, column 6

Then the above sql statement can be applied efficiently. But when the user changed the following rows and columns:

1st row -> column 1, column 3, column 6
2nd row -> column 2, column 4, column 7
3rd row -> column 3, column 4, column 5

The above sql statement cannot be used. Because PB will generate the same statement for all three modified rows:

UPDATE your_table SET column_1 = :1, column_3 = :2, column_6 = :3

DisableBind will force PB to prepare individual sql statement for each modified rows to solve the problem. Hope this can help you. --
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Jan 26 1999 - 06:13:30 CST