RI_FILTER - errors if more than 232

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
antje
Posts: 14
Joined: Tue Oct 10, 2017 12:44 pm

RI_FILTER - errors if more than 232

Post by antje » Wed Dec 21, 2005 1:34 pm

This issue can be reproduced for any RR9 / RR10 report if too many Report Filters have been set via the Report Program we have created for our software.____We are passing from our own report database the filter to rrunin.dbf as the runtime control file. In both databases the field RI_FILTER is C 999.____We had no issue with the same setup in RR6 - the same report in RR6 with the same filters set by the users causes no errors, if the filters are selected in the RR9/RR10 version of the report the report breaks off with various messages:____Messages that are displayed vary:__Unterminated string at offset 1 of RI_Filter__Unbalanced parenthesis at offset 232 of RI_FILTER__Unrecognized operator at offset 1 of RI_Filter____Testing with reports it seems that any filter greater than 232 characters causes an issue. __The variety of messages is explained by the fact that, of course, each filter will break of at different positions of a syntax and therefore creating different errors.____According to the documentation of RR9/RR10 the field RI_FILTER can have max C 1024, I found no issues found reported on your website yet.____This is an issue we need to investigate further as of course our reports have been created to allow multiple filter selections.____Is this a known issue? Can this in any way be fixed? Do we need to change anything?__

antje
Posts: 14
Joined: Tue Oct 10, 2017 12:44 pm

=> RI_FILTER - errors if more than 232

Post by antje » Wed Dec 21, 2005 1:36 pm

We are using the Xbase version of RR9 and RR10

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

==> RI_FILTER - errors if more than 232

Post by kfleming » Thu Dec 22, 2005 9:39 am

Try setting__CharFldWidthSize=2____in the DEFAULTS section of RRW.INI and see if that helps.____Kathleen__R&R Support

antje
Posts: 14
Joined: Tue Oct 10, 2017 12:44 pm

===> RI_FILTER - errors if more than 232

Post by antje » Fri Dec 23, 2005 6:18 am

Thanks for your reply, Kathleen.____A brief test indicates that this seems to fix the problem :-)__I will test in more detail once I am back from holidays but already thanks for your suggestion. I there would be anything further I would get back to you in the New Year.____Merry Christmas

Post Reply