PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WINDEV 2024 → how to debug this report problem
how to debug this report problem
Débuté par Garry Allen, 12 mai 2017 14:24 - Aucune réponse
Posté le 12 mai 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