Brian (and everyone else who replied),
Thank you for the replies which helped me solve this (for me)
longstanding problem.
I did read Ralph Alvy book on this issue, but it took me several times
(and only after reading BH's simpler explanation) what the issue was
(let alone the solution).
Thank you again.
Victor Warner.
Brian Hancock wrote:
Hi Victor,
DP evaludate string comparisons against the shortest field...
consequently you need to pad beyond the last expected string with a
dummy value, or also compare the string lengths...
I would try this
If cat.t[p1f1;"@"] = "10@" then p1f3 endif
Regards
Brian
----- Original Message ----- From: "Victor Warner" <[EMAIL PROTECTED]>
To: "Dataperfect Users Discussion Group" <[email protected]>
Sent: Monday, July 23, 2007 6:57 PM
Subject: Re: [Dataperf] realigning totals in anothers
Brian,
Thank you. The numbers were out of sync because they had been
exported and imported. Your outline brought back what commands I
needed to enter into the report definition.
I have another issue which I would be grateful for some guidance:
I have a field which is formatted as A2, and contains 1, 2, 3, 4, 5,
6, 8, 9, 10
In a second field I wish to select information from a third field
based on whether the second field has a 1, 2, etc in it , but when I
enter
If p1f1 = "10" then p1f3 endif
I get the selection for the A2 field whether it is "1" or "10". Is it
possible to set up the If statement that only "10" entries are selected?
Victor Warner.
Brian Hancock wrote:
Hi Victor,
There are a couple of ways, one way is:
Run a report on the panel that holds the total and in the Report
body include:
*Zeroing a Report Variable to act as an accumulator
*Include a Sub Report(s) with the panel(s) containing the totals
linked to the parent panel
*Add/Subtract whatever the values to be totalled to the accumlator
*Exit the subreport
*Store the accumlator RV into the Totals field on the parent panel
You shoud check to see why the values are out of sync, if it just
because you exported and imported all the records from a table but
made a mistake regarding the totals, then not so bad... but if it
from a logic error, (not easy to do but can happen) then you should
try to rectify it
Bye
Brian
----- Original Message ----- From: "Victor Warner"
<[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Sunday, July 22, 2007 9:17 AM
Subject: [Dataperf] realigning totals in anothers
I have a database with some fields in one panel being added to
added to a field in another panel (keep a total).
The totals in the other panel for some records are no longer accurate.
I would like the other panel fields which hold the totals to be set
to zero and then the totals added back. I asked this question a
number of years ago but cannot find the answer anymore. I would be
grateful on knowing how to do this again.
Victor Warner.
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
