Re: FORMS 3 help needed

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 Received on Tue Jan 31 1995 - 20:13:15 CET