Microsoft SQL Server 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 SQL Server rules for the data type.
Example
Assume you enter the following statement:
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:
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 ( : ).