HomeAppeon for PowerBuilderAppeon for PowerBuilder Online Help

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 ASA/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 ASA/SQL Anywhere database, then deploy the application source code and record the scripts again. 

ConnectString='DSN=AppeonSample;UID=dba;PWD=sql',DisableBind=1
Prev  Up  Next
Out of memory error and the application server shut down  Home  Runtime errors causing scenario failure