How to read DBF generated in Protheus in Visual Fox Pro?

Asked

Viewed 240 times

0

I ran a DBF in the Protheus and I am having difficulties to open the file in Visual Foxpro, as it does not recognize the file returning the message:

dbf file is not a table.

Has anyone been there or knows what version of DBF that the Protheus and Visual Foxpro work?

Thank you.

  • I’m pretty sure Protheus' DBF is purposely incompatible.

  • @bigown I think not...Protheus uses third-party libs (ace32.dll etc) for accessing dbf files. The company that originally owned the libs (Advantage Database Server) today belongs to SAP.

  • Make sure the created file is actually in DBF format. If you use localfiles=ctree, or the Advpl program itself uses another driver, it may write the file to disk with the DBF extension, but internally it is not a DBF.

3 answers

0

How did you generate this in Protheus?

The DBF it generates normally opens in Excel for example.

The file you generated is corrupted, or Visual Foxpro is missing the correct drivers.

Remember that if the DBF has Memo fields, you need to copy the FPT next to the DBF.

0

The format used by a DBF file can be identified by opening the file with a hexadecimal viewer by checking the hexadecimal value of the first byte of the file. The formats used in Protheus are:

  • 0x03 ( memo field ) -- Foxbase+/Dbase III plus compatible
  • 0xF5 ( memo field with auxiliary file format . fpt) -- Foxpro 2.x (or earlier)

To see the full list of other formats, see the link dbase Table File Format (DBF)

-1

When you created your DBF in Protheus, you must have created another file with extension . vfp that must be together in Visualfoxpro, see discussion:

Browser other questions tagged

You are not signed in. Login or sign up in order to post.