CODEWITHSUNDEEP
databaseselectvisual-foxpromemo
Liviu Solcovenco
Liviu Solcovenco

Reputation: 85

Display memo fields in VFP

How to display the content of memo fields with select command? If I have a table (vendors) with the following fields: id_vendor C(10),address M and I want to display all the content with "select * from vendors" I receive only the type of field but not the content.

Upvotes: 1

Views: 5510

Answers (3)

spottedmahn
spottedmahn

Reputation: 15981

Double click Memo and the contents are displayed in a new window.

vfp grid screenshot

vfp memo contents screenshot

Upvotes: 1

DRapp
DRapp

Reputation: 48139

Which language are you using or what it your output audience... if within VFP, use an EDIT field to allow for multiple row content to be shown. In a simple "text box" field, it will only show "memo" as you indicate. Otherwise, as Swordblaster indicated ctrl+pgdown or even double-clicking SHOULD open it, but that would throw up an uncontrolled "window" for you vs a controlled "edit box" control which you can specifically place in your window as needed.

Upvotes: 2

Swordblaster
Swordblaster

Reputation: 356

If you are viewing the results in a browse window (which is what executing the SQL will show), then ctrl+pgdown in the field (where it is showing "Memo") will display the entire contents in a new window.

The SQL did retrieve the entire contents, which can be confirmed by in the command windows entering

? [fieldname]

And you will see the contents that way also.

Upvotes: 2

Related Questions