Can't get superlookup( to work


#1

Using two identical databases, this statement in the primary database:

field «Results field» formulafill superlookup("Target", {«Words2» = ««Words1»»},{«Data to return»},"selected",true(),"wrap",true(),"default","")

… fills every record in Results field with the correct result for the first record in the primary database - every record contains the same result.

Using lookup( terminology, Words2 is the keyfield in the Target database and Words1 is the keydata in the primary database.

Am I doing something wrong or is the function broken?


Problem changing formulafill Lookups to Superlookups
#2

A little clarification - if both databases are sorted up, it gets the incorrect result in 2 seconds. If they are randomly sorted, it takes 10 minutes to get the same result.


#3

My guess would be that the problem is issue #703. And before you say “but I am not using grabdata(”, you actually are, that is how the double chevron feature works.


#4

I’ll check that out tomorrow. Thanks Jim.


#5

So does this mean that superlookup( is off the menu?


#6

It means that grabdata(, and double chevron notation, is off the table in formulafill, select, and any other statement where a formula is repeatedly evaluated over and over again for each record in the database. That certainly does limit the scope of the superlookup( statement when used with these statements.