Yes, you are confusing us.
You always need to delete records where those three columns have those three values regardless of the input data? Or you need to delete those values because they are in the input data? The former calls for hard-coding and the latter calls for getting your delete syntax correct.
Clear the rows before inserting depending on non key coloumn
Moderators: chulett, rschirm, roy
Then why not simply put a delete statement for those values (same as you would run in Toad or sqlplus) anywhere that runs before the main stage actions. For OCI, 'before sql'. For the Enterprise stage, in the 'Open' statement area I would guess.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers