Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: How to make this searching form

    Hi guys,
    I want to create a canvas with two blocks.
    The first one is made by 4 text-items where the user can input keywords to search (for example isbn-code, author, title...). The user can request less than 4 searching criteria of course.
    In the second block I'd like to put items with a scrollbar where the result of searching is displayed.
    I tried to make this through a block (the second) based on a stored procedure that takes the items of the first block as input parameters... but it doesn't works (I have used a table type as IN OUT parameter). I think that's my fault, because of my poor experience.
    Can you help me, please?

  2. #2
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    Y can't U replace IN OUT type with IN & try. Post Ur code for better understanding.
    SATHISH .

  3. #3
    Join Date
    Nov 2003
    Posts
    7
    I attach the code.
    As you can see, I use IN OUT mode to assign values to table.
    Any suggestion?
    Thank you in advance
    Attached Files Attached Files

  4. #4
    Join Date
    Mar 2004
    Posts
    5
    My question:
    In Oralce forms 6 I am trying to create a bock based in a procedure. I can insert data and update at b.d only but I can not select data so I can not delete. I have create all procedures like in www.osborne.com Examples from "Avanced Forms and Report" and I have used asistend to create block and Help of Forms 6. I am locking for code source is in trigger "when button pressed" to execute query of block.
    Thanks. Peternac26. Madrid (Spain).

    Hola compañeros del metal,
    En Oracle Forms 6 estoy intentando crear un bloque basado en un procedimiento. Puedo insertar y updatear en b.d pero no puedo ver los datos y por tanto borrar. He creado todos los procedimientos como el ejemplo de www.osborne.com "Examples de forms y reports avanzados" y he utilizado el asistente para crear el bloque y tambien he consultado la ayuda. Necesito el codigo que se podría en el trigger when button pressed para ejecutar y ver los datos en el bloque.
    Gracias. Peternac26. Madrid (España).

    alarcon_jp1@ya.com

    Question:

    I have see your code in code.txt and..
    Can I get query-procedure?
    Ricerca is the process in block property to select ?

    Thanks.

Posting Permissions

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