Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checksum for a whole record
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00763322
Message ID:
00767468
Views:
15
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
Map
View

Click here to load this message in the networking platform