>>This is one of those nightmares. For more than a year this function has been working fine. I added a piece of code to sort the data after initially filling the table. I tested it, it worked fine, I compiled it into an exe, that worked fine and then all of a sudden I go back and the code fails. I run the exe and it still works. I restore from the backup that was done at the time the exe was compiled and that code now fails. Something on my computer settings or foxpro settings or something other than the code has changed which is causing this function to fail and it is driving me crazy. I appreciate your suggestions but it looks like this is going to be another of "Bill's little mysteries" that I'm going to have to figure out by slow random hacking.
>>
>>Thanks again.
>>
>>Ed
>
>Please post your findings when you figure it out.


Erik,

Well, I figured it out. The problem turned out to be one line of code that got commented out accidently. What completely messed me up was the fact that the old restored prg files were not working either when they used to. I think that the idea is that I never re-compiled the restored prg before a test and I was, therefore, funning the latest fpx and not the restored code at all. This whole thing had me looking in the wrong places the entire time.

Oh well, live and learn. I guess that today was just not meant to be my day. I really appreciate you and Doug trying to help me out. Sorry you had to waste you time on such a bone-head.

Thanks again.

Ed