Re: getting error in forms: 'bad bind variable..'

see code modification below

Nicky Taylor <nicky.taylor_at_gecm.com> wrote in message news:3896f34c$1_at_pull.gecm.com...
>
> wozi_at_dhc.net wrote in message ...
> >I have a single block placed on a canvass and displayed through a window.
> >The block is a mult-record block based on scott.emp.
> >
> >I created a menu and assigned it to the form module.
> >In the code attached to one of the menu item, I have something like this:
> >
> >message(:emp.ename);
> >
> >I get the bad bind variable error. It appears that the item I am
> >referencing is not available.
> >
> >The block name is emp
> >the item is ename.
> >
>
>
> You do not need the colon.
>
> Instead of :-
> message(:emp.ename);
>
> Try :-
> message('emp.ename');

• if this works at all, it should probably be message( name_in( 'emp.ename' ) );
  • but I do think Nicky's other suggestion of putting a program unit in a PL/SQL library and referencing it from
  • both form and menu is the best option.
    >
    > HTH
    > Nicky Taylor
    >
    >