Ralph and Tim,
Thank you both for your help. Creating two fields, each with the formulas
as suggested in Ralph's post cured the problem. I am very grateful.
I had thought of creating a separate panel and use a data link, but the
advantage of using a CASE formula is that only one keystroke is needed (ie
"C" or "G"), rather than using a data link where three are needed
(up-arrow, "C" etc, then enter key).
Victor Warner
On Wed, 16 Aug 2006 19:18:10 +0100, Ralph Alvy <[EMAIL PROTECTED]> wrote:
Yeah, that's what I figured (needed 2 fields like the other problem),
but he
said that the field didn't blank when entering text (which was happening
with
the other problem). Given that, I thought he could try just switching the
order. If that fails, then 2 fields are needed, I guess.
Another possibility around all this is to refrain from using formulas at
all,
and just use a Data Link to a panel that holds all the possible values
for
this field. This would make it easier to add other possible values later.
On Wed August 16 2006 09:15, Tim Rude wrote:
I think the same problem exists here. When the user enters "I" it gets
changed to "Statutory Instrument" which then triggers the formula to
update
the field again, and since the first letter is now "S" it changes again
to
"Statute".
Will switching the order of the statements change this?
I think two fields will be needed here also. Or you could change to
something like this:
P3F3 CASES
CASE CV ="S" OF "S - Statute" ENDOF
CASE CV ="I" OF "I - Statutory Instrument" ENDOF
DEFAULT ""
ENDCASES
Assuming that it doesn't cause a problem to have the indicator letter
within the field.
Tim Rude
----- Original Message -----
From: "Ralph Alvy" <[EMAIL PROTECTED]>
To: "DataPerfect Users Discussion Group" <[email protected]>
Sent: Wednesday, August 16, 2006 11:00 AM
Subject: Re: [Dataperf] Problem with CASE statement
> On Wednesday 16 August 2006 07:03, Victor Warner wrote:
> > 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.
>
> Try switching the order of the statements to this:
>
> P3F3 CASES
> CASE CV ="I" OF "Statutory Instrument" ENDOF
> CASE CV ="S" OF "Statute" ENDOF
> DEFAULT ""
> ENDCASES
> _______________________________________________
> 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
