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:
00763323
Views:
15
Alex,

VFP8 has new SYS(2017) function - Record Checksum Value.

>Hi everybody,
>
>Wondering if anyone has a function to create a checksum for a WHOLE record in a table.
>
>For example, I have a table that has 128 fields and need a quick way to find duplicate records. I thought about doing a sys(2007) of a couple of fields, but not only I am getting unreliable results (several records that are different are yielding the same checksum) but I now need to compare ALL fields in order to determine uniqueness.
>
>If anyone can share some code or if there's anything already built into vfp, I'd appreciate a pointer...
>
>Thanks a lot!
>
>Alex
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform