[fpc-pascal]Common database access in Pascal

[Thomas Schatzl]

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 :(

Btw, if you put a {$IFNDEF WIN32} around the {$LINKLIB}statements of the
interbase test program testib.pp (and set up the example database
according to the supplied script), it works with Interbase/FireBird 1.0
under the win32 platform. (I noticed a "don't know if it works under
windows" notice in the example program)

Regards,
  Thomas