Determine the type of a dbf file 2

[rob444]

I wrote a very small win 32 bit executable to determine the DBF filetype (dBase / Foxpro / Visual Foxpro ea)
It's a 9kb executable that doesn't need anything except windows to run.

This is the download link:

http://www.rbftp.com/transfer/foxpro/dbftype.zip

Rob.

 

[mspratt]

Thanks, Rob!

Should come in handy.

Regards,

Mike

 

[GriffMG]

Brilliant!

Thanks Rob

Regards

Griff
Keep [Smile]ing

 

[keepingbusy]

Like it Rob!

Lee

VisFox Version 6 User / Windows ME

 

[craigsboyd]

In no way to detract from the program rob created, but another way to determine the type of a table is to use SYS(2029)

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'Data\testdata')
USE Customer && Open customer table

CLEAR
DO CASE
CASE SYS(2029) = '3'
? 'Previous versions of FoxPro'
CASE SYS(2029) = '48'
? 'Visual FoxPro Table'
CASE SYS(2029) = '67'
? 'dBASE IV SQL table, no memo fields'
CASE SYS(2029) = '99'
? 'dBASE IV SQL System table with a memo field'
CASE SYS(2029) = '131'
? 'FoxBASE+ table with a memo field'
CASE SYS(2029) = '139'
? 'dBASE IV table with a memo field'
CASE SYS(2029) = '203'
? 'dBASE IV SQL table with a memo field'
CASE SYS(2029) = '245'
? 'Previous versions of FoxPro with a memo field'
ENDCASE

http://www.sweetpotatosoftware.com

 

[rob444]

That's right Craig, only one possible problem:
When opening a DBF file foxpro changes things in some cases.
It's safer to open such a file in another way.
A safe method could also be faq184-3162

Rob.

 

[terosoft]

Great work Rob!

But, if it's written in C and it's not much to ask, could you create a .FLL library instead. This way it could be used transparently, I think.

Regards...

Gerardo Czajkowski

 

[rgbean]

Gerardo,
It's really not necessary in a VFP app as Craig has pointed out - just use SYS(2029)!

Rick

 

[terosoft]

It's true what you say Rick, but as Rob notes if one's not careful Foxpro can change the header of DBF files once opened. This utility is useful in such cases.

Gerardo Czajkowski

 

[rob444]

Gerardo,

have a look at the sourcecode in FAQ184-3162
which does the same as the executable, WITHOUT modifying the dbf file to a vfp structure using low level functions.

No need to create a .FLL because it can be done simple in VFP itself.

The executable was written to check DBF files WITHOUT the need to have (runtimes of) Foxpro, Visual Foxpro, Dbase or whatever.
It was written in PureBasic to obtain the smallest possible executable possible.

Rob.

 

[terosoft]

have a look at the sourcecode in FAQ184-3162
which does the same as the executable, WITHOUT modifying the dbf file to a vfp structure using low level functions.

Thanks for the link, I'll check it.

Gerardo Czajkowski