Filtering a table with an UNIQUEIDENTIFIER field

[ads42]

Hi,
I can't figure how to filer a table with an UNIQUEIDENTIFIER field.
Any expression sample for doing this stuff ? it seems that ising simply a string doesn't work.
Regards

[AlexP]

Hello,

To filter data, you can use either local filtration

Code: Select all

  MSQuery1.KeyFields := 'f_uniqueidentifier';
  MSQuery1.Open;
  MSQuery1.Filter := 'f_uniqueidentifier like ''%d6658596%''';
  MSQuery1.FilterOptions := [foCaseInsensitive];
  MSQuery1.Filtered := True;

or use filtration on the server

Code: Select all

  MSQuery1.FilterSQL := 'f_uniqueidentifier like ''%d6658596%''';

[ads42]

Hi Alex,
sory haven't received notifications about reply.
In your sample code you use an integer as a unique identifier, but in my case it's something like :
7fcaf9b3-7256-4953-a0e0-0c6122b47660

Any idea ?

Regards

[AlexP]

In my example, I use a string field as KeyFields (the LIKE operator is used with strings). Please provide your query example.

[ads42]

in my case 7fcaf9b3-7256-4953-a0e0-0c6122b47660 is a string field.
Should I use %d like in your sample ?
Can you change your code using my string ?

[AlexP]

The '%' symbol in the LIKE operator means that any sequence of symbols can be in this place, i.e., if you specify in the filter:

Code: Select all

filed_name like '%a0e0%'

then all strings containing 'a0e0' will be found. If you need an accurate search, you should use the following filter:

Code: Select all

filed_name = '7fcaf9b3-7256-4953-a0e0-0c6122b47660'

[ads42]

Thanks Alex.