Copy and Insert DBRecord (Urgent for me)

[McKinley]

I'd like to get a DBRecord and use it as a template for an insert. Is
that possible?

if(reader.getRecordData(cmd, conn)){
    tableA.initRecord(recA, reader);
    // I would like to create a new record where only KeyColumn1 and Name
    // are different than the old one.
    // can't do the following, key is read only;
    //recA.setKeyColumn1(null);
    recA.setName("Some New Name for a New Record");
    recA.create(tableA, conn); // <-- still points to old primary key.
}

OK, thanks if you can help!

Cheers,

McKinley