Article ID: 137315
Article Last Modified on 9/30/2003
APPEND GENERAL fieldname DATA datastring CLASS MSGRAPH
CLOSE ALL
CLEAR ALL
CREATE TABLE grphdata (desc C(10), one N(2),two N(2), three N(2))
FOR i=1 TO 4 && create four records and load with data
APPEND BLANK
REPLACE desc WITH 'test'+ALLTRIM(STR(i)),one WITH i,two ;
WITH i+1, three WITH i+3
ENDFOR
* create a text file
COPY TO testdata FIELDS desc,one,two,three DELIMITED WITH TAB
* create a table that has a memo field to hold text file
CREATE TABLE grapmemo (textstr m)
APPEND BLANK
* place headings in the memo field
REPLACE textstr WITH ;
"desc"+chr(9)+"one"+chr(9)+"two"+chr(9)+"three"+chr(13)+chr(10)
* place data from the text file in the memo file
APPEND MEMO textstr FROM testdata.txt
graphstr= textstr && set a variable to the contents of the memo field
CREATE TABLE graph ( olegraph g)
APPEND BLANK
* add data for graph to general field
APPEND GENERAL olegraph DATA graphstr CLASS MSGRAPH
MODIFY GENERAL olegraph
APPEND GENERAL olegraph DATA graphstr USE USE graph APPEND GENERAL olegraph DATA graphstr
Additional query words: VFoxWin
Keywords: KB137315