TableFilter error

shivaprasad263
shivaprasad263 Member Posts: 70
edited 2008-08-18 in NAV/Navision Classic Client
Hi masters,

One of our users getting the below error, when she tries to do some drill-down or trying to post any document.

"The filters are too large to be copied to the type 'TableFilter':"


No one else gets this error. I deleted the zup file, still same error.

Comments

  • jglathe
    jglathe Member Posts: 639
    Hi shivaprasad263,

    I had this error once. The only way to work around it was to change the processing of the filtered table, in my case to do the loop for every item contained in the filter. How do you create the filter string? There are limits to the length of the filter which is accepted, depending in the version. But the actual limit is 250 AFAIK. For Account schedules a workaround is to calculate the filter in several lines.

    HTH Jens
  • DenSter
    DenSter Member Posts: 8,307
    I've seen this error a number of times when someone programmed a filter to be something like "ItemA|ItemB|ItemC|....." while looping through the Item table. The maximum number of characters in a filter is 250 IIRC, so you will have to debug the code to see exactly where it tries to build the filter, and you will need to find another way to accomplish the task.
    Daniel Rimmelzwaan
    RIS Plus, LLC

Categories