Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compare 2 or more rows from the same table for differenc
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01132653
Message ID:
01132661
Views:
9
This message has been marked as a message which has helped to the initial question of the thread.
Hi Bhav

Not sure how detailed this is. For instance, are you checking every field in one rec against every field in all others, or just certain fields?

Whatever, you may find the INDEXSEEK() function useful. It allows you to seek data in the same table without moving the record pointer from the current record.

Howver, the fields you seek DO have to be indexed of course.

HTH

Terry
>Hi all
>
>Maybe I am growing old but is there an easy way to compare records from the same table for differences, rather more like a list of differences. I have to get the non-tech/low-tech to compare select data for such differences thus the need for a utility.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform