The INLIST() function is limited to 25 items in the list. You should reconsider your design also because the filter expression is not optimizable. The bigger table will get, the slower your code will became.
>am getting "Too many arguments (Error 1230)" error when setting a filter.
>my code is
>lcProvno = "'10','11','12'"
>SELECT mytable
>SET FILTER TO EMPTY(sent) AND INLIST(mytable.srvprov,&lcProvno)
>
>the variable lcProvno contains some nos .if i pass around 20 nos it works fine ,if it is more than that i get abv error.
>
>is there any way to do abv with unlimited nos.
>BTW after setting filter i assign it to grid.
>
>i know i can create cursor and bind to the grid. which i cant do now bcoz there is lot of code which assume only those filtered records in that table.
>Thanks for your help
--sb--