Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
End of file encounted
Message
 
To
28/02/2001 17:10:15
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00480732
Message ID:
00480933
Views:
9
Cyndy:
The following codes that I had been use for a long time. This month the user changed the format of the source from lotus file to xls file. I changed the file type to xls in append from command and the problem started.

CREATE CURSOR import (batch N(5), handler N(3), inv_date D, ag_id C(6), ;
eff_date D, exp_date D, in_name C(35), pl_num C(13), cs_id N(3), ;
hist N(1), tran N(1), type C(5), commpd N(8,2), commrecd N(8,2), ;
period C(6), co_id N(3), UNUSED1 N(8,2), UNUSED2 N(8,2),UNUSED3 N(8,2),;
premium N(8,2), POL_FEE N(4),MISC_FEE N(8,2),TAX222 N(6,2), TAX555 N(6,2))

SELECT Import
APPEND FROM &FileName TYPE XLS

I did check out the source file and it is not empty file. thanks.
sherry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform