Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How insert memo field from fpw2.6a into mysql-table

Status
Not open for further replies.

stesvet1

Technical User
Sep 23, 2006
22
Hi,
I will use FPW2.6a because its geniality and need sometimes for my student to convert my foxpro table with 7 colums and one memo-field into mysql.

I made a prg.file, which converts without problem 7 colums but not the whole memo. A

Allthough it works to convert a string (just part of memo), e.g. if I use $memo.tp=substr(TP,100).

In mysql I tried table field LONGTEXT - in phpadmin it works if I manualy copy and paste the memo-text into LONGTEXT field. But I want to make it from foxpro.

In other words.Does exist in mysql a similar FPW2.6a command =>

APPEND MEMO <memo field> FROM <file> [OVERWRITE] //Copies the contents of a file to a memo field?

Steven
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top