Home > Archive > Clipper > January 2005 > Browse processing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have built and application of tbrowse consist of machines meter
reads(Copiers,printers) depend upond their meter.
My question is if my fields like this:
My fields are
month opening closing difference
month meter meter
I want every new opened month(row) to have opening like the closing
figure of previous month . My tbrowse depend on a filtered key which is
the serial number(unique key).
How can I do it in programming. Is set filter command close to the
records that meet the set filter condition if I dealt with reccount()-1
e.g:
month-opening meter-closing meter-prints
1 0 100 100
2 100 200 100
3 200 400 200 ....etc.
...
...
total : 400
I need to open month 4 with automatically opening 400 to forbid
mistakes. That is the normal But as exception , also some times we zero
the machine meter how can I make the total
also meet the last closing figure.
e.g:
month-opening meter-closing meter-prints
1 0 100 100
2 100 200 100
3 200 400 200
4 400 500 100 ....etc.
5 0 100 100 ....etc.
...
...
total : 600
I need to make the total 100 NOT 600 Because seeing the last closing
equal to the total is a remark of correctness entry .
| |
| AUGE_OHR 2005-01-19, 8:55 pm |
| correction to last msg :
> IF(closing meter=0, EXIT, NIL)
must be IF(opening meter=0
greetings by OHR
Jimmy
|
|
|
|
|