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

ppDesigner error message

edited February 2004 in End User
Hi guys,

I'm getting error message "EVariantTypeCasrerror: Could not convert variant
of type (NULL) into type (Integer)" when trying to save report to DB.
I use Firebird DB and got all required for end-user solution tables,
triggers and generators added to DB. Also rbItem and rbfolder pipelines and
tables configured OK.
I use Borland's TIBTable components as rbItem and rbTable dataset.

Any clues ?

With regards,
Dmitry

Comments

  • edited February 2004
    In addition to my previous message, some source code provided:

    ppDesigner1.DataSettings.DatabaseName := Self.OrgDB.DatabaseName;
    rbfolderIBTbl.Database := Self.OrgDB;
    rbItemIBTbl.Database := Self.OrgDB;
    rbfolderIBTbl.Transaction := Self.OrgDB.DefaultTransaction;
    rbItemIBTbl.Transaction := Self.OrgDB.DefaultTransaction;
    rbfolderIBTbl.Open;
    rbItemIBTbl.Open;
    frmReportExplorer.ppReportExplorer1.Execute;



  • edited February 2004

    1. If you have not done so, use the CreateEndUserTables.sql script installed
    to \RBuilder\Demos\4. EndUser Databases\InterBase.

    2. If you still have an error, then try the end-user examples in
    \RBuilder\Demos\4. EndUser Databases\InterBase. These have been tested.


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2004

    I should have added, that once you get one of the other Interbase examples
    working, then try using Firebird again.


    --
    Nard Moseley
    Digital Metaphors
    http://www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • edited February 2004
    Thanks Nard,

    problem was solved by changing RBFolder's and RBItems data pipelines
    property RefreshAfterPost to true.
    It looked like ReportExplorer could not see new records added to RB_Folder
    and RB_Item tables.

    Cheers,
    Dmitry


This discussion has been closed.