| |

VerySource

 Forgot password?
 Register
Search
View: 847|Reply: 4

Questions about Filter

[Copy link]

2

Threads

6

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

Post time: 2020-2-5 17:30:02
| Show all posts |Read mode
I want to implement a function like this:
  ADOTable.Filtered: = false;
  ADOTable.Filter: = 'Encoding IN (' 001 ',' 002 ')';
  ADOTable.Filtered: = true;

  Does not seem to support it. what should I do? IN (the number here is uncertain)
Reply

Use magic Report

0

Threads

13

Posts

12.00

Credits

Newbie

Rank: 1

Credits
12.00

 China

Post time: 2020-3-25 11:30:01
| Show all posts
Haha, I haven't used TABLE for many years, why don't the landlord try ADOQUERY.
If you must use it, I suggest you try it like this

// Filter multiple times
  ADOTable.Filtered: = false;
  ADOTable.Filter: = '001';
  ADOTable.Filtered: = true;
  ADOTable.Filtered: = false;
  ADOTable.Filter: = '002';
  ADOTable.Filtered: = true;
Reply

Use magic Report

2

Threads

6

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

 Author| Post time: 2020-3-29 13:00:01
| Show all posts
Ha ha I started using TABLE for simplicity. I didn't expect customers to ask for one from the right.
That's it. I knew I would use ADOQUERY at first
IN (the number here is uncertain) does not work multiple times. . It seems I'll change it slowly.
It really doesn't work and can only use ADOQUERY.
Reply

Use magic Report

0

Threads

53

Posts

29.00

Credits

Newbie

Rank: 1

Credits
29.00

 China

Post time: 2020-3-29 16:00:02
| Show all posts
Filter does not support complex SQL functions, such as your in
Reply

Use magic Report

2

Threads

6

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

 Author| Post time: 2020-3-30 22:45:01
| Show all posts
ADOQUERY to solve hey ………………………………
Next time, it will be more troublesome for users to think. I wanted to give myself 2 fewer lines of code. Finally, I made a lot of changes for myself.
Ha ha
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list