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
Comment