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).
Today is tomorrow's yesterday.