¿ Why ?

[capri1966]

Hello, i've using vfp 6 and i have some applications that work fine on several customers. But now i'm trying to open
the same projects in vfp 9 and appears an error.
The forms y vfp are dbf really and i'tried to open it as dbf and suspect that the problem is the memo fields.
I´dont understand why occurs this. There is a diference between VFP 6 and VFP 9 on memo fields ?.
Thank you

 

[TamarGranor]

VFP 8 and 9 do some additional checking of DBFs to make sure they're are no internal errors. So a table that opens in VFP 6 can throw an error in VFP 9. The table has the same issue in VFP 6--it just overlooks it.

To work around, SET TABLEVALIDATE TO 0. Better, try to fix the problem. The first thing to try is copying the table to another file.

Check this out as well:

http://fox.wikis.com/wc.dll?Wiki~NotATable~VFP

 

[Mike Lewis]

You might also take a look at this:

http://www.tek-tips.com/faqs.cfm?fid=5641

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[capri1966]

There is no problem with the .dbf, the problem is with the classes, for example, i've a class file called 'misclas.vcx' and when i've tried to open the project, appears an error and only load some parts of project. Some objects from then class file, is missing, then i open the same project with vfp 6 and it's opened fine. But the same project in vfp 9, generates this message.

 

[Olaf Doschke]

You still may try SET TABLEVALIDATE TO 0 before opening that project in VFP9.

In fact there were some minor changes in project files.

You could copy the project folder and delete the PJX, PJT files in the copy, then create an empty VFP9 project with VFP9 and drag & drop all project files from Windows Explorer to the Project Manager window. Or only add the main prg, if there is one, and compile, which should add all related files to the project automatically.

While compiling you may find some things VFP6 was forgiving with, eg you could forget commas in LOCAL statements like this in VFP6

LOCAL var1;
var2

VFP9 will error on this. There are some more things to watch out for, GROUP BY for example. So compiling the project is a good first step anyway.

Bye, Olaf.

 

[Mike Lewis]

Capri,

It might help if you tell us what the error message is.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[capri1966]

Really, there is no error message. Only load the project and appears only certain part of this but when i've tried to open some components of the project then appears the message 'Memo field is missing in .vct file'.
i've used the tablevalidate to 0 and the errors continues, when i select an project file, then is opened and appears only certain parts of class file

 

[Olaf Doschke]

That should be Memo file "name" is missing or is invalid and seems the vct file is corrupt, if it's not missing.

If you can open it in VFP6, you can copy classes to a new vcx and then try to use that in VFP9.

Simply create a new empty classlib in VFP6 then drag & drop classes from the old vcx into the new one.

Bye, Olaf.