[fpc-pascal]Common database access in Pascal

[Michael Van Canneyt]

On Thu, 25 Jul 2002, Thomas Schatzl wrote:

> Subject: Re: [fpc-pascal] Common database access in Pascal
>
>
> Hi,
>
> [Common DB access]
>
> >What about the db components of the vcl/fcl? Though I don't know
> >if they support transactions and how far the fcl implementation is,
> >I don't know exactly either.
> >
> >Just check fcl/db
>
> Thanks for the hint.... I had a look at them, but I think that it's not
> perfectly suitable. Although both the Interbase and MySQL use some
> common database objects provided in db.pp (which doesn't supply any
> documentation, is there something I'm not aware of ?), but their actual
> implementation, e.g. interface to access the database is quite
> different...
>
> So the MySQL part uses the given TDataSet classes approach but the
> Interbase part doesn't. It splits the TDataSet class into three objects
> (It uses some classes of db.pp, but doesn't implement an interbase
> specific TDataSet. Well, I'm not going further into detail)....
>
> Probably I'm a little mistaken about this, but it seems as if I'm still
> nearly at the point where I started :(

Your remarks are to the point. I have started to code something like

TDatabase
TTransaction
TDBDataset

Which would cooperate together much like you would expect them to.