Hi Victor,
Even though mine was simpler, Ralph's is far more comprehensive...
I should have mentioned one more gotcha regarding this
Although I said that DP evaluates against the shorttest string value, it
only applies where the string length is greater than zero...
so
"A"="abc" is true
"A"="AB" is true
"A"="A" is true
"A"="" is false
"A"=" " is also false
I keep forgetting the last couple...
Regards
Brian
----- Original Message -----
From: "Victor Warner" <[EMAIL PROTECTED]>
To: "Dataperfect Users Discussion Group" <[email protected]>
Sent: Wednesday, July 25, 2007 12:07 PM
Subject: Re: [Dataperf] realigning totals in anothers
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
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
