DisableBind parameter

PowerServer supports DisableBind differently from PowerBuilder in 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).

In the case of the DataWindow UPDATE statement, PowerServer will ignore the value of DisableBind and always uses the bind variables; and the NCharBind parameter always takes effect in PowerServer (Unlike PowerBuilder, for NCharBind to take effect, the DisableBind parameter must be set to 0).