How to store value in memo fields?

[mican]

hi everyone,

I am a beginner in memo fields. I know how to create the field in a table but I don't know how to store and retrieve values (programatically).

Is it just the same with character fields like this; Replace Employee.name With "Juan Dela Cruz" ? and this;
Thisform.Text1.Value = Employee.name ?

 

[jimoo]

That's it exactly.

Pretend the field is called Notes.

REPLACE tablename.notes with [Hello World]

To retrieve the value.

lcNotes = tablename.notes

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com

 

[torturedmind]

mican,

Is it just the same with character fields like this; Replace Employee.name With "Juan Dela Cruz" ? and this;
Thisform.Text1.Value = Employee.name ?

yes, but you use EditBox control instead of a TextBox because Textboxes can only a small number of characters (254 characters only if am not mistaken).

you may also want to look at FILETOSTR() and STRTOFILE() functions that are very useful in relation to Memo fields.

kilroy
philippines

"Illegitimis non carborundum!"

 

[Mike Lewis]

Mican,

In addition, you can use APPEND MEMO to copy a text file into a memo field.

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

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

My Crystal Reports web site:

http://www.ml-crystal.com

 

[mican]

I see...

Thank you so much to all your supports.