Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement