I am trying to troubleshoot a database converted from Panorama 6. It makes use of the lookupallsextet function. Upon conversion, the procedure shows an “Expression parsing error.”
If I change it to any of lookupall,lookupalldouble,lookupalltriple or lookupallquadruple it works fine (of course removing the extra fields) but anything higher than quadruple generates an error. I tried mixing and matching the fields to see if that is the issue but it made no difference. The lookup is from the same database. I realize I could achieve the same thing with arraymerge but this should work. Any thoughts?
This is the line:
gvDonData=lookupallsextet(“Donations”,“DonorID”,“DonorID”,“Receipt”,str(“Donation#”),“Date”,“PayMethod”,str(“CAD”),str(“Amount”),cr(),"^")