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 inserting a new row with DisableBind = 1
When DisableBind is set to 1 (not using bind variables), and 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.
-
When inserting a new row with DisableBind = 0
When DisableBind is set to 0 (using bind variables), 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).
-
