Compare FoxPro Tables


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Compare FoxPro Tables

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    Compare FoxPro Tables

    [Originally posted by pcprgmr]

    Anyone have a good solution to comparing Data in foxpro tables?

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Compare FoxPro Tables

    [Originally posted by Sabir Mustafa]

    Please tell in what way you want to compare data?

  3. #3
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Compare FoxPro Tables

    [Originally posted by pcprgmr]

    I want to be able to input two tables and have the program give me back a list of differences in the data. the table structures will be identical, I just want to compare the data.

  4. #4
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:Re:Compare FoxPro Tables

    [Originally posted by Sabir Mustafa]

    although, i am presently not using FoxPro, I had an example from my memory. Try it!

    Ok, let's take an example. You have two tables, Cust1 and Cust2 Having structure of

    Custid
    CustName
    CustAge

    The Custid in Cust1 is primary key;
    make a .prg or use command window and type following commands:

    sele 1
    use cust1 index ID1
    sele 2
    use cust2 index ID2

    sele 1
    set rela to custid into cust2
    brow for cust1.custid<>cust2.custid



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center