Results 1 to 2 of 2

Thread: Table Load

  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unhappy Unanswered: Table Load

    Hi guys,

    Like the name says I am ridiculously new at this. This is probably the dumbest question you'll ever get asked, but here goes.

    I have a form which I've created, which contains 3 columns, like so:

    Code Name Origin
    **** **** ****
    **** **** ****
    **** **** ****
    **** **** ****
    **** **** ****

    If i select query and execute a blank query, it works fine and displays all relevant info, but when the table first loads it is blank. I want all available data to show when i first load the table. How do i do this?

    Thanks for your patience!!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Table Load

    Originally posted by newbie84
    Hi guys,

    Like the name says I am ridiculously new at this. This is probably the dumbest question you'll ever get asked, but here goes.

    I have a form which I've created, which contains 3 columns, like so:

    Code Name Origin
    **** **** ****
    **** **** ****
    **** **** ****
    **** **** ****
    **** **** ****

    If i select query and execute a blank query, it works fine and displays all relevant info, but when the table first loads it is blank. I want all available data to show when i first load the table. How do i do this?

    Thanks for your patience!!
    If this is Oracle Forms, you want a WHEN-NEW-FORM-INSTANCE trigger that contains this code:

    GO_BLOCK('MYBLOCK');
    EXECUTE_QUERY;

Posting Permissions

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