designer and mySQL using Zeos

rbuser

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

rbuser

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

digitalmetaphors

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

rbuser

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

digitalmetaphors

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