DisableBind parameter

PowerServer supports DisableBind differently from PowerBuilder for the case of the DataWindow UPDATE statement.

For example, suppose the database column "updatetime" is defined as below.

updatetime  datetime  not null default  getdate()

When DisableBind is set to 1, if the application user inserts a new row, but does not enter a value for the "updatetime" column, PowerBuilder and PowerServer both can insert the data to the database successfully.

However, when DisableBind is set to 0, if the application user inserts a new row, but does not enter a value for the "updatetime" column, then

  • PowerBuilder throws an error indicating that the "updatetime" column cannot be null.

  • PowerServer inserts the data row to the database successfully (the "updatetime" column takes the default value from database).

PowerServer handles DisableBind="0" in the same way as DisableBind="1" for the case of the DataWindow UPDATE statement.