Field values do not change after parameterization and playback

Phenomena A: The corresponding field values in the records do not change after the SQL parameterization and script playback, when using SAP SQL Anywhere database.

Solution A:

Steps to reproduce:

  1. Record in the Test Mode: DataWindow > Updating > Change Employee Salary function.

    "UpDateSQL_1 = update \"employee\" set \"salary\" = ? where \"emp_id\" =?……"
  2. In the record scripts, create a new parameter "Salary" for the incremental change, and parameterize the SQL statements, as shown below:

    "UpDateSQL_1 = update \"employee\" set \"salary\" = {salary} where
     \"emp_id\" = 105……"
  3. Play back the scripts.

Phenomena B: When open another URL, the value of salary in records such as \"emp_id\" = 105 are found unchanged.

Solution B: The connection parameters (DisableBind=1) should be set in PowerBuilder for the SAP SQL Anywhere database, then deploy the application source code and record the scripts again.

ConnectString='DSN=AppeonSample;UID=dba;PWD=sql',DisableBind=1