ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Problem with interactive program and debbug

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Problem with interactive program and debbug


    Hello,

    I have an interactive program that is not working properly.
    In my program, I fill in a temporary file (via SQL) and then I process the file.

    Here is the SQL :
    EXEC SQL insert into wfictmp1
    (wservic, wimmeub, wnumcop, wdattrt)
    select servic, immeub, numcop, max (datcrt)
    from desco1h where servic =: wctservic
    and immeub =: wctimmeub
    and datcrt between :wctdatedeb and :wctdatefin
    and status = 'B'
    group by servic, immeub, numcop
    order by servic, immeub, numcop
    with NC;


    My problem is this when I run the programme for the first time, I enter values ​​for which I know I have data.
    My subfile is displayed correctly.
    The second time (without leaving the program), I modify only the "wctimmeub" variable.
    I know I have no data.
    The program displays the "No data" window.
    I still modify the variable "wctimmeub" to put back the first value.
    And there the SQL generates an error 180 "THE DATE TIME OR TIMESTAMP VALUE IS INVALID"
    But I did not change the other variables values.

    When I debug the program and replay my scenario, I have no problem.
    I no longer have the SQL error.
    The subfile is displayed correctly.

    The program does not behave in the same way between "normal" mode and "debbug" mode.

    I am using RDI for debugging.

    Anyone have any idea to correct this problem?

    Regards

  • #2
    Hello,

    I found the error.

    Regards

    Comment

    Working...
    X