Re: COPY and NAME_IN error Forms 4.5

Well, don't I feel like an absolute fool. I even put that in a comment in my code! Well, now that I know my idiocy level is perfectly normal, I feel better. Thanks, Neville. You saved what's left of my sanity.

In article <01bdf274$0f3e2120$483c1286_at_itwol-pc3963.itwol.bhp.com.au>,   "Neville Sweet" <sweet.neville.nj_at_bhp.com.au.no_junk_email> wrote:
> Hi,
>
> The Copy statement syntax is COPY(source, destination), as opposed to
> assignment, which is destination := source.
> Reverse your Copy parameters and it should work.
>
> slniemann_at_my-dejanews.com wrote in article
> <6vgi0m$l0q$1_at_nnrp1.dejanews.com>...
> > I keep getting a form runtime error stating that my COPY() function's
> second
> > value cannot be NULL
> >
> > the PL/SQL is generic, passing in a block name, and attaching the passed
> in
> > block name to an item name variable (ie var1 VARCHAR2(50) := blk ||
> '.item2';)
> > there are numerous variables, one for each item in the block. I need to
> swap
> > label values between two items. The traditional 3-way switch is used:
> > PROCEDURE CHANGE(blk IN VARCHAR2) IS
> > var1 VARCHAR2(50) := blk || '.item2';
> > temp_var VARCHAR2(50);
> >
> > BEGIN
> > /*
> > temp_var := item1;
> > item1 := item2;
> > item2 := temp_var;
> > */
> > Copy(temp_var, NAME_IN(var1)); -- <-- this is where the NULL error is
> set
> > Copy(NAME_IN(var1), NAME_IN(var2)); Copy(NAME_IN(var2), temp_var);
> > END;
> >
> > To make this generic, I am using Copy(temp_var, NAME_IN(var1))
> > Unfortunately, the var1 keeps coming up null, but in debugger, I check
> the
> > value within, and there is a value in [the item inside].
> >
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 08 1998 - 14:53:32 CEST