Re: putting data into a text item

John,

   To assign a variable to a text item:

       :block_name.item_name := variable_name;    To assign a column from a %ROWTYPE cursor variable:

       :block_name.item_name := cursor_name.column_name;    To assign a text item to a variable, reverse the equation. This last would usually be done in either a POST-TEXT-ITEM trigger, or in PRE-INSERT and/or PRE-UPDATE triggers. In all cases I've assumed the datatypes are the same, if not you will need to do any necessary converisions.
Regards,
Paul

In article <iGgq4.3605$tw.73484_at_nnrp1.ptd.net>,   "John Love" <spam_at_tolltex.com> wrote:
> Hi,
>
> I have a pl/sql statement which opens a cursor and fetches the
 results into
> a declares pl/sql variable.
> how do i pass the value stored in the variable into the text item so
 that
> the user can see it ?
> how would I programatically retrieve data from a text item and load
 it into
> a pl/sql variable ?.
>
> Thanks
> John
>
> P.S. I am using Oracle Forms 2000
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 16 2000 - 00:00:00 CET