>select workpo
>scan
>IF workpo.FIELD1 = histpo.field1 then
> * ok, its a match
>else
> * mark the sucker
>endif
>endscan
Can you help me somemore please. I think I need a new way of understand programming. I have done many FPW 2.6 PRG coding! I am doing this with VFP 6.0 (basicly first project for assignment).
So, what you suggest? All I have to do is import data from XLS file, compair existing history and then export new to text file and report (well, thats the bottom, easy-to-say points).
I need to mark something (1,2,3,4) for reports (I think it is the easiest). All I need is to learn how to compair side-by-side with dupe records. First, I get the PO (a field) from WORKPO and see if there is an existing PO in the HISTPO, I need to check if it is the same (if same, mark it "2" for "no action") or updated (if different, mark it "3" for "changed"). If there is none existing PO in the HISTPO, it is a new PO (mark it "1" for "new transaction"). The other thing is sometime there can be 4 existing PO (4 records) in HISTPO and new 6 PO (matched with the 4 PO) in the WORKPO (that would be marked as "3"), I need to REMOVE those 4 records out of HISTPO and add the new 6 PO into the HISTPO. Boy, I have to get this done by next week and I am confused already! Another way is I could copy out records and do temp matching and go back to the WORKPO and mark them??????
Today is tomorrow's yesterday.