DisableBind

[Former Member]

PowerBulder 12.6

Both Below SQL statements work with a ODBC connection to an access database.

Both were working with a ODBC connection to a sql database, but 1 has stopped

The pb.ini file has the below statement.

SQLCA.DbParameter="DisableBind=1"

I have have the same sql statement on a click event of a picture button that is in the exact reverse of the 1st below SQL statement and it works.

Using a select statement to select all the values

then use another sql insert statement to insert the record was my work around.

Both SQL statements are in the same window on two different picture buttons.

Seems like the DisableBind works with one picture button but not the other.

Does not work....

INSERT INTO rsrvcan

( r_conf_no, r_conf_group, guest_num, r_room_no )

SELECT reserve.r_conf_no,

reserve.r_conf_group,

reserve.guest_num,

reserve.r_room_no

FROM reserve

WHERE reserve.r_conf_no = :ll_confirm ;

WORKS...

INSERT INTO reserve

( r_conf_no, r_conf_group, guest_num, r_room_no )

SELECT rsrvcan.r_conf_no,

rsrvcan.r_conf_group,

rsrvcan.guest_num,

rsrvcan.r_room_no

FROM rsrvcan

WHERE rsrvcan.r_conf_no = :ll_confirm ;