Adding data on memo field?

[icemiller]

How are we going to add data inside the memo field if it is not empty? We have no problem if it is empty. We just use the REPLACE command to place our data inside it.

 

[ofuncke]

Just add to the contents like this:

REPLACE DB->MEMO WITH DB->MEMO + cString

or

DB->MEMO += cString

 

[wildcard]

I use a function MEMOEDIT(). I also use some GRUMPFISH
utilities to insert automatic dates, times, etc if relevant.
I also use my own boxdrawer() functions with pretty colours
and highlighted hotkeys to guide users in possible
navigation and edit options.


Example...
editok := .T. && True for edit, false for readonly
mydata=MEMOEDIT(fieldname,top,left,bottom,right,editok,"&quot
IF updated()
REPLACE fieldname WITH mydata
ENDIF

Jim

 

[icemiller]

Thanks!guys. I have already tried that but I still have a problem. I am merging multiple dbf files into one .dbf file with only one record, that means all the entries on the memo fields of all the files will be put into one. if you process the file you will notice that not all the data were collected. But having a quick view on the .dbt file, you can see that they are all there. I will appreciate so much if you guys can help me on this. Do you have an idea on how we can convert a .txt file into .dbt file?

 

[subra]

you can open your source file and replace the memo field in a destination file using memoedit. read the source file record by record. keep concatenating the string and write to the destination memo field.

SUbra if you find this useful let me know at vksubra@usa.net

 

[markfrolic]

Use memoedit and also search for unnecessary space within the text in the memo b/4 merging them together.

Mark Frolic
Lagos, Nigeria