About VFP9.0 remarks field (memo) insertion and editing, vfp9.0memo

About VFP9.0 remarks field (memo) insertion and editing, vfp9.0memo

I recently used VFP9.0 as an old database in my project. I have been entangled in this problem for a long time. This is the memo remarks field. When you insert, an error occurs when the inserted string data exceeds 64 KB.

After that, I have been searching for the reason that the remarks field is limited to 64 K, but the problem is that my data is larger than 64 k. For example, insert into indicates ('Remarks field ') values ('2017 1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111111111111 1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 111111111111111111111111111111111111111111111111111111111111111 ') I don't want to add it ..

I used the filetostr('new folder .txt ') function to insert it .. Put the value to be inserted in the txt file first .. In this way, the instance can be added successfully.

Insert into indicates ('Remarks field') values(filestostr('new folder .txt '))

　　

In VFP, how do I enter the remarks field in the table?

Click Browse or edit to display the record. Double-click the record's "memo" or press Ctrl + PgDn to stop the cursor at "memo". The edit window appears. After editing, the record changes to "Memo ".

Urgent: Teach VFP Problems

Double-click this field. In the edit window, enter this field. After the input is complete, press the close button to exit and save automatically. In this case, memo is changed to Memo, which indicates the difference between content and NO content in this field.

Or when the cursor is in memo, press ctrl + PgDn to enter the edit window. Find the two keys on the keyboard.