update "parts.db"
set "parts.db"."Retail Price" =
(("parts.db"."Retail Price" * :percentage) + "parts.db"."Retail Price")
where "parts.db"."Part Number" like :pre
and "parts.db"."Retail Price" < :high
and "parts.db"."Retail Price" > :low
A: Update queries do not return any information. They just update.
You used open or active := true when you called the SQL statement.
That expects a cursor to be returned. Use ExecSQL instead.