Re: Using GO_ITEM when validating a record

In article <7d5rn4$qoi$1_at_nnrp1.dejanews.com>, <u08508_at_my-dejanews.com> wrote:
>I have a single block form with a few fields which are validated using a
>PRE-UPDATE trigger. If any of the validation fails , I want to place the
>cursor in that field and display the error message.
>
>I cannot use the GO_ITEM in any Pre- or Post- navigational trigger.
>
>Does anybody know of any way that I can validate at record level and then
>place the cursor in the incorrect field.

Neville Sweet's timer method is the one I use, too. But I would caution you about doing validation in a pre-update trigger. It seems to me that it might be better to do it in the more obvious trigger, the When-Validate-Record trigger. Here too, the go_item does not work, but we use a standard procedure that starts a timer and stores the field name in a form parameter. When the timer expires, it moves the cursor to the correct field.

Steve Cosner Received on Tue Mar 23 1999 - 18:51:05 CET