Thunderstone Support Forums

I've got a table that has about 30 columns of large data, and the table has many rows. I'd like to create a companion table that contains, for each field/row in the data table, a checksum (i.e., using <hash>) of the data in the data table, where the structure of the checksum table matches the structure of the data table.

Any thoughts about the most efficient way to do something like this?

Thanks in advance.

For the actual processing a loop something like:

<sql row "select * from datatable">
<calchashes>
<sql novars "insert into hashtable ..."></sql>
</sql>