RE: Well I am creating the Visual app to do what the old clipper one did and more, but of course we need to use the same data and the parts that have not come over yet in the old clipper app they still run there. Yes they were originally created in clipper. No they were and are FPT but that is one of the tables that I coded out of the old clipper app, that memo table is pure VFP, the prob with it was it would go wacky after going over a gig on the FPT file. The problem I am having with the shared tables is indicies going bad when they both append records at the same time, and I also have some data shifting in another table that even puts char in numeric types, etc. kinda freaky to see that.

>We are running two different exe's using the same tables. One is in Clipper and the other is in Visual Fox Pro.

Kevin,

I guess the first question that screamingly leaps at me is why are you sharing tables between Clipper and VFP? Are the tables originally Clipper files? If so, their memo files are DBT files and not FPT files. Additionally, the index files are different as well so unless I'm mistaken I can't see Clipper and VFP successfully sharing indexes. Maybe someone else can chime in about compatibility about using VFP natively against other xbase tables.

If you truly have to share Clipper files between the two languages, I would personally try to find a Clipper ODBC driver that VFP can access the data with.

Laterness,
Jon
Jon Rosenbaum
SS&C Tech Support/Development
Devcon Drummer