DBGetMemo -- Retrieve the contents of a memo field

DBGetMemo(field-name[ ,decryption-flag, key])

Retrieving Information

Whenever you use the FileFlex record-retrieval function DBGetCurrRecVal to place the values in a database record into a single container rather than global variables or card or background fields, you must separately retrieve any memo fields in that record. The FileFlex DBGetMemo function will retrieve a named memo field's contents and put that data into the named container.

If you use DBGetCurrRecVal to retrieve a record list, you can tell that "GetCurrRecVal" has found a memo field even if you don't know the database file's structure, because any line of the container into which you place the record values that contains a memo field has an "M" as its second item and an empty third item.

If you use DBGetCurrRecVal with the global variable "G" option to retrieve database information, you need not retrieve memo fields individually. FileFlex will do this for you automatically.

If you wish to decrypt a field, you'll need to use the "D" decrypt flag, along with your key code.

The FileFlex 3.0 write and read functions contain the same capabilities and limits of previous versions, even though the FileFlex file format now supports all FoxPro data types including binary and huge memos. Future versions of FileFlex will add intelligent support for large object data typing, but we've got plenty to keep us busy with the current release.

put DBGetMemo("NOTES") into myMemo


Copyright © 1992-1998 by David Gewirtz, under license to Component Enterprises, Inc.

Casa de Bender