Filter limits

[ivanyuzafatau]

Hi everyone!
Faced the following problem.

kbmMemTable1.Filter := 'EmpNo in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51)';
kbmMemTable1.Filtered := True;

It works well.

kbmMemTable1.Filter := 'EmpNo in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52)';
kbmMemTable1.Filtered := True;

It does not work..
I am getting the following error: Variant or safe array index out of bounds.

The values are listed in order for clarity. In a real application, the values are random.

Why can’t I use more than 51 values? How can I get around this limitation?

[Author]

Posts