Thanks Mike No PK so did SCAN then selectOther then COMPOBJ then a skip
It was so fast I changed some records to ensure it was doing its job properly. Andrew Stirling 01250 874580 http://www.calcpay.co.uk HMRC Accredited UK payroll program MB Software Solutions General Account wrote: > Andrew Stirling wrote: Hi I have 2 tables that should have the same > data in them. How do I confirm this? nb same field names. Thanks > > > > You could do a SCATTER on each table, locating on the same PK records and > then compare the objects using COMPOBJ. > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
