<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>12 May 2017 14:24:00 Z</lastBuildDate><pubDate>12 May 2017 14:24:00 Z</pubDate><description>I'm developing in WinDev20 and I get the following error:&#13;
&#13;
What happened?&#13;
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.&#13;
&#13;
Error code: 70202&#13;
Level: fatal error (EL_FATAL)&#13;
WD55 error code: 202&#13;
&#13;
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.&#13;
&#13;
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:&#13;
TOUR_DATE is greater than or equal to 'pdStart'&#13;
TOUR_DATE is less than or equal to 'pdEnd'&#13;
(I originally used a 'between' statement but I thought maybe it was the problem)&#13;
The code for printing the report is:&#13;
iInitReportQuery(RPT_Restaurant, gstRptParam.dStart,gstRptParam.dEnd)&#13;
iPreview(i100)&#13;
iPrintReport(RPT_Restaurant)&#13;
Am I missing something?&#13;
Thanks&#13;
Garry</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60848-how-debug-this-report-problem/read.awp</link><title>how to debug this report problem</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster></channel></rss>
