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

DBISAM 3.14

edited August 2002 in DADE
D5, RB6.03, DBISAM3.14, Win2K

I finally found all the pieces needed to make this work, kind of.

I have the data dictionary BuilderSettings setup for the DBISAMSession and
have generated the tables and fields using the Data Dictionary Builder. The
TDBISAMDatabase object has the DatabaseName = Name. I am using a
TDBISAMSession object (not the default).

All looks okay in the development environment, but when I test the end user
report tool, the query wizard does not see the tables. This is a BDE
working application that I am testing with DBISAM. All of the BDE
conversion issues have been addressed, with the exception of the reporting
tool. Any ideas?

Thanks for any help.

Bill McCoy

Comments

  • edited August 2002
    Make sure that the DatabaseName and Name properties are the same for hte
    DBISAM database component on the form. This is the only way that the DADE
    plugin can find the database on the form. Make sure you have the
    DataSettings property configured on the Designer. We're running 3.14 here
    and it works great.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited August 2002
    Jim:

    Thanks for the quick response. The properties are set correctly on the
    database objects as well as the report designer (using SQLType of sqSQL2).

    Can you think of a reason why the Data Dictionary Builder would see the
    tables in the design environment, but the end user runtime would not?

    Bill McCoy


  • edited August 2002
    I compared my project to the demo and discovered that I had to set
    TppDesigner.DataSetttings.UseDataDictionary to False. Odd? The help file
    has nothing on this and the pdf documentation states:

    "Determines whether the data dictionary object assigned to the
    DataDictionary property will be used."

    I don't understand why setting this to False works, but it did.

    Bill McCoy


  • edited August 2002
    Yes, if the data dictionary is empty, then you won't see any tables or
    fields in the query tools. You say that you generated the data dictionary
    entries, and so UseDataDictionary should be true. Make sure that the design
    time database is the same as the database that you are connecting to at
    runtime for the data dictionary tables.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.