| Author |
|
judetf
Senior Member
Joined: January 23 2008
Online Status: Offline
Posts: 234
|
| Posted: May 31 2008 at 07:57 | IP Logged
|
|
|
This has happened a couple of times:
I'm editing a macro and I do something that results in an SQL error ("Delete Id = '?" AND Delete Sequence = '?' - or something like that).
If I click 'Cancel' on the error message, I am left in the macro detail screen where everything appears intact. However, if I go immediately to the Multi-Editor and query the macrodetail table for that macro, there are _no_ lines - it's gone, even though I can see it in the editor.
Attempting to save the macro with F5 just results in the same error. I haven't been able to figure out how to recover at this point. As soon as I hit 'OK' on the error message the macro essentially deletes itself (ie, I guess the macrodetail table gets queried and, since it's empty, the macro is gone).
Is there any way to recover the macro at the point where I can still see it and edit it on the macro detail screen? I know I can take screenshots and copy-and-paste out to Notepad and then rebuild the macro, but that seems... lame.
Any thoughts?
Thanks
jtf
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: May 31 2008 at 10:58 | IP Logged
|
|
|
Have you tried Undo at that point?
|
| Back to Top |
|
| |
judetf
Senior Member
Joined: January 23 2008
Online Status: Offline
Posts: 234
|
| Posted: June 01 2008 at 06:45 | IP Logged
|
|
|
I confess I haven't... I'll give that a shot the next time. However, I can say that in the one that just happened yesterday, I had worked only on a single formula (ie, one line) in a macro, and when I got the message my first thought was that the line was too long (I had made lots of comments) so I went back into it and (after copying-and-pasting) deleted most of what was in there and I was still unable to save at that point.
But I'll try undo and report back next time it happens.
jtf
|
| Back to Top |
|
| |
TonyNo
Moderator Group
Joined: December 05 2001
Location: United States
Online Status: Offline
Posts: 2889
|
| Posted: June 01 2008 at 09:47 | IP Logged
|
|
|
Anyone else seeing anything close to this? I can't say that I have.
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Recover from corrupt macro?
