A table in my database is damaged

[CBU64]

and it is very large: many fields, many attributes -formats, masks, validation rules, etc.

And I presume that it is damaged because I can't handle it (I can't even open it: when i try "use localidad" from command window, VFP 6.0 says that there is no table with such name). My table is really allocated on my disk where I expect it to be.

The funny issue is that I can browse it from Project Manager.

I've analyzed my .DBC file and yeap, the definition of my table is there.

What went wrong?
Does anybody have any clue?

My worst scenario would be to free this table, but later I would have to recreate its whole definition (rules, captions, etc.).

Is there any utility to save the definition of a table from the .DBC on which it is contained?

Thanks in advance.

Take away all the buzz of this biz and what do you get? 01000100101010...

 

[alvechurchdata]

If you can browse it from the Project Manager then the table has to be there and it must hold data. It does sound as though the Command Window might be working in the wrong directory. Try some of these commands - one of them might give you a clue:

Type [TT]CD[/TT] to see which folder you're in.

Type [TT]USE ?[/TT] and then browse the directory tree to find your table.

Click on the table in the Project Manager and look at the Description and Path properties at the foot of the Project Manager window - these won't be visible if you've got the window docked.

Open the table from the Project Manager and type [TT]? DBF()[/TT] to see the name and path of the table that's being opened by the Project Manager.



My apologies if you've already tried these ideas but we need to clear the basics before diving into the more complicated possibilities.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Mike Lewis]

CBU64,

I agree with Geoff. If the error message says that the file doesn't exist, it means that VFP can't find it rather than that it's damaged.

As well as the suggestions that Geoff has given you, you could try to find the file in Windows Explorer. When you have found it, double-click on it. That should launch VFP and open the table in a browse window. If that works, it will confirm that the file is not damaged.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[CBU64]

Thank you both Geoff and Mike,

You were right. Back to the basics was the solution. I had misspelled my table's path (due to a change on the structure of my project).

Very kind from you!


Take away all the buzz of this biz and what do you get? 01000100101010...

 

[alvechurchdata]

I had misspelled my table's path

That's the sort of bug I like - nice and easy to fix.

Geoff Franklin

http://www.alvechurchdata.co.uk