Dear List I have a filter that calls a guide that loops a table with 3000 records. For each row, it gets info from the entry, and depending on the value, adds the info to a list in a character field. The problem is, the guide seems to be looping the table 3+ times. The list field shows the same several entries three times, and begins the fourth time, then stops before getting to the end.
If I run a filter log it begins in the middle of the looping process, apparently because the log has exceeded its maximum size and the beginning is getting dropped. The Max Log-File Size is set to 2,000,000 bytes. If I try to change it I get, "Value does not fall within the limits specified for the field : (0-100000) : Maximum Log-File Size (byte) :" So it is already over its limit. In the portion of the filter log that I can see, the system processes a record 9/10 of the way to the bottom of the table, then jumps up to the second table row, skipping the bottom and top rows. Towards the end of the guide I find this bit of code: 'Call Guide "GN:SysVar-Fill Inactive ESN list" (return).' This is after it has processed a row about a sixth of the way down the table. So it looks like the guide is looping the table three times, but never quite gets to the end, and on the fourth loop it arbitrarily quits in the middle. If the table were based on a regular form I could use an sql query to find the records, but it is based on a Vendor form, and they don't seem to have underlying tables or views. If I change the table qualification to only include a few entries, everything works fine and the guide only loops the table once. Maybe filter guides simply get lost when they try to loop tables with thousands of rows. Any suggestions? (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) Dwayne Martin James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
