[L] Lookup (Top Query)

Takes one parameter.

Description:

Performs a database lookup and assigns the value to a Top Query variable. Parameter is the database path that is to be looked up in the form of TableName|Alias|FieldName, where you may use {} to replace one or more of the path components with a Top Query variable.

Example:

Rem 'Check if we have any errors for a person
[Pull] "PersonAlias AnyErr ErrMsg"
        
If AnyErr
[New] PersonName [L] MemTab.Person|{PersonAlias}|FirstName
        HtmlAlert   "&danger", ("< b >Oops,</ b > an error occurred for " & PersonName)
        Exit
    End If
EndRem