Quattro Pro X9 Macro Operations - Error Message "Too Many Nesting Calls"

I've written what seemed like a simple macro to compare two lists - List 1 is the long list and List 2 is a short list which I need to evaluate to see if the names in List 2 are present in List 1.

The macro I will show below: when I executed this macro it dropped down the longer list and threw up an error code "Too Many Nesting Calls"

Here's the macro: how can I resolve the problem in the macro?

Macro Parameters: Test0 = @Cellpointer(Contents")

List 1 is in Pane1, List 2 is in 2nd Pane - the panes are not syncronized

9999999 is placed at the bottom of List1

Tester {Calc}
{Contents Test0, Test2}
{NextPane 1}
{GOTO}Name1~

Tester2 {D}{Calc}
{Contents Test1, Test2}
{IF Test1=9999999}{Eval2}
{IF Test0=Test1}{Eval1}
{Tester2}

Eval1 {NextPane}{L 4}y~
{R 4}{D}
{QUIT}

Eval2 {NextPane}{L 4}n~
{R 4}{D}
{QUIT}

Douglas Dowson over 4 years ago

There is no line break between Tester and Tester2 - the editor added that line break
Cancel
Up 0 Down

Reply

Cancel
Charles Cork over 4 years ago

The "too many nesting calls" message typically occurs when you use a lot of subroutine calls, like {Eval1} {Eval2} and {Tester2} in this example. With a subroutine, QP expects to return to the command below the subroutine after the subroutine concludes, and it stores that position in memory, but it has only a limited number of places to hold the return-spot. In this macro, you may want to uses branches rather than subroutines. I would suggest trying {Branch Tester2} instead of {Tester2}.

There may be simpler ways to detect and mark matches between the two lists, such as a function in the column adjoining the shorter list, or a macro that looks for matches without navigating to all the cells. If you interested, I would be happy to make some suggestion.

Charlie
Cancel
Up 0 Down

Reply

Cancel
Douglas Dowson over 4 years ago

Charlie,

I would be glad to have your suggestions on making matches without navigating all the cells - correcting the macro above is still very time consuming so a quicker method with out the navigation would be much faster and I certain would appreciate your input!
Cancel
Up 0 Down

Reply

Cancel
Charles Cork over 4 years ago in reply to Douglas Dowson

There are likely many variations on marking matches, but here's one straightforward method. In this example, my long list is in column A1..A100, and my short list is in E1..E10. I place this function in cell B1:

@IF(@ISERR(@MATCH(A1,$A:$E$1..$E$10,0)),"","Match")

You would modify the function to fit the blocks where your lists are. Then copy that function parallel to long list (in my case, into cells B2..B100).

The function tests whether the parallel cell in column A matches a cell in E1..E10. If not, it returns the empty string. But if there is a match, it returns the word "Match." You can then go down column B to find cells in column A that match the short list.

An alternative macro could be written that would instead alter each cell in the long list where a match occurs, e.g., by making it bold, or italic, or changing the background color or foreground color.

Charlie
Cancel
Up 0 Down

Reply

Cancel