Re: FORMS 3 help needed

In <3gm24b$lb4_at_infosrv.edvz.univie.ac.at> Michael Hatzinger <Michael.Hatzinger_at_bmwf.gv.at> writes:

>
>cdg_at_ix.netcom.com (Craig Kasold) wrote:
>>
>> In <D33Dyq.77C_at_iglou.com> proberts_at_iglou.iglou.com (Phil Roberts)
>> writes:
>>
>> >
>> >I have a newbie question. Please answer if you can.
>> >
>> >When using SQL*Forms 3 how do I limit what data can be input into a
 field?
>> >I want to allow only three values to be input into the field. Only
 an
 'A',
>> >'B', or 'C' can be input. I haven't figured out how to keep other
 characters
>> >from being input in the field.
>> >
>> >As the input people do data entry they sometimes rush and enter
 other
>> >characters without checking their input. I must eliminate this
 through
 some
>> >means so that they can only enter the 'A', 'B', or 'C'. How is this
 done?
>> >
>> >
>> > Phil Roberts | proberts_at_iglou.com
>> > -------------------------------------------
>> > IgLou - The Internet Gateway of Louisville
>> >
>> >
>> >
>>
>> Phil,
>> There are many ways, the simplest may be on a key-nnxtfld, and
>> key-prvfld trigger. Just put an 'if' statement in these triggers -->
 if
>> :block.fieldname = 'A', 'B', 'C' then next_field (or previous_field)
>> else
>> message('error!!!');
>> synchronize; raise swlforms.form_trigger_failure;
>> end if;
>> I will be glad to help you in any way
>> Craig
>> cdg_at_ix.netcom.com
>>
>
>Hi !
>
>Sorry, but this solution above is the most complicated way to do this
>and not working in all cases. What, if I have autoskip on the field or
>I press some other keys, like <next block>, <commit>, .......
>
>Mike
>
>IKEA Business Services
>

Mike,
  I disagree and will send you mail to explain why. Craig Received on Thu Feb 02 1995 - 14:50:36 CET