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

Also need help with DBISAM

edited July 2002 in General
I followed the instructions in the previous posing on 6/29 but I am having
problems. This is what I have done:

Installed John's daDBISAM component and it list listed in installed
packages.
Created a new application.
Placed tppReport on the form
Placed a tDBISAMDatabase on the form
Set DatabaseName = 'TheDatabase'
Set Name = 'Db'
Set Directory = 'C:\tempdata' (Data is visible in DBSYS in same dir)
Set Connected = True
Double clicked on the ppReport1 component
Clicked the Data tab
Clicked File then Data Settings
Set Session Type to DBISAMSession (it was in the list)
Set Database Name to Db (it was in the list)
Database Type is already set to DBISAM
Clicked ok
Clicked File then New..
Selected Query Designer
There are no tables in the list??

I tried different data directories to no avail. and it works fine using a
BDE Session type. What could I be doing wrong? Using Delphi 6, DBISAM 3.10,
RB 6.03 Pro and Windows 2000

Thanks ,

J. Michael Eubanks
Ideal Software Systems

Comments

  • edited July 2002
    How about the DataDictionary component? My guess would be that since the
    list of tables and files is based on the data dictionary, it may be related
    to the problem. Is it possible one of its properties like DatabaseName or
    Session is not correct on that component?

    Also, try setting Database component's Name property to be the same as the
    DatabaseName property. In your case, set the DatabaseName property to be
    "Db" instead of "TheDatabase". You may need to update your code or other
    components that link to it if you change the name. I know this sounds
    weird, but this is a documented issue with the daDBISAM code.

    One other thing you might try to is to set the ValidateTableNames and
    ValidateFieldNames properties in the DataDictionary component to False.

    Hope some of this helps... :-)

    -- Vinnie Murdico
  • edited July 2002
    Vinnie,


    Renaming the DatabaseName to be the same as the component name made it
    work, thank you very much!

    J. Michael Eubanks
    Ideal Software Systems
  • edited July 2002
    I've added a warning about this on the web site.
    It is buried in the documentation but it is easily missed.
    Hopefully everything is working OK now.

    Jon

  • edited July 2002
    Jon,

    At one time (several months ago), you had sent me a copy of the unit with
    this issue corrected. I've noticed it is now back to the way it was and
    requires the db name to match the component name. Will this be corrected
    again some time in the future?

    Thanks,
    -- Vinnie
  • edited July 2002
    Hi Vinnie,
    The problem actually was NOT fixed in the version I sent you!
    That's why it's reverted back to the original code.

    RBuilder uses the component name rather than the database name
    in their dialog. That dialog is not part of daDBISAM.
    The only safe way, at the moment, is to make sure that both
    names are the same.

    I (and I'm sure others using daDBISAM.pas) will continue to monitor
    the situation.

    Jon

This discussion has been closed.