DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: please let me know immdeiately

  1. #1
    Join Date
    Dec 2000
    Posts
    23

    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.

    Example:,,

    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
    Posts
    125
    Hi,

    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


    Thanks
    P. Soni

  3. #3
    Join Date
    Feb 2001
    Posts
    103
    hi,
    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