IBXQuery1.Parameters "Database not assigned"

SK2014SK2014
edited 6:48PM in FastReport VCL 5
Hi All,

After upgrading from Fast Reports 4 to 5, I get this error when I try to open the form that contains the fast report component:
"Error reading IBXQuery1.Parameters Database not assigned".

I've checked my IBXQuery and IBXDatabase components properties and they all look fine.
This used to work in Fast Reports v4.

Any ideas on how to fix it?

Comments

  • gpigpi
    edited 6:48PM
    Works OK with FR5.0.11. Try to reinstall FR - remove all FR's files and folders and then install FR again
  • SK2014SK2014
    edited 6:48PM
    gpi wrote: »
    Works OK with FR5.0.11. Try to reinstall FR - remove all FR's files and folders and then install FR again

    Hi,

    Thanks for your reply.
    I've tried uninstalling FR a few times and I still get the error.
    I'm using Delphi XE6.
  • apexapex
    edited 6:48PM
    Hello, have the same problem, but with FR 4(FR.4.15.11). Using Delphi XE6.
  • SK2014SK2014
    edited 6:48PM
    apex wrote: »
    Hello, have the same problem, but with FR 4(FR.4.15.11). Using Delphi XE6.


    Hi apex,

    I suggest you open a "ticket" with Fast Reports, so they can provide some answers.

    Just have a few questions:
    Are you also using a Firebird database?
    Do you have another version of Delphi installed on your PC besides XE6?
    Does the error occur at design-time or run-time?

  • apexapex
    edited June 2014
    SK2014 wrote: »
    Hi apex,

    I suggest you open a "ticket" with Fast Reports, so they can provide some answers.

    Just have a few questions:
    Are you also using a Firebird database?
    Do you have another version of Delphi installed on your PC besides XE6?
    Does the error occur at design-time or run-time?

    Yes, I'm using FB 2.5.
    I have Delphi 2007 installed on my PC besides XE6. I open project that was made in Delphi 2007 and have this error when I opening the form that contains the fast report component in XE6. The error occures also when I try to open form containing reports in built application.
  • gpigpi
    edited 6:48PM
    SK2014 wrote: »
    Hi apex,

    I suggest you open a "ticket" with Fast Reports, so they can provide some answers.

    Just have a few questions:
    Are you also using a Firebird database?
    Do you have another version of Delphi installed on your PC besides XE6?
    Does the error occur at design-time or run-time?
    I tested FR 5.0.11 with D7, XE6 and Firebird 2.5 - works OK
    Try to recreate TfrxIBXQuery
  • SK2014SK2014
    edited 6:48PM
    gpi wrote: »
    I tested FR 5.0.11 with D7, XE6 and Firebird 2.5 - works OK
    Try to recreate TfrxIBXQuery

    I removed and recreated the TfrxIBXQuery component and it still happens.
    I also had XE2 installed and removed it, thinking that it may be causing problems, but it didn't solve anything.

    I am not using a template file, all component properties are saved in the .dfm file.
    If I remove the SQL text from the IBX Query component, then I don't get the error at design-time.
    If I add the SQL text from within the code, then I get the error at run-time.
  • SK2014SK2014
    edited 6:48PM
    apex wrote: »
    Hello, have the same problem, but with FR 4(FR.4.15.11). Using Delphi XE6.

    Hi,
    Have you managed to find a solution yet?
  • Milen TodevMilen Todev
    edited 6:48PM
    SK2014 wrote: »
    SK2014 wrote: »
    Hello, have the same problem, but with FR 4(FR.4.15.11). Using Delphi XE6.

    Hi,
    Have you managed to find a solution yet?

    In frxIBXComponents.pas change this procedure: 
    procedure TfrxIBXQuery.UpdateParams;
begin
  if Assigned(FQuery.Database) {and not (ComponentState in [csDesigning])} then // new code
    frxParamsToTParams(Self, FQuery.Params);
end;
    Rebuild and reinstall frxIBX20 and dclfrxIBX20...
    FR 4.15.10.
  • SK2014SK2014
    edited 6:48PM
    Milen Todev wrote: »
    Milen Todev wrote: »
    Milen Todev wrote: »
    Hello, have the same problem, but with FR 4(FR.4.15.11). Using Delphi XE6.

    Hi,
    Have you managed to find a solution yet?

    In frxIBXComponents.pas change this procedure: 
    procedure TfrxIBXQuery.UpdateParams;
begin
  if Assigned(FQuery.Database) {and not (ComponentState in [csDesigning])} then // new code
    frxParamsToTParams(Self, FQuery.Params);
end;
    Rebuild and reinstall frxIBX20 and dclfrxIBX20...
    FR 4.15.10.

    I've tried rebuilding and reinstalling, but I still get the same error. Should I replace the files in the ..\FastReport 5\LibD20 folder?
  • Milen TodevMilen Todev
    edited 6:48PM
    SK2014 wrote: »
    SK2014 wrote: »
    SK2014 wrote: »
    SK2014 wrote: »
    Hello, have the same problem, but with FR 4(FR.4.15.11). Using Delphi XE6.

    Hi,
    Have you managed to find a solution yet?

    In frxIBXComponents.pas change this procedure: 
    procedure TfrxIBXQuery.UpdateParams;
begin
  if Assigned(FQuery.Database) {and not (ComponentState in [csDesigning])} then // new code
    frxParamsToTParams(Self, FQuery.Params);
end;
    Rebuild and reinstall frxIBX20 and dclfrxIBX20...
    FR 4.15.10.

    I've tried rebuilding and reinstalling, but I still get the same error. Should I replace the files in the ..\FastReport 5\LibD20 folder?
    If you using FR 4.15.xx better remove (uninstall?) this folders...
    Look in Component -> Install packages... where is yours BPL on "Fast Report 4.0 IBX Components".
    May be remove and try steps again
  • SK2014SK2014
    edited 6:48PM
    Milen Todev wrote: »
    If you using FR 4.15.xx better remove (uninstall?) this folders...
    Look in Component -> Install packages... where is yours BPL on "Fast Report 4.0 IBX Components".
    May be remove and try steps again


    I tried it again and now the run time errors have gone, but I still get the error at design time.
    I think I'm probably doing something wrong.
    Can you please give me a step by step procedure I can follow to uninstall, rebuild etc.
  • alperpelikalperpelik
    edited 6:48PM
    I have same problem with FR5 and RAD Studio XE7 does any one know exact solution ?

    I uninstall and install al packages and I did whatever write this forum but still I have same problem.

    Alper Pelik
  • gpigpi
    edited 6:48PM 
    procedure TfrxIBXQuery.UpdateParams;
begin
  if Assigned(FQuery.Database) {and not (ComponentState in [csDesigning])} then // new code
    frxParamsToTParams(Self, FQuery.Params);
end;

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport VCL 5Comment As ...

© Vanilla Keystone Theme 2024