Actually, my post below is incorrect. The cat.t function is needed
in a formula like this to ensure that any trailing spaces are
truncated before the comparison is made, so you should stick with
Brian's suggestion:
If cat.t[p1f1;"@"] = "10@" then p1f3 endif
Paul
At 7/23/2007 02:51 PM, you wrote:
You could also use
if p1f1"@" = "10@" then p1f3 endif
Should work the same.
Paul Durban
At 7/23/2007 05:18 AM, you 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
