Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    14

    Unanswered: plz help for select in forms 6i

    I want to know how to write select with where clause in forms 6i

    I have write following code for populating the list



    status := populate_group_with_query(rg_name,'select enamr,to_char(empno) from emp where ename like '|| :search_pattern ' ||%');


    But the Sql statment doesn't work.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    From the #1 Sticky Post which you obviously did NOT read.

    When you post:
    * Give your post a meaningful title, so that people have some idea what it will be about. Titles like "Please help!" and "Newbie query" aren't very useful.
    * Posts should contain OS name & version
    * Posts should contain Oracle software version number to 4 decimal places
    * Posts should contain cut & paste copies of actual inputs & output messages
    * Use vb Code tags to make your post more readable. The most important of these is the code tag, which makes both code and examples clearer by using a proportional font and maintaining spacing - e.g. instead of this:
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    When the select statement if fired (for example with XXX as Search_pattern, it will look like

    select enamr,to_char(empno) from emp where ename like XXX%

    which is plainly wrong. Use


    status := populate_group_with_query(rg_name,'select enamr,to_char(empno) from emp where ename like '''|| :search_pattern' ||'''%');
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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