How To Create Memo File in VFP

[Renebear]

Hello Folks!

I need to create a table/file with more than 500 bytes long of field length to keep text. The maximum character length allowed by VFP is 254. I read something about Memo fields but have not really done it. A DBF table with memo fields has corresponding FRT. How does this work? Do anyone of you guys can help me? Some examples on how to use Memo field on a table or anything that could make me going. Thank you so much in advance.

 

[jimoo]

Renebear

If you open the table exclusively you can modify it.

from command window
USE Joblist EXCL
MODI STRUCTURE

Add the new field and Select memo type. This will create a new file, the stem will have the same name as the table and the extension will be .fpt.

In this example, it would be joblist.fpt

Anyway, if you browse the table you will see the new memo and if you double-click on the small 'memo' a window will appear for you to enter data into. Of course, you could also do it like this:

Assume the field name is mynotes.
Replace joblist.mynotes with "Jim has really nice dogs"

If you browse the table again, you will notice the memo now appears as "Memo" This means there is data in that field. Go ahead and play around with it. It is pretty easy to setup and for the most part can be treated like a normal field.

If you need to alter the table programmatially. See my FAQ.


Finally, search help for memo fields or file types and you will find a lot of information concerning size limits and how to keep them from bloating.




Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[ramani]

Hi renebear

If you already have a table myTable and want to add a Memo field MyMemo, then the following command will do that.

ALTER TABLE myTAble ADD COLUMN myMemo M



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[Mike Lewis]

Renebear,

To add to what the others have told you ....

You can also do it by opening the table designer, adding a field, and setting its data type to memo.

The point in all of this is that you don't have to create the special FPT file. FoxPro will do that for you when you add a memo field to your table.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk