Query Wizard shows no tables
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.
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.
This discussion has been closed.
Comments
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
http://www.digital-metaphors.com
info@digital-metaphors.com
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
http://www.digital-metaphors.com
info@digital-metaphors.com