FireDac MemTable Filtering Error on XE7

Question

I am get an error that "Expression unexpectedly terminated" when i want to doing on the FireDac MemTable. I am use that codes

with FMemtable1 Do
 begin 
  Filtered :=False;
  Filter   := 'Field1 like ' + ''''+'%'+Edit1.Text+'%'+'''';
  Filtered :=true; 
 end

But im not get this error when i was try on the XE6

try to replace the filter statement bij the following: 'Filter := 'Field1 like ' + QuotedStr(Edit1.Text); — Copilot, Apr 03 '15 at 06:15
Then I think we need some more information. How is your FDMemtable configured? Is there a 'Field1' defined by name in the dataset? — Copilot, Apr 03 '15 at 09:24
@copilrot you are right .Field1 is a st Ftstrings field.I create just one field I actived FDMemtable after de created that field — Hüseyin Okumuş, Apr 04 '15 at 09:30
Add `ShowMessage(Filter);` and see what you get. Then switch to using QuotedStr() instead of playing around with all the quad quotes. — Ken White, Aug 16 '16 at 18:12

score -1 · Answer 1 · edited Aug 17 '16 at 08:51

-1

this Code not ABC filtering

Filter   := 'Field1 like ' + ''''+'%'+Edit1.Text+'%'+''''; // filter Any Letter

Filter := 'Field1 like ' + QuotedStr(Edit1.Text‌);// filter Exactly Word

edited Aug 17 '16 at 08:51

Roman Marusyk

23,328
24
73
116

answered Aug 16 '16 at 16:21

BENRABIA

1

2

Are you able to expand you answer somewhat to explain how your example applies to the question? – Matthew Brown aka Lord Matt Aug 16 '16 at 16:36

FireDac MemTable Filtering Error on XE7

1 Answers1