isvalue
Syntax: %isvalue(rec,value)
returns true if the value exists in the database record. It actually returns the position of the value in the database record for use with %item to retrieve the key.
Examples:
#ADDKEY dbvar Name Zugg
#ADDKEY dbvar Race Dwarf
#ADDKEY dbvar Level 10
#SHOW %isvalue(@dbvar,"Dwarf")
Displays: 2
#SHOW %dbkey(@dbvar, %isvalue(@dbvar,"Dwarf")) = %item(@dbvar, %isvalue(@dbvar,"Dwarf"))
Displays: Race = Dwarf
#SHOWDB @dbvar
Name: Zugg
Race: Dwarf
Level: 10 |