TABLE 2: Type1 Refresh DDQ Task Properties' Queries Tab Information
Query Type Query Destination Parameter
Insert INSERT INTO Products_type1
(productid_app, productname, package)
VALUES(?, ?, ?)
productid_app
productname
package
1
2
3
Update UPDATE Products_type1
SET productname = ?, package = ?
WHERE productid_app = ?
productname
package
productid_app
1
2
3
Delete UPDATE Products_type1
SET discontinued = 1
WHERE productid_app = ?
productid_app 1