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:
01132729
Views:
15
Hi Terry

>How about opening the table again, under a different alis. Loop through one of them. At each rec do a select-SQL for the "difference" on the other incarnation of it, accumulatively appending your result cursor to a report cursor?

The cursor idea is good. Actually it is more simpler, I know the recno() / uniqueid of the records to be compared. The thing is that I have a record that is behaving correctly in the reports and there is another which is not giveing the results so I want to find out the differences, which will, hopefully lead me to the problem field value.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform