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

Thread: can anyone help me please

  1. #1
    Join Date
    Feb 2001
    Posts
    53
    on Form:
    lets say I have 3 display items and 3 text items.
    and I have 2 tables to work with, and their names are:
    black and white.

    when I put in a number in the text_item with a number between 1-99, I want the content from the "black" table to appear on all the display_item box. and if the number is between 100-1000, I would like to content from the "white" table to be displayed.

    and I have another display_item that I would like to display the name of the table, in which the result came from ie.
    black table = between 1-99

    appreciated,

    thanks

  2. #2
    Join Date
    May 2001
    Posts
    70
    A few questions, that might help clear this up.

    1. Are you using data blocks? (i.e. do you have a white and black block)
    2. Can you use non data blocks to use pre-query and post-query triggers on the block to retrieve the data?
    3. Can you use an when-change to fire a query that populates the data?

    Can you give us your layout scenario to help you better.

  3. #3
    Join Date
    Feb 2001
    Posts
    53

    no, i'm not using data block

    here's an example

    if I were to type in a number 7 in the first Text_item area, the display_item on the left would display something like "black car" or "black dog" etc.
    and if I type in 117, it would display "white car" or "white dog"

    its a really simple, its just that I'm having hard time explaining it. thats because I'm not good with this if then else statement stuff.

    hope this help.

    thanks

  4. #4
    Join Date
    May 2001
    Posts
    70
    look for a trigger on the text_item for when-validate-item/when-change-item. I don't have Forms with me so I cannot look it up for you.

    This is where you would use a piece of pl/sql to populate the display_item.

    hope this helps.

  5. #5
    Join Date
    Apr 2001
    Posts
    51

    what u need to do here is write 2 triggers one at the item level i.e. when-validate-item and another at the block level post-query and issues a select statement.

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