I have a complex application in QV8.5 (running on MS Server 2003) that (unfortunately) has a nested "if" statement to fill in a field of a generated table that is 301 levels deep! I know this is crazy...but it runs in QV8.5 with no errors.
However, when run in QV10 (running on MS Server 2008), it chokes on the nested "if" statement and throws the error "Too complex, more than 100 levels nesting".
Is this a QV10 problem? Will I be forced to find a more efficient way of fill in the field? And...what may this more efficient method be? Create a table and join on the 5 fields it is testing to populate the new field? Loop thru a matrix?
Looking for some advice from the QV brotherhood. Thanx.
