General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
hi
I had the same problem... I had to ensure that the db installed is the same that the one I've been testing with...
so I had to get a 'checksum' of the columns of each table and obtain a number that identifies the db structure. But as you say, the checksum may not be unique for each value.... what ensures uniqueness is a hash.
So I used Milan's CryptPak to MD5 every record...
I don't have the code right now... but the idea is smthg like this:
while not eof
read a record from the table
hash_rec = hash_rec + read_rec
hash_rec = MD5(hash_rec)
end
so, it will concatenate each record and obtain a unique identifier.
hope this helps you.
fabian
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only