| Subject | Copy row to row in stored procedure |
|---|---|
| Author | Valeri Mytinski |
| Post date | 2009-03-23T12:44:25Z |
I have to copy one (existing) row to another (new) row in the same
table within stored procedure.
3 steps needed as I see:
1. Fetch whole row into "record-like" variable or something else.
2. Change PK in "variable".
3. Insert new row with values from "variable".
Do you know easy way(s) for this? Or may be special tools for this exists in FB?
table within stored procedure.
3 steps needed as I see:
1. Fetch whole row into "record-like" variable or something else.
2. Change PK in "variable".
3. Insert new row with values from "variable".
Do you know easy way(s) for this? Or may be special tools for this exists in FB?