Subject Re: BLOB File not found
From Leif <leif.abrahamsson@masterelectronic.se>
Date Sun, 23 May 2021 11:12:51 -0400
Newsgroups dbase.getting-started

Akshat Kapoor Wrote:

> Good Evening Leif,
 >         
 > > I checked the .dbf files and they all seems to both memo and image they should. It is in the report file (.rep) it comes up, saying:
 > > -Open without blob file
 > > -Fail Open
 > > -Empty all blob fields
 > > I do "Open without blob file" which I then have to do a 11 times and therafter choose printer comes up. After choosing the printer I have to do the same 11 times again the the print out comes OK.
 > >
> > I did run the debugger and found following,
 > >
> >   this.DATAMODREF1 = new DATAMODREF()
 > >     this.DATAMODREF1.parent = this
 > >     with (this.DATAMODREF1)
 > >        filename = "Rapporter.dmd"
 > >        dataModClass = "RapporterDataModule"
 > >        active = true
 > >        left = 205.3166
 > >        top = 19.3146
 > >     endwith
 > >
> >     with (this.DATAMODREF1.ref.VERIFIKAT11)
 > >        active = true
 > >     endwith
 > >
> > It's when it comes to active = true it hooks up.
 >
> Multiple things to check.
 >
> Are you able to open the dbf file in command window using the command
> use filename?
 >
> If yes then are you able to use this datamodule in a form?
 >
> Create a simple blank form, drag and drop the datamodule from the
> navigator onto the form. Just add a grid to display the data. Run the
> form. If the data is there then we head to the report.
 >
> Which version are you using? And did you code the report or use the
> designer. The code above seems to be a little strange for a designer code.
 >
> The code I get is
 >
> class TRIALREPORT of A4BLANKCREPORT from "a4blank.crp"
 >     set procedure to trial.dmd additive
 >     with (this)
 >        render = class::FORM_RENDER
 >        output = 1        // Printer
 >     endwith
 >
>     this.TRIALDATAMODULE1 = new TRIALDATAMODULE()
 >     this.TRIALDATAMODULE1.parent = this
 >
> That is all. Your code involves many extra lines.
 >
> Another thing to check
 >
>       with (this.DATAMODREF1.ref.VERIFIKAT11)
 >          active = true
 >       endwith
 >
> Are you sure the above is correct reference.
 > Should it not be
 >       with (this.DATAMODREF1.VERIFIKAT11)
 >          active = true
 >       endwith
 >
> And now to some theory.
 > Check the datamodule is pointing to the same file that you are checking
> using the command window. You will not be the first person to make
> alteration in one file and use another file in datamodule.
 >
> I turn the query active in the datamodule itself. I have suffered
> serious heartburn due to this error some time ago when I had just
> started coding in dBase. That was the last day I set the query to active
> in a form or report.
 >
> You are required to press ignore 11 times is strange in itself.
 >
> Regards
 > Akshat
Thanks for all the info,
The software is old and made in the past with dBase Plus, however it's still working fine so no reason to change anything. I have to run it under dBase Plus though as it does not work properly with later dBase versions. Looking for an answer to this new problem I have tried many things. Now I got it to work OK again, what did I do ? I found following files in the program directory which I deleted and the it worked ok again.
_QSQL000.DBF
_QSQL305.DBF
_QSQL317.DBF
_QSQL317.DBT
_QSQL641.DBF
_QSQL641.DBT
_QSQL645.DBF
_QSQL645.DBT

Thanks for all help,
Regards
Leif