Richard,

<< The dataset, is SQL as follows: >>

That's not correct.  You can't use quotes around parameter names (they also shouldn't contain spaces):

SELECT * FROM PWReadings
WHERE CAST("_created" AS DATE)=DATE {SearchDate}

(Notice the space after the DATE keyword)

<< and I pass in a parameter, within EWB such as: >>

That's also wrong.  DateToStr is going to, by default, give you a date that is formatted for EWB client applications in the form of 'M/d/yyyy'.  That is no good for a date literal for EDB, which expects an ANSI date format of 'yyyy-M-d'.

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<< and I pass in a parameter, within EWB such as: >>

<< That's also wrong.  DateToStr is going to, by default, give you a date that is formatted for EWB client applications in the form of 'M/d/yyyy'.  That is no good for a date literal for EDB, which expects an ANSI date format of 'yyyy-M-d'.>>

OK, I've now got the following error:
"Expected Date Constant but instead found 2017" after adjusting the EWB code to:

iYear  := YearOf(SearchDate,True);
iMonth := MonthOf(SearchDate,True);
iDay   := DayOf(SearchDate,True);

sSearchDate := IntToStr(iYear) + '-' + IntToStr(iMonth) + '-' + IntToStr(iDay);

DS.Params.Add('SearchDate=' + sSearchDate);

Any further pointers?

Thanks

Richard

Richard,

<< OK, I've now got the following error:
"Expected Date Constant but instead found 2017" after adjusting the EWB code to: >>

Date constants in SQL need to be surrounded with single quotes:

DS.Params.Add('SearchDate=' + QuotedStr(sSearchDate));

Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

<< Date constants in SQL need to be surrounded with single quotes:

DS.Params.Add('SearchDate=' + QuotedStr(sSearchDate)); >>

Thanks Tim. That's sorted it

Richard