Re: Forms v3.0 Help
Date: Fri, 18 Mar 1994 15:28:49 GMT
Message-ID: <CMv9o2.6nJ_at_stortek.com>
Albert L Evans (ae0i+_at_andrew.cmu.edu) wrote:
> This has got to be incredibly simple but I just cannot seem to get it to work.
> I want to copy a value which has been entered on one page in a database field
> but not yet committed to a field on the next page which is display only.
> I cannot, however, find a way to do this for some reason. Currently I'm
> trying to use the COPY procedure and the PRE-FIELD trigger on the first field
> to allow input on the second page. This is the syntax I'm trying"
> Forms accepts this, but nothing is copied. Any bright ideas for this idiot?
> Bert
Although your specific problem may not have anything to do with the copy procedure, why not just use the following statement:
:field_2 := :field_1;
This is the method of choice when you can use it. One of the tricks to using oracle's packaged procedures is knowing the format of parameters a function requires. For example,
erase(:global.some_var); /* you will get a syntax error */ erase(':global.some_var'); /* Compiles fine, but doesn't work */ erase('global.some_var'); /* works fine */
This may not be exact, but the point is, be very careful with the parameters you use. The copy() function should only be used when you are dynamically calling fields, for example:
copy('JACK','emp.first_name_'||to_char(count));
otherwise it is better to use something like
:empl.first_name_2 := 'JACK';
if you know exactly which field you are referring to, so you don't run into the above problem.
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Sean_Stasica_at_stortek.com
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -