escape character for underscore (_)

[fgoutemant]

I need to know if it is possible to use a escape character for underscore to use it in ClientDataSet.Filter
Thanks

[AndreyZ]

Hello,

The TClientDataSet.Filter property doesn't use the '_' symbol for filtering data, it is recognized as a usual symbol. That's why you don't need to use any escape character for the '_' symbol if you want to use in TClientDataSet.Filter . For more information, please read the "Limiting what records appear" article of the Delphi documentation.

[fgoutemant]

Ok. Thanks a lot.
So i have still trouble with the dataset filter.
I have these datas in my dataset :
1_
1_try1
1_try2
when i try to do a filter with the sentence "1_t" I get also the sentence "1_" in my dataset.
Is it normal ?
Thanks for your answer
Best Regards

[AndreyZ]

Please try using the following code:

Code: Select all

ClientDataSet.Filter := 'fieldname=''1_t*''';
ClientDataSet.Filtered := True;
ClientDataSet.Open;

, and check if the filtering problem persists.

[fgoutemant]

I have tried your code but unfortunately i have still a filtering problem.
here is my code :

ClientDataSet.Filter := 'number=''1_t*''';
ClientDataSet.FilterOptions := [foCaseInsensitive];
ClientDataSet.Filtered := True;

thanks for your help

[AndreyZ]

I cannot reproduce the problem. Please specify the following:
- the script to create your table;
- the exact version of your IDE.