DisableBind parameter

Suppose the database column updatetime is defined as below.

updatetime  datetime  not null default  getdate()

If the application user inserts a new row, but does not enter a value for this column, then when DisableBind is set to 0,

  • 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 PowerServer, DisableBind always takes value 0 for the DataWindow UPDATE statement and may ignore the null value according to the sqldefault attribute; while takes value 0 or 1 for the DataWindow SELECT statement and ESQLs.