Check last line

teckpoh

Hi...Anyone know how to use if..else statement..to check when system reach last row of table?

kriki

Before starting a FINDFIRST-REPEAT-UNTIL, you can do a FINDLAST and keep that record in a different global.
Later you can test with primary keys if you have reached that record.

Why do you need to know this?
I ask that because maybe there is a better way than this extra read on the DB to solve your problem.

teckpoh

Actually tis topic i created is to solve problem of other topic (in forum).
The topic name --> "Transheader & transfooter"

Help me~