DBFCDXer

While working via OLEDB on old clipper/foxpro database files I came across an issue when executing an INSERT request upon the dataset: indexes (CDX files only) where not updated, although they are when using an old - but fast ! - MS-DOS application.

I tried any (Visual) FoxProdriver/ADODB version, no way. I searched the web for hours and saw many posts on that problem. Until I found the file-header descriptor for DBF files. It says that byte 29 is used to indicate wether to update indexes or not.

I decided to write a small tool to test the state of that byte. Zero! Turned it into 1... It Worked!

So I decided it to the microscopical community of members querying DBF through ODBC. Enjoy. Be aware that it's a UIAYOR software. Backup your data.