I'm needing to read a record, do some if statements to determine if I want to write this record out to this other table. And if it qualifies, then I want to write the entire row from this one table to another table. And the proceed to the next record of the first table. And go through the process again.

I have code written to write out field by field. My problem is now, I'm not sure what the field names will be. But they will be the same in each table. So if I just copy the entire row the it'll be safe and I won't have to try and figure out what each column is.

Any suggestions will be helpful.