SAP Adaptive
Server Enterprise DELETE, INSERT, and UPDATE
Internally, PowerBuilder processes DELETE, INSERT, and UPDATE
statements the same way. PowerBuilder inspects them for any PowerScript
data variable references and replaces all such references with a constant
that conforms to Adaptive Server Enterprise rules for the data
type.
Example
Assume you enter the following statement:
|
1 |
DELETE FROM employee WHERE emp_id = :emp_id_var; |
In this example, emp_id_var is a PowerScript data variable with the
data type of integer that has been defined within the scope of the script
that contains the DELETE statement. Before the DELETE statement is
executed, emp_id_var is assigned a value (say 691) so that when the DELETE
statement executes, the database receives the following statement:
|
1 |
DELETE FROM employee WHERE emp_id = 691; |
When is this substitution technique
used?
This variable substitution technique is used for all PowerScript
variable types. When you use embedded SQL, precede all PowerScript
variables with a colon ( : ).
See also