how to debug this report problem

Startbeitrag von Garry Allen am 12.05.2017 12: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

Antworten:

Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.