Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error with COPY TO
Message
From
04/06/2019 14:15:19
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01668893
Message ID:
01668909
Views:
42
>>>>Does your table have picture (image) column?
>>>
>>>No, it doesn't.
>>>There is no Memo fields too :-)
>>>Only chars and numerics.
>>>Thank you
>>
>>I think it's COPY TO () TYPE XLS7 (or something). Can you please double check help for correct type to use the latest Excel?
>
>COPY TO command has no XLS7 parameter,
>If the user save the file in current folder there is no problem, the error is when she try to save it on Desktop.
>Thank you

COPY TO TYPE XL5 is the latest.

I was trying to think of an answer to your error, but cannot think of one apart from possibly bad data. You can examine the contents of each field against a SCATTER NAME abc BLANK version and see if the values are equal (default values) they're okay, and if not make sure they have valid data in them.

My suggestion would be to create a special copy of the app which allows a new algorithm which tries to break down the issue by halves. Do a COPY TO ... NEXT that only does the first half, then the second half, and see if any of those cause the error. If so, do half of that half, and narrow it down with that "binary search" until you find the record or range that causes the issue.

In the alternative, reduce your field count one by one until it goes away. Then try adding back in the other columns except the one which caused the issue.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform