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

Query Wizard shows no tables

edited December 2002 in End User
I am using ReportBuilder 6.03 with database FlashFiler 2.12.

I have a database component name dbMain1 with a database name of dbMain1. I
have an alias name of Loans-CS.

If I have my data settings specify my database name, dbMain1, no tables show
up when the query wizard is started. However, if I specify the alias name
instead, Loans-CS, then the tables show up.

Is this working as designed?

I want to be able to control which database location is used by changing
only the alias name of the database component. I suppose I can deal with
this problem with a little extra coding, but I wanted to make sure I wasn't
overlooking something that would allow me to use the database name instead
of the alias name. In the pick list for the data settings, both the
database name and the alias are listed, but only the alias name seems to
work.

David Miller.

Comments

  • edited December 2002
    Even with the component name matching the database name it doesn't work? It
    should find the database component if it is located on the same datamodule
    or form that the designer is on.. Place a break point in
    TdaffSession.GetDatabaseNames in daFF.pas to see what it does. Also change
    your library path to RBuilder\Source.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited December 2002
    "Jim Bennett (Digital Metaphors)" wrote in
  • edited December 2002
    The problem with datamodules in the past was using a TppReport on them and
    running the designer. In RB 6, we fixed it so that you could use
    datamodules as a side effect of having to support Delphi 6 and the object
    treeview, so that you wouldn't see all of our embedded objects by default.

    Another thing to check is that the DataSettings property on the designer is
    setup correctly. This would cause a problem as well if it isn't setup.

    GetDatabaseNames should find the connection/database object in the
    Screen.Datamodules[] array property in Delphi. Any results from tracing
    into our routine?


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.