INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Open tables with Foxpro created with Clipper 5.0

Open tables with Foxpro created with Clipper 5.0

(OP)
Good afternoon,

has anybody an idea why Visual Foxpro 9.0 is not able to
open a table that has been created with Clipper 5.0 using the DBCREATE()-function ?

Many thanks in advance

Horstibaby

RE: Open tables with Foxpro created with Clipper 5.0

As far as I can tell VFP 9 can open tables created by Clipper - so long as they don't have memo fields, as these would not easily be recognised.

I just tried one and it worked ok, no indexes and memos and it's fine.

What is the structure of the table you are opening?

Regards

Griff
Keep Smileing

RE: Open tables with Foxpro created with Clipper 5.0

(OP)
Hello Griff,
thanks a lot but my problem has not been solved yet.
I should first like to inform you, that we create the dbf
with the dbcreate() function, such as dbcreate(filename,filstructure).
The clipper created tables do not have memo fields, but
they do have an index !! Could this be the problem ?

Or can it be, that I only need to specify any properties in VFP, such as dbase-compatibility, which can be achieved clicking a checkbox in VFP environment. ( which I did )

Thanks again for your help

Horstibaby

RE: Open tables with Foxpro created with Clipper 5.0

The index file may/will cause problems, it will depend on it's format (.ntx or .cdx [if you are using a driver for .cdx)

Another possible gotcha is whether the table is open already, and your VFP code is opening it exclusively...

I didn't need to do any tick boxes in VFP to enable compatibility.

Regards

Griff
Keep Smileing

RE: Open tables with Foxpro created with Clipper 5.0

(OP)
The Index-File is a MDX file. I do not have any idea how to change the index driver, I only installed VFP on my PC, so it should automatically install the idx or cdx index driver.

Tables generated with dbase 5.0 that have mdx indexes can easily be opened with VFP.
The table is not open, VFP simply reclaims 'this is not a table ' when I try to open it, even SQL-SELECT commands reclaim the same error.

Greetings
Horstibaby

RE: Open tables with Foxpro created with Clipper 5.0

I'm not familiar with MDX index files, it's the one that DBase IV / V would have created I guess.

Can you open the table with Clipper? or DBU?

Regards

Griff
Keep Smileing

RE: Open tables with Foxpro created with Clipper 5.0

I wonder if in order to link the .MDX file to the .DBF, dBase used a byte in the table header - this would render the file 'not a table' to VFP?

VFP does something similar for .CDX files...

Regards

Griff
Keep Smileing

RE: Open tables with Foxpro created with Clipper 5.0

Clipper has a RDD for DBase IV/V called DBFMDX, but it is not very much used, and I'm not sure about compatibility with other DBase IV/V aware apps.
Have used it in one special app that had to share data with DBase IV, but that was over 10 years ago...

Assuming Clipper 5.2 (or later), if you link in DBFMDX.LIB (also put REQUEST DBFMDX on a separate line somewhere in your source, not inside a function or procedure), you can use the syntax DBCREATE(filename,filstructure,"DBFMDX") where "DBFMDX" is the optional 'VIA' parameter for specifying the database driver to use.
It is properly documented in the Norton Guides that come with a normal Clipper installation.

HTH
TonHu

RE: Open tables with Foxpro created with Clipper 5.0

(OP)
Hello Griff hello TonHU,

Griff, I also think the header of the clipper DBF contains information which VFP expects at another position in the header. VFP does so with VFP dbfs and its .cdxs.

TonHu, will try out your response as soon as possible, I also thought there are more parameters using the DBCREATE()-function than filename and structure but I am not familiar with those.

Nevertheless, thanx a lot to both of you

Horstibaby

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close