|
FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile |
| | | | | |
| how to debug this report problem |
| Iniciado por guest, 12,may. 2017 14:24 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 12,mayo 2017 - 14:24 |
I'm developing in WinDev20 and I get the following error:
What happened?
pdEnd is not an item or a parameter of QRY_RestPeople query. New parameters must not be declared after query preparation. Check whether no syntax error occurred in the item or parameter name.
Error code: 70202
Level: fatal error (EL_FATAL)
WD55 error code: 202
This happens during the generation of a report based on a query that selects records based on a date range of pdStart to pdEnd (the query test works as expected). Originally the report printed fine but it ignored pdEnd so I put in some code that printed pdEnd on the report and got the error.
What I don't understand is that when I show the parameters of the query both pdStart and pdEnd show up and if I edit the conditions of the report it shows the following:
TOUR_DATE is greater than or equal to 'pdStart'
TOUR_DATE is less than or equal to 'pdEnd'
(I originally used a 'between' statement but I thought maybe it was the problem)
The code for printing the report is:
iInitReportQuery(RPT_Restaurant, gstRptParam.dStart,gstRptParam.dEnd)
iPreview(i100)
iPrintReport(RPT_Restaurant)
Am I missing something?
Thanks
Garry |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|