Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Identify fields where values are different between recor
Message
From
21/09/2005 10:18:43
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
21/09/2005 10:07:02
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01051585
Message ID:
01051634
Views:
15
This message has been marked as a message which has helped to the initial question of the thread.
Jay,
You now have them sorted one after another.Do something like this:
scan
  scatter memvar
  skip
  for ix=1 to fcount()
    if eval(field(m.ix)) # eval('m.'+field(m.ix))
       ? eval(field(m.ix)),eval('m.'+field(m.ix))
    endif
  endfor
endscan
Cetin

>Except...
>
>Your code identifies the records, but what I need is to identify the fields that are different. I will basically be comparing one record in one table to one record in another table and want to get a list of the fields who's values differ.
>
>Can't believe I didn't catch that earlier...
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform