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

data dictionary -- generating fields and joins -- access violations

edited March 2002 in General
I am trying to create a data dictionary. The table names generated with no
problems, but when i try to generate the field names, i get an access
violation error. I am, however, able add the field names one-by-one. when I
try to generate joins, i get the same error. i am not able to create any
joins.

i'm not sure where to start on this one... any ideas?

Comments

  • edited March 2002
    Try going to the tables page and cleaning up the tables that are defined.
    There is probably an incorrect table in there, like a system table.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited March 2002
    i deleted a few tables and got the same error. even if i try to generate
    fields from one table, i get the same error.

  • edited March 2002
    What version of RB are you using- v6.03? If you create all of the fields
    manually, is there one record which is causing the problem? What database
    are you using? Do our demos work for your specific database you are using
    (RBuilder\Demos\Enduser\Autojoin)?


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited March 2002
    Using 6.02 professional. i can add any fields to the field list, but i still
    cannot do any joins. I am using Interbase. the data dictionary tutorial
    worked fine. is there a demo for interbase data dictionary i can look at?

  • edited March 2002
    You should be able to run the Data Dictionary for the Interbase example in
    the EndUserDatabases demo directory. There is a SQL script to create the
    end user tables in the Interbase directory.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited March 2002
    the same thing happens when i try to generate field names in the demo data
    dictionary. the tables generate with no problems, and then i get the access
    violation error when i try to generate field names.

  • edited March 2002
    I ran our script to create the interbase tables for the end user report
    project. I made sure that I could connect to all of the tables at delphi
    design time, then launched the data dictionary builder. Created the tables,
    fields and joins by using the Generate all possible combinations. I created
    some reports and previewed data with no problems. Whcih exact version of
    Interbase are you using?

    Win 2K
    D6
    RB 6.03
    IB6 server/client which shipped with the Delphi 6 CD.


    Cheers,

    Jim Bennett
    Digital Metaphors

  • edited March 2002
    I am running

    Win 98
    RB 6.02
    D 5
    IB 6.0.0.627

    I have had no problems generating fields and joins with an ODBC data source,
    so this seems to be an InterBase problem.

  • edited March 2002
    Are you connecting via the BDE or DBExpress? I used a fresh copy of the
    Employee demo database supplied from the Interbase installation. I
    recreated the RB_ tables and ran the datadictionary from Delphi 5 with RB
    6.03- no problems. Can you upgrade to RB 6.03- it's free. Contact
    info@digital-metaphors.com with your full registration information for the
    download link. I would suggest reinstalling the demo Employee.gdb database
    from the Interbase cd and copy it to ..\Borland Shared\Data directory where
    our EU demo looks to find it.


    Cheers,

    Jim Bennett
    Digital Metaphors

This discussion has been closed.