COPY TO xxxx.xls TYPE XLS (VFP 8.0 SP1)
Posted
by Andrea.Ko
on Stack Overflow
See other posts from Stack Overflow
or by Andrea.Ko
Published on 2010-04-29T05:12:06Z
Indexed on
2010/04/29
5:17 UTC
Read the original article
Hit count: 616
vfp
Hi All,
I downloading table from SQL 2008 using VFP 8.0 (SP1) using command: COPY TO xxx TYPE XLS Some of the data in the excel is disappearing.
Example, Table in SQL: Cus(ID int(4), CusNam VARCHAR(35))
When i issue the following command at VFP Forms:
(a) COPY TO xxx TYPE FOX2x [Data display correctly as following]
*ID CusNam
1 ABC
2 DEF*
(b) COPY TO xxx TYPE XLS [2nd Record disappear]
*ID CusNam
1
2 DEF*
Appreciate for any helps!
© Stack Overflow or respective owner