Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Access Violation

edited June 2014 in General
I have installed Delphi XE5 on a new Windows 7 machine... NexusDB 4 along
with version 15.01 of Report Builder. I'm moving from a Windows XP
machine - Delphi 2010... NexusDB 3 - with version 14.06 of Report Builder.
When I moved my source code to the new machine I find that most of my
reports work with no problem; however, I have a couple that are getting an
Access Violations. With a little experimentation I find when the data field
is of type "Double" in the report data tree I get the error. Has anyone
else encountered this? Any solution?

Joe Hutchins

Comments

  • edited June 2014
    Hi Joe,

    Please upgrade your version of ReportBuilder to the latest (15.04) and
    retest. If, after upgrading you still experience this issue, please
    create a simple example that demonstrates the problem and send it to
    support@digital-metaphors.com in .zip format and we'll take a look at it
    for you.

    Contact info@digital-metaphors.com with your serial number and
    purchasing email address for upgrade instructions.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited June 2014
    Where do I go to download version 15.04... the last email instructions I had
    were for 15.01.



  • edited June 2014
    Contact info@digital-metaphors.com with your serial number and
    purchasing email address for upgrade instructions.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited June 2014
    I've upgraded to version 15.04 of ReportBuilder Pro. I still get the Access
    Violation error. The problem seems to be between ReportBuilder and NexusDB.
    I'm using version 4.0005 of NexusDB. The field that is causing the error is
    defined as type "Extended" in NexusDB. I'm using a TppReport with a
    TppDBPipeLine, connected to a TDataSource, connected to the TnxTable. I
    have no problem printing other fields from the table; however, when I
    attempt to add the "Extended" field to the report I get the Access
    Violation. In the ReportBuilder datatree the field is defined as type
    "double", but that is what was defined in the datatree with the older
    version software. (ReportBuilder 14.06 and NexusDB 3.04 - Delphi 2010).

    If I build a file using KbmMemTable and copy the data from the NexusDB table
    to the KbmMemTable the report will work; however, it won't work printing
    directly from the NexusDB Table.

    It is difficult to send you a simple example since it only comes up with
    ReportBuilder printing from NexusDB. I'm unable to print an "extended" type
    field from a NexusDB table. I don't know if the error is from ReportBuilder
    or from NexusDB (or me).

    Any help or suggestions is appreciated.

    Joe Hutchins


  • edited June 2014
    Hi Joe,

    I helped another customer who reported an issue with NexusDB and 'Extended'
    fields.

    This is not a ReportBuilder issue.

    You can create the issue without just NexusDB (no ReportBuilder). See sample
    code below.

    I had the customer contact NexusDB support and they cited this as a Delphi
    issue, noted in the following Delphi QC report:

    http://qc.embarcadero.com/wc/qcmain.aspx?d=122136


    Here is sample code to create the issue:

    procedure TForm1.Button3Click(Sender: TObject);
    var
    lValue: Extended;
    begin

    // calling AsExtended or AsFloat --> AV
    lValue := nxQuery1.FieldByName('TestField').AsExtended;

    // these also result in AV
    // lValue := nxQuery1.FieldByName('TestField').AsFloat;
    // lValue := nxQuery1.Fields[0].AsExtended;
    // lValue := nxQuery1.Fields[0].AsFloat;


    end;






    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com


    "Joe Hutchins" wrote in message news:53a1a191$1@mail....

    I've upgraded to version 15.04 of ReportBuilder Pro. I still get the Access
    Violation error. The problem seems to be between ReportBuilder and NexusDB.
    I'm using version 4.0005 of NexusDB. The field that is causing the error is
    defined as type "Extended" in NexusDB. I'm using a TppReport with a
    TppDBPipeLine, connected to a TDataSource, connected to the TnxTable. I
    have no problem printing other fields from the table; however, when I
    attempt to add the "Extended" field to the report I get the Access
    Violation. In the ReportBuilder datatree the field is defined as type
    "double", but that is what was defined in the datatree with the older
    version software. (ReportBuilder 14.06 and NexusDB 3.04 - Delphi 2010).

    If I build a file using KbmMemTable and copy the data from the NexusDB table
    to the KbmMemTable the report will work; however, it won't work printing
    directly from the NexusDB Table.

    It is difficult to send you a simple example since it only comes up with
    ReportBuilder printing from NexusDB. I'm unable to print an "extended" type
    field from a NexusDB table. I don't know if the error is from ReportBuilder
    or from NexusDB (or me).

    Any help or suggestions is appreciated.

    Joe Hutchins



    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.