Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pasting in Excel occasionally randomly fails
Message
From
23/10/2014 13:57:32
 
 
To
23/10/2014 13:50:54
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01609799
Message ID:
01609820
Views:
45
Well, actual re-compile is certainly not an issue, except that in our environment, where building includes updating Source Control and what not, and installing it for our users, it is much more of a hassle than anybody would like.

Beyond that, this happens (has happened) in quite a few different applications, so re-compiling all of them actually IS quite a bit of work.

So your guess (and everybody else's, it seems) is that the problem is with datatoclip somehow -- that occasionally, operating on exactly the same data, it fails to produce anything?



>>Well, actually, I can't do that. I restore the clipboard after using it, so there's no evidence left.
>>
>>As this problem occurs in any of a number of applications, I would have to recompile all of them.
>>
>>Furthermore, the actual code is:
>>
>>
Select(lcExportAlias)
>>Goto Top
>>DataToClip(lcExportAlias)
>
>Well your DataToClip() should be doing that... but for debug mode, you could check the used row count in excel before and after pasting - if it didn't increase, then strtofile(_cliptext, "some name derived from datetime()") and see what you got in there.
>
>Recompile doesn't hurt much nowadays... I remember when that was an excuse to have a break, now it's not worth trying to begin anything else. The app I'm most frequently busy with has an exe of about 20 megs, compiles in 5-6 seconds and my machine is about four years old.
Jim Nelson
Newbury Park, CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform