FILEFLEX API REFERENCE



NAME
DBFindMemo -- Full-text search in memo fields

SYNTAX
DBFindMemo(field-name, search-string)

CATEGORY
Retrieving Information

DESCRIPTION
The DBFindMemo command does full text searches of memo fields for specified strings. The first parameter is the name of your memo field, the second is the string you are searching.

DBFindMemo is very fast and reasonably powerful. It does searches in physical record order (meaning that any existing relations, as well as DBQuery, DBSeek, and DBSkip options are ignored). DBFindMemo starts at the current physical record and searches iteratively, record-by-record until it either finds a matching string or the end of the file. Because it starts at the physical record, you may want to turn off any pre-existing searches to make sure a DBTop takes you to the first physical record.

If DBFindMemo succeeds, it returns a 0; if it fails, it returns a 3 (and positions the physical record pointer at the end of the file).

If you use DBFindMemo, you should be aware that it searches until it finds...so that if you've got a huge database and unleash DBFindMemo, it could take some time until the routine returns a result. DBFindMemo does not offer any conditional expressions; if you look for "TITLE=foo", it will search for the string "TITLE=foo". DBFindMemo is extremely literal; it knows not of spaces, words, items, separators or much else. DBFindMemo is not case specific. Searching for "foo" will return successful if "FOO", "foo", "fOO" or even "foodstuffs" is found.


EXAMPLE
  put DBFindMemo("NOTES","Component Software") into successFlag

INTERNAL FUNCTION NUMBER
40


Copyright © 1992-1998 by David Gewirtz, under license to Component Enterprises, Inc.
Contact: info@component-net.com

Casa de Bender