Name-InCopy (Difference)

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fprq2\fcharset2 Wingdings;}{\f2\fnil\fcharset0 Calibri;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\li1080\lang1033\f0\fs22 You can reference items indirectly with the NAME_IN and COPY built-in subprograms. \par
The NAME_IN function returns the contents of an indicated variable or item. Use the NAME_IN function to get the value of an item without referring to the item directly. The return value is always a character string. To use NAME_IN for a DATE or NUMBER item, convert the string to the desired data type with the appropriate conversion function The NAME_IN function cannot return the contents of a global or local variable. PL/SQL triggers that will be executed in enter-query mode, you must use NAME_IN rather than normal bind-variable notation to access values in the data-block. (This is because the end-user might type relational operators into the item, producing a value, which is not in a form that can be processed by PL/SQL.) If you nest the NAME_IN function, Form Builder evaluates the individual NAME_IN functions from the innermost one to the outermost one.\par
Copy copies a value from one item or variable into another item or global variable. Use specifically to write a value into an item that is referenced through the NAME_IN built-in. COPY exists for two reasons:\par
\pard\fi-360\li1800\tx1800\f1\'d8\tab\f0 You cannot use standard PL/SQL syntax to set a referenced item equal to a value.\par
\pard\fi-360\li1800\f1\'d8\tab\f0 You might intend to programmatically place characters such as relational operators in NUMBER and DATE fields while a form is in Enter Query mode.\par
\pard\li1080 The COPY procedure assigns an indicated value to an indicated variable or item. Unlike standard PL/SQL assignment, however, using the COPY procedure allows you to indirectly reference the item whose value is being set.\par
COPY can be used with the NAME_IN function to assign a value to an item whose name is stored in a reference variable or item.\par
No validation is performed on a value copied to a text item. However, for all other types of items, standard validation checks are performed on the copied value.\par
COPY (source VARCHAR2, destination VARCHAR2);\par
NAME_IN (variable_name VARCHAR2);\par
\pard\sa200\sl276\slmult1\lang9\f2\par
}