#57 Error processing TabForm when row selector column is not dis

v1.7
closed-fixed
nobody
3
2008-06-08
2007-03-22
SiDi
No

If form has row selector column set to "NOT show" process "ApexLib-Before Computation/Validation" finishes with error:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06502: PL/SQL: numeric or value error: NULL index table key value.

Workaround: Set "Conditional Display" for row selector to "Never".

Discussion

  • SiDi

    SiDi - 2007-03-22

    Logged In: YES
    user_id=1750297
    Originator: YES

    In fact without row selector column it doesn't count rows in Tabular Form.

     
  • SiDi

    SiDi - 2007-03-22
    • priority: 5 --> 3
     
  • Patrick Wolf

    Patrick Wolf - 2007-03-22

    Logged In: YES
    user_id=1449836
    Originator: NO

    Thanks for letting me know!

    I can reproduce the problem with the row-selector if you set it to "NOT show". In that case APEX doesn't render the column (also not as hidden field). I have to fix that.

    But the question is, does it make sense to define a row-selector and they define it as not displayed?

    >In fact without row selector column it doesn't count rows in Tabular Form.

    I was not able to reproduce that. Works fine for me if I remove the row-selector column. If you run the page in debug mode and you submit it and an error is raised, eg from Oracle. Do you see in the debug output which column is used for the counting by the ApexLib Framework?

     
  • Patrick Wolf

    Patrick Wolf - 2007-03-22
    • milestone: 696998 -->
     
  • Patrick Wolf

    Patrick Wolf - 2007-03-22

    Logged In: YES
    user_id=1449836
    Originator: NO

    Note to myself :-)

    If the "NOT show" is defined for text field,... , APEX converts that to a hidden field when it renders the field.
    That's why I shouldn't generate the browser validation code for such a field.

     
  • Patrick Wolf

    Patrick Wolf - 2008-06-08
    • milestone: --> v1.7
    • status: open --> closed-fixed
     
  • Patrick Wolf

    Patrick Wolf - 2008-06-08

    Logged In: YES
    user_id=1449836
    Originator: NO

    Fixed

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks