This discussion is archived
2 Replies Latest reply: Nov 27, 2013 1:38 PM by StelBart RSS

Put sequence into form region source

StelBart Newbie
Currently Being Moderated

Hi

I just started with Apex. I have problem with simple form. I don't know how put currval from sequences into region source in my form.

I found that I can' do that(put sequences after "WHERE"), so please give me some advice about another way.

 

Sample:

 

SELECT

   "TableName"."ColumnName" "ColumnName",

    "TableName"."Number" "Number",

FROM

   "TableName"

 

WHERE

"SEQUENCE".CURRVAL ="Number"

 

 

I try put it in  region source. It somethink like filter on "Number" column, but not exactly.

 

I Message I get:           ORA-02287: sequence number not allowed here

  • 1. Re: Put sequence into form region source
    TexasApexDeveloper Guru
    Currently Being Moderated

    What exactly are you trying to accomplish??  you can have an item get this as its default value..

     

    If you have an item called jumbo

     

    After defining the item and going in a few page clicks, you are presented with these options:

     

    Number Field
     
    *  

    Change the source type to Sql Select return single value

     

    For Item Source Value use this

    SELECT <Sequence_Name>.nextval from dual;

     

    This will pull the next value from the defined sequence..

     

    Hope that helps..

     

    Thank you,

     

    Tony Miller

    LuvMuffin Software

    Blog: https://apex1.revion.com/pls/apex/f?p=217:1::::::P1_ARTICLE:

  • 2. Re: Put sequence into form region source
    StelBart Newbie
    Currently Being Moderated

    Problem is simplier I suppose

    I'll try to explain:

     

    I have 2 tables:

       first one with 2 colums:

                             number (PK)

                             name

      second with few colums, one of them have same values as PK from first ( used trigger, sequences etc)

     

     

    When I insert data in first table, then I wanna "jump" to second and insert there. But the problem is that after this "jump" it shows me all data included in table2-> I wanna see only these one where PK is my current value (not every latest). Now I'm thinking using  <Sequence_Name>.currval isn't the best soluution, but also I dont wanna change my form-page. It cost me lots of work.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points