How to find the reason for "Not A Table" 1

[TallPeter]

I have copied a project from a collegues PC. I am not able to compile it due to the error "Not a table" (no error code).

I know it is a corrupted header. Fine. I also know of yrecover.exe. I have another problem: I cannot find out what to recover. The error message doesn't point me at anything.

Having used SET LOGERRORS ON i expected a log to be genereted, but no .err file having to do with FoxPro is found anywhere on my disk.

I have opened all forms one at a time and excluded the ones that I cannot open, but the problem remains.

Any ideas what to do next?

 

[rob444]

Perhaps you can do something with this utility (freeware for private use)

http://www.rbftp.com/transfer/VFP-CMREPAIR.ZIP

Good luck,
Rob.

 

[csandu00]

You can try to find out what file is involved with filemon from

http://www.sysinternals.com,

which is an excellent (free) tool.
Good luck!

 

[Mike Lewis]

TallPeter,

I recommend Ted Roche's program, WhichOne.Prg -- see

http://radio.weblogs.com/0117767/stories/2003/01/18/twikiBlogArchive200205.html

(see the entry for 8 May 02).

This program displays the name of each file as it does the build. When the build stops with an error, you will know which file caused it.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[TallPeter]

Mike,

That looks like the exact kind of tool I need. The only problem is: the link to the "WhichOne.prg" is dead.

Do you have a copy of the program or do you know of another place to find it?

Peter

 

[Mike Lewis]

Peter,

Yes, I can send you a copy.

If you don't want to post your email address here, do the following:

- Click on the link to my website below.

- On any page of the site, click the "Contact Mike Lewis" link (bottom right corner of the page).

- That will let you send me an email. Send me your email address.

It's a very simple and useful program. Just open a project, then run WhichOne.prg from the command window.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[TallPeter]

No problem: My mail address is peter@dentavision.dk

Peter

 

[Mike Lewis]

Peter,

Consider it done.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[castor2003]

I don't know whether Mike's Solution worked but, that 'Not a Table' message is usually, from my experience, indicative of an encrypted table.

TallPeter, let us know whether you were successful with Mike's solution

 

[TallPeter]

I have only just now tried the program, but I can assure you it worked. It pointed me to a classlib that I didn't even consider a poissible source of the problem. Great!

Big applause to Ted Roche and Barbara Peisch for this tool. The tool slows down the compilation a bit, but who cares? Better compile for five minutes than search for the source of the problem for days.

Thanks a lot.

Peter

 

[Mike Lewis]

Peter,

Delighted that the tool worked. I'll pass on your comments to Barbara and Ted. In fact, I'll see if I can arrange for them to publish the tool somewhere so that other people can use it.

castor2003,

'Not a Table' message is usually, from my experience, indicative of an encrypted table

Maybe, but there are dozens of other reasons for it, especially corrupted table headers and version incompatibilites (for example, if you open in VFP 7.0 or earlier a table that has AutoInc field).

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[Mike Lewis]

If anyone else wants to use WhichOne.Prg, it is now available for download, with permission of the authors. see thread184-618121 for more details.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk