I changed a textbox with data type c(20) to an editbox with data type m(4) so the user could add a longer description. I use the following SQL to create a cursor that is used to create an Excel file (COPY TO (filevariable) TYPE XL5)
SELECT log,requestor,division,memdate,datexxrecd,divrefnum, ;
section,ALLTRIM(substr(comments,1)) AS comments,status, ;
rettodate,retfromdat,indate,datecomp ;
FROM flair1 ;
WHERE STATUS=0 ;
INTO CURSOR samData ;
ORDER BY division,LOG
Now the memo field "comments" only contains the first letter of the string in the memo field. How do I get the whole string so I can send it to Excel or what is the best way to pass memo field to Excel?
Thanks in advance, Chuck
Extreme Programming = Plan -> Design -> Code -> Test