The CA of the VFP8 has a fetchmemo property if setting fetchmemo = .f. The content of the MEMO field will not read, but if you need the content you need, it will change very much.
VFP9 began to have DelayedMemofetch methods
It can be done, when cursorfill (), MEMO is full, but when the cursor moves to the MEMO field, it automatically reads the MEMO field content of the current record. Note Yes: The method of the MEMO field of the current record can be great. Increase reading with MEMO field table
The operation is as follows:
1.FetchMemo = .F.2.FetchMemoDataSourceType = ca.DataSourceType3.FetchMemoDataSource = ca.DataSource4.FetchMemoCmdList this is the most critical and most troublesome oCA.FetchMemoCmdList = "f1
F1, F2 This is the MEMO field name referred to as F0 is a key field name this.refreshalias can be this.alias
The translation means that as follows: SELECT MEMO field name from the back table name WHETE key field name =? The Alias name of the front desk. Key Field content
note:
DELAYEDMEMOFETCH is a built-in protection method that cannot be called directly in the program.