Subject Re: BLOB File not found
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Wed, 19 May 2021 22:35:21 +0530
Newsgroups dbase.getting-started

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