Subject RE: [firebird-support] Duplicate a set of records
Author Svein Erling Tysvær
>FB 1.5
>I have a number of records in a table, that includes a BLOB field, that I need to duplicate.
>Is there an easy way of doing that?

Hi Ed!

This question may be understood very differently. If you want to exactly duplicate the records, I don't know how to do that. If you want to duplicate the records, except the primary key, then do:

INSERT INTO MyTable(Field1, Field2...)
SELECT Field1, Field2...
FROM MyTable
WHERE PK IN (...) //Alternatively, where PK < ... or similar

If you generally want the value of one field duplicated to another field or another table, then I'd recommend using a trigger.

If you're looking for something different, then please clarify your question.