Re: Forms 4.5 Assistance Please!

In article <5nrrfl$dqu_at_drn.zippo.com>,   Jody Lewis <lewisj2_at_wdni.com> wrote:
> I am running into a problem with restricted built-in procedures.
>
> Here is what I need to do:
>
> I have a non-base item text field that is going to have data entered
> through a scanner. The behavior this scanning gun simulates is
> typing value into item and pressing enter.
>
> The "enter" coming from the scanner gun needs to insert the
> appropriate record into a table behind the scenes using the
> information scanned in (this needs to include commit) Then
> requerying two blocks of the four blocks visible on screen (all
> located on the same canvas) needs to take place. These blocks are
> base-table blocks tied to queries for purposes of displaying and
> selecting data only.

All you need is a hidden item in your block following the item where the scanner enters the data. In the hidden item's when-new-item-instance, you can do anything you want, since WNII triggers are not restricted. With all the work that needs to be done, I would put it all into one or more procedures, and call these from the WNII trigger.

HTH,
Steve Cosner

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet