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
