filter do not work

WEB TMS WEB Core
1

This is my filter code where WDS_InkaResult.is a TXDataWebDataSet.

PROCEDURE TInkaUserMainForm.KR_Order_IBollVinstUT;
VAR
s1, s2: STRING;
BEGIN
s1 := '?$filter=SpelDatum eq ' +
QuotedStr(DateToStr(WebDateTimePicker_LogIN.Date));
s1 := s1 + ' and Bana eq ' + QuotedStr(WebDBComboBox_Bana.Text);
s1 := s1 + ' and Boll eq ' + QuotedStr(IntToStr(pIDBoll)); // has value 1
s2 := s1 + '&$orderby=IBollVinstUT DESC';
WDS_InkaResult.QueryString := s2;
whatsNext := C_KR_IBollVinstUT; // this is to come to next in WDS_InkaResult
WDS_InkaResult.Close; // this leads to ..Load and futher on to a rutin where I
// look at WDS_InkaResult.
END;

This is from the Database
image

I was counting on that WDS_InkaResult should have 3 records and that the record with indianID =1 Should be the first
But I get all 7 and indianID=1 is not the first
Fhat am I doing wrong

3

Duplicated: QueryString problem - #2 by wlandgraf

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.