>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. HTH, Set
