FDTable filter problem

[limelect 48]

I have done filtering in other databases with no problem.

This time I am using FDTable, My tries

ProjectsFDTable.Filtered:=false;

ProjectsFDTable.Filter:='Category =' +QuotedStr('Tools');

OR

ProjectsFDTable.Filter:='Category = Tools';

ProjectsFDTable.Filtered:=True;

Category is the column Tools is the data

The errors are mainly - Tools cannot be found as the Column <<<< how come?

With the QUERY component I have no problem but for my reasons

I want to do it with FDTable.

Any idea

PS. I tried with ProjectsFDTable.SQL nothing worked.

[Lajos Juhász 293]

Which Delphi version. I've never used TFDTable but tested successfully in D11 the code:

 

ProjectsFDTable.Filter:='Category =' +QuotedStr('Tools');
ProjectsFDTable.Filtered:=true;

It's working.

[limelect 48]

@Lajos Juhász D10.2.3 Read and see I did try it !!!

 

My tries

ProjectsFDTable.Filtered:=false;

ProjectsFDTable.Filter:='Category =' +QuotedStr('Tools');

OR

ProjectsFDTable.Filter:='Category = Tools';

ProjectsFDTable.Filtered:=True;

[Lajos Juhász 293]

5 minutes ago, limelect said:

D10.2.3 Read and see I did try it !!!

I read that, unfortunately I have no access to your working environment I can only confirm what's working at my side.

 

I do not have D10.2.3 to test, tried with XE5 it's also working without a problem there.

[limelect 48]

Thank The project is on 10.

P.S using your suggestion I get

Error 104 mismatch exspresion

Edited November 2, 2021 by limelect

[Lajos Juhász 293]

10 minutes ago, limelect said:

Error 104 mismatch exspresion

If you've the source of FireDAC you can debug FireDAC.Stan.Expr there are 4 cases when this exception is raised.

[limelect 48]

Sure I am legitimate. Nice idea

OOOpes i do not have FireDAC.Comp.DataSet.pas

Edited November 2, 2021 by limelect

[limelect 48]

How come you have the source???? and I do not

[Stano 143]

Professional Delphi does not have FireDAC resources !!!

[limelect 48]

OK and thanks . Guies am i stack?. which mean redesign with SQL I guess.

 

[limelect 48]

FINALY I got it

 

 ProjectsFDTable.Filter := 'Category  LIKE ' +QuotedStr('Tools');

Thanks everybody

 

[Guest]

Just curious (do not use FireDac), if you have a Query component, why do you need to use a "table" component?

[limelect 48]

Read my comments above. It answers your question.

It is in my question

 

With the QUERY component I have no problem but for my reasons

I want to do it with FDTable.

 

Edited November 3, 2021 by limelect