Re: Problem with CASE statement

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" <ralvy-jRiKDUx9DOfk1uMJSBkQmQ@xxxxxxxxxxxxxxxx>
To: "DataPerfect Users Discussion Group" 
<dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx>
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
> Dataperf-Ii8YPGKeNuMyuW1uK6fEew@xxxxxxxxxxxxxxxx
> http://lists.dataperfect.nl/mailman/listinfo/dataperf
>