> CASE _tally = ct && (means both tables has same counts, so need to verfiy side-by-side)
> SELECT histpo
> SELECT * FROM histpo TO histtemp WHERE po = varpo
> SELECT tempcur
> SELECT * FROM tempcur TO temptemp
>
>***
>***THIS SECTION IS WHERE I NEED HELP!!!
>***
>
> SCAN FOR po = varpo
> IF class = varclass AND ;
> fund = varfund AND ;
> udds = varudds AND ;
> amount = varamount AND ;
> fy = varfy AND ;
> activity = varactivity AND ;
> account = varaccount
> SELECT histtemp
> DELETE
> SELECT temptemp
> DELETE
> LOCATE
> ELSE && (means tempcur has updated data, need to DELETE records in HISTPO, add new records into HISTPO)
> SELECT tab3
> APPEND FROM tempcur
> EXIT
> ENDIF
> SELECT histtemp
> IF BOF() && (see next 2nd line)
> SELECT temptemp
> IF BOF() && (means ALL matches)
> SELECT tab2
> APPEND FROM tempcur
> ELSE
> SELECT tab3
> APPEND FROM tempcur
> ENDIF
> ELSE
> SELECT tab3
> APPEND FROM tempcur
> ENDIF
> ENDSCAN
>
>
>What is wrong here? I have two tables and both have duplicate recs and same counts of duplicates (5 recs and 5 recs or 4 and 4 or 2 and 2). I need to track so I can know if updated or not, so I can report it (there are no forms so it is click and snip coffee and walk to printer kind of execute).


Chuck- the reason you are not getting help quickly, is because the format of your question makes it laborious to analyze the problem.
Do:

-State the problem
-Give a brief description of your previous attempts to solve the problem, and tell why you think they failed.
-Give a few lines of code to demonstate what you have tried, what you expected, and what happened instead.
-Ask for suggestions on how to solve a specific problem, or general strategy ideas.


Don't:
-post reams of code and expect everybody to patiently wade through and analyze
-expect us to guess at the purpose of the posted code
-expect us to guess at what is going wrong

I (and most others here) love to solve problems. But I don't like to write entire programs for others for free, and I don't like to spelunk through other's code for free.