Hi,

I'm trying to use an executable procedure to copy a row from one
table to another. What's the best way of doing this? I'm currently
trying to use a SELECT statement to read the row, then an INSERT to
add it to the other table.

for
SELECT DATA FROM TABLE_1 WHERE ID = :SOMETHING INTO :LOCAL_VARIABLE
do
begin
INSERT INTO TABLE_2 VALUES (:LOCAL_VARIABLE)
end

but this isn't working. Is there a better way of doing this, like a
specific function for copying rows?

Thanks