1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Forms Help

Discussion in 'General' started by mohsin_zee, Oct 23, 2008.

  1. mohsin_zee

    mohsin_zee Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    hi every one
    on oracle form i want to display reacord Partially when first time i click button it should display 100 record next time it display next 100 recored can i do it by cursor or any orther way
     
  2. mohsin_zee

    mohsin_zee Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Re: Hi All

    hello how can i oepn any web page by clicking button on oracle form
     
  3. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Re: Hi All

    Hi Mohsin, I am not really sure what you are looking for, if you are looking for any record press F11 to query and ctrl+F11 to see the results.

    And if you want to see any fixed number of records goto View->Record from the Top Menu
     
  4. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Re: Hi All

    I assume you are talking about Oracle Applications.

    Goto View-->Attachment
    1. Enter Category and Title in the Main Tab
    2. Enter Data Type as Web page in the Source Tab and enter the URL
    3. SAve
    Now An Open Document tab will appear in the attachments window. When you click on that, the web URL will open.

    Hope this helped
     
  5. mohsin_zee

    mohsin_zee Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    actually on application i want to display required number of record spouse i have form with multiple search like by name by any contact number and sales order number my problem is suppose i enter 9215 it display thousand of record in none database block when i double click it display whole information of that recored how many invoices and quotation and sales order under this contact number put on initial stage i want to display only hundred record on search form then next 100 how can i do it plz help me
     
  6. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Hi mohsin, i am sorry but you are not at all clear

    Are you talking about Oracle Applications? if yes 11i or R12?

    Which Module are you talking about? Order management by any chance?

    Which form in that module?

    From the little bit that I can understand from your post, you are using the find function (the torch button) of Sales Order Form right? and you don't want to see so many results but 100 at a time. If I have understood right, then if you are using the find function it will return all the records that match your query. If you want fewer results modify your search criteria.
     
  7. mohsin_zee

    mohsin_zee Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    yes my friend u are Absolutely right i am talking about display record
    in block i am talking about 10g form;
    i give u example suppose i have 30 record but one time form display only 10
    as

    block at one time hove only 10 record u under stand or not


    1-------------
    2-------------
    3-------------
    4-------------
    5-------------
    6-------------
    7--------------
    8-------------
    9-------------
    10-------------

    then again on click next 10 record

    10--------------
    11-------------
    12-------------
    13-------------
    14-------------
    16-------------
    17-------------
    18-------------
    19-------------
    20-------------

    then again on click next 10 record

    21--------------
    22-------------
    23-------------
    24-------------
    25-------------
    26-------------
    27-------------
    28-------------
    29-------------
    30-------------

    block at one time hove only 10 record u under stand or not How ?
     
  8. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    yes i understood, but my answer is same, modify your search, you cannot prevent records from appearing if they match your query