DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2000

    Red face

    I am working on forms 6i Oracle 8i,
    under WIN-NT 4.0 Workstation.

    Please let me know immediately.

    My propblem is:

    I am not displaying more than one record
    in multirecord block from a database table.by writing a select statement in form.


    In form, I have a multirecord block
    (block name is DEPT and also basetable
    name is DEPT). I want to fetch the records
    from DEPTNEW table into that multirecord block.

    If only one record in DEPTNEW table, then it is worked properly.
    But the problem is, if in DEPTNEW table has more than one record
    then the records are not displayed in that DEPT block on forms.

    (NOTE: DEPT and DEPTNEW both tables have same structure)

    Please give me the solution as soon as possible,

    thanks a lot for ur cooperation.

    my email id is sri_garige@hotmail.com

    thank u.
    sridhar garige

  2. #2
    Join Date
    Feb 2001

    I unable to get your proble

    Are your fetching the data from DEPTNEW through
    procedure, and then save it to DEPT table through
    DEPT block.
    Pl give some more detail

    P. Soni

  3. #3
    Join Date
    Feb 2001
    what i feel from your question is that you want to display records in dept table from deptnew table.If thats true then you have to write a cursor which selects the data from the dept table. Assign the cursor columns to the dept table columns.You will be able to view the records in the dept block.
    When the going gets tough, the tough gets going

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.