Home Server

WebTier : In list range error

edited February 2012 in Server
When running a report using search parameters "employeeid IN
", when opening the report it crashes with
"range check error".

It's a simple report with 2 data pipelines, one is the employees table used
to fill the lookup list, the other the jobs table to view the job of the
selected employee...

It works fine running it from a delphi environement, only not when running
it from the web browser...?

Anybody has tried this before and ran into the same kind of problem?

Thanks,
Chantal Marchand
People Inc.

Comments

  • edited February 2012
    We are using RB 12.5

    The error appears when the WebTier code hits the
    "rsWebTier.GetAutoSearchParameters(Req);"


  • edited February 2012
    Just did a test, I get the same problem using a simple employeeid =
    ...
    So it's not related to the IN option but to the parameter itself...the
    webserver doesn't appear to be able to fill the combo box with the parameter
    values.


  • edited February 2012

    Try using the DBDemos data included with Delphi to define a simple .rtm file
    that demonstrates the error. Send in zip format to support@ and I can test
    it here in the debugger.


    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2012
    Hi,

    I've just sent an example to support.

    We've also put the call to RequiresAutoSearchParameter in a try except in
    our webtier, and the search screen gets displayed...
    (we call this to stop a user without rights to execute reports with search
    parameters to open them.)

    But we have no way to find out without the code why the procedure crashes.
    Reports are saved to the database with the standard rb save functions.

    Regards,
    Chantal Marchand


This discussion has been closed.