Syntax: %find(s,view,column)

returns a list of records in a database whose first column contains the string s. If view is specified, it is a string list whose first value is the name of the View to search, and optional second item is the two-character database name. Column is the name of the column to search instead of the first column and is optional. The string list that is returned is a list of record numbers with the database name attached.


If records 8 and 20 in the Potions view have a name in the first column containing the word "blue", then

#SHOW %find("blue",Potions)

would return the list 8eq|20eq

Add comment

Login or register to post comments