Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unhappy Unanswered: Oracle Form, String(text), display

    Hello everyone,

    I have the following table with 2 fields, one is check box, one is batchno.
    the user wants to see what they selected. But I do not know what to do....



    CK_VALUE BATCHNO
    X A12345
    A56789
    X B77553
    X C6699


    User wants to see

    ---------------------------------------------------------------
    | A12345, B77553, C6699 |
    ---------------------------------------------------------------

    displayed back on the form, doesn't matter using what format
    Display box is ok, text item is fine, as long as the user can see what they selecte in that one box.

    How could I possible be doing this..

    Please help


    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    You want to display all selected items before commit time, so the user can decides whether it is right or not.

    First of all, you will have to figure out at what time you want it to show, so you can define the correct trigger. The use of a message box can be fine, but has a limit of 255 karakter.

    You could also use an extra text field in the form, and using the when validate record trigger to write the batchno if selected to the extra text field.
    Like this:

    if :blockname.ck_value='Y' --(or whatever the value may be)
    then
    :blockname.extra_text_field := :blockname.extra_text_field||:blockname.batchno.
    end if;

    So every time a user selects an bactchno (ck_value becomes Y) then the line in the extra_text_field is added with the batchno.
    Then the line gets longer and longer en the can look at it at any time.

    The third way is to loop over the fields at a certain time, but that is a little harder to do.

    Good luck.

    Edwin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •