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.
|
1 |
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).