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

designer and mySQL using Zeos

edited March 2003 in End User
RB 6.02
Delphi 5

How can I connect a TppDesigner to a mySQL database using Zeos components?
It seems to me that only BDE sessions will work with
TppDesigner.DataSettings. I thought that maybe the dictionary component
could be the answer, but it also only supports BDE sessions. Am I missing
something?

Thank you,

Demian

Comments

  • edited March 2003
    I figured I have to create a few classes and have them registered. OK, done
    that and everything is working now. In runtime, the end-user report
    selects a mySQL database, connects to it, designs and prints his report. In
    design time, however, I can't make the table list display anywhere.

    Is there something particular I should do in design time (I looked over daDB
    and found nothing "special" about design time) or this is simply a problem
    with my implementation?

    Thanks,

    Demian
  • edited March 2003
    You'll have to create a design time package which uses your new plugin
    classes and install it into delphi. There are examples of this for other
    database types in the RBuilder\Demos\EndUserDatabases\ folder. From the top
    of my head, there are DADE plugin source files (daDBISAM, daIBO,
    daADS...etc) which are each included in their own packages, for example, our
    DBISAM example has its daDBISAM.pas DADE plugin included in a package for D7
    in rbISAM77.dpk


    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited March 2003
    Jim,

    Thanks for the reply. I did that. The session type displays in design time
    as expected but the tables do not show up in the report designed query
    builder. I'm pretty sure the problem is with Zeos itself as it is quite full
    of bugs (I had to fix a few of them while building the data view classes).

    I also know the table list is being processed because I get 30 empty entries
    in the table list of the query builder and that matches exactly the 30
    tables of my database. I just don't know why Zeos is not displaying the
    table names correctly in design time (but does so in runtime).

    Right now this is not a big deal because I need the reports only for
    runtime. In design time, if I need a Zeos based report, all I need is a DB
    Pipeline and a Zeos Query.

    Thanks anyway,

    Demian


  • edited March 2003
    One solution is to design your reports and dataviews at runtime. Working
    with the report designer inside the Delphi design time environment is less
    stable then working in it from an executable because of all the complex
    things that happen in the Delphi designer that do not effect a runtime
    executable which you build and run.

    Cheers,

    Jim Bennett
    Digital Metaphors


This discussion has been closed.