S
Sri Nivas
Guest
i want to know database search by getting input as keyword(string) ,based on that keyword we search the entire database and display the record contains that input keyword
FOR EACH _file WHERE (NOT _file-name BEGINS "_" AND NOT _file-name BEGINS "sys") NO-LOCK:
FOR EACH _field OF _file NO-LOCK:
ASSIGN ttable = _file._file-name tfield = _field._field-name . FOR EACH &ttable WHERE ttable.tfield MATCHES "urpon frisbee " NO-LOCK :
MESSAGE "hai"
VIEW-AS ALERT-BOX INFO BUTTONS OK.
DISPLAY _file._file-name .
END.
END.
END.
Continue reading...
FOR EACH _file WHERE (NOT _file-name BEGINS "_" AND NOT _file-name BEGINS "sys") NO-LOCK:
FOR EACH _field OF _file NO-LOCK:
ASSIGN ttable = _file._file-name tfield = _field._field-name . FOR EACH &ttable WHERE ttable.tfield MATCHES "urpon frisbee " NO-LOCK :
MESSAGE "hai"
VIEW-AS ALERT-BOX INFO BUTTONS OK.
DISPLAY _file._file-name .
END.
END.
END.
Continue reading...