Comparing Tables - Bug In Program - whoops !

The program I posted earlier has a bijou bugette which causes it to loop when a row is not found in the primary table before the last row is fetched.

The fix is simple.

Add the following line after the statement 'case NO_DATA_FOUND :' after fetching the primary row ..

        if (! waiting_for_2 ) waiting_for_2 = TRUE ;
        

And similarly after the same statement when fetching the secondary row ..

        if (! waiting_for_1 ) waiting_for_1 = TRUE ;

Sorry folks :-)

MikeCollins_at_cix.compulink.co.uk Received on Sun May 14 1995 - 00:00:00 CEST