Subject Re: dUFLP:FixDBF7 repairing BLOB errors From Mervyn Bick <invalid@invalid.invalid> Date Wed, 30 Aug 2023 10:53:07 +0200 Newsgroups dbase.getting-started On 2023/08/29 22:10, JBumatay wrote: > Hello, >....... > I usually work with files if I need to look at dbf files I cannot run with dBASE with the mentioned tools. But often they also change them. They always have BLOB errors if I do some processing that I cannot figure out how to do in dBASE. > > In any case, I am now seeing that if I add some code to my forms that I use, I need to account for the Fixed.dbf, Temp.dbf, Oomdl_cur.dbf and Corrupt.txt so I can repair but also locate the problems. > > I am not sure how to implement a code procedure to read the Oomdl_cur.dbf using the tools in dBASE. I am in no hurry. Although, I do hope to learn how to use this in code with a button on a form. I've never had cause to use FIXDBF7.PRG (I don't use .dbf files. All my own data has been saved in Firebird for many years.) but I've just had a look at the program.  Oodml_cur.dbf is a copy of your corrupt .dbf with all the deleted records recalled.  FIXDBF7 reads this table using an OODML query so there should be no reason why you can't do the same. How have you tried to access oodml_cur.dbf? Did dBASE show any error messages? Have you tried using a query object to read it? Why do you actually need to read oodml_cur.dbf?  This is a "throw-away" file used as an intermediate step in FIXDBF7. What processing have you had to use third party tools for that dBASE can't do? There are many things that are difficult to do in dBASE and that is one reason I switched from the BDE with .dbf files to ADO and SQL in Firebird.  That said though, I have been using dBASE for 40 years and have never yet found anything I couldn't actually do.  Mind you, there's always a first time. :-) Mervyn.