Tim,
Thank you for the reply. The formula is assigned to the field P3F3, and it
is set to update to Any Change.
I tried these formulas on some test panels set up especially because of
the problem I indicated in my original post. The problem described
consistently occurs regardless of the panel in which is located.
Are you writing that I should be using two fields? One to contain the
first letter, and the second to contain the formula and post the resulting
text matching the letter?
Victor Warner
On Wed, 16 Aug 2006 16:02:09 +0100, Tim Rude <[EMAIL PROTECTED]> wrote:
Victor,
Is one of these formulas assigned to field P3F3 itself? If so, what may
be
happening is that the formula gets processed multiple times because each
time it changes the value of P3F3 that triggers it to apply the formula
again.
Also, when is the field set to update: Create, Save, or Any Change?
Tim Rude
----- Original Message -----
From: "Victor Warner" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, August 16, 2006 9:03 AM
Subject: [Dataperf] Problem with CASE statement
I am having problems with the CASE statement. In the following:
P3F3 CASES
CASE CV ="A" OF "Apostille" ENDOF
CASE CV ="C" OF "Certificate of Good Standing" ENDOF
CASE CV ="D" OF "Print off documents at Companies House" ENDOF
CASE CV ="L" OF "Legalisation service provided by agent" ENDOF
CASE CV ="O" OF "Basic internet available info from Companies House"
ENDOF
CASE CV ="R" OF "Recorded Mail" ENDOF
CASE CV ="X" OF "Other legalisation" ENDOF
DEFAULT ""
ENDCASES
when I enter "L" or "C", the corersponding text shows in the field, but
if
I tab to the next field or save, the corresponding text disappears.
also in the following CASE statement:
P3F3 CASES
CASE CV ="S" OF "Statute" ENDOF
CASE CV ="I" OF "Statutory Instrument" ENDOF
DEFAULT ""
ENDCASES
entering "I" produces the text for "S".
Help with this would be very gratefully received.
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
