[lazarus] Cliff Status
Michael Van Canneyt
michael.vancanneyt at wisa.be
Mon Oct 4 03:45:48 EDT 1999
On Sun, 3 Oct 1999, Sergio Kessler wrote:
>
> michael at tfdec1.fys.kuleuven.ac.be wrote:
> >
> > - 2 months DAO -> ADO conversion (UNION SQL statements all over the place
>
> beware with DAO in D5, it make bad decisions when you use joins sqls..
the JOINS must be removed completely; it is NOT ansi SQL.
Also, in delphi we don't use the BDE; we use Diamond Access DAO components.
>
> I'm using mOdbc (http://perio.unlp.edu.ar/modbc) and in this
> components we have update, insert, delete sql separated if you
> want (a la TUpdateSql), but ADO come without this ...
>
> I've found that if you make a join sql and try to delete a record,
> a record is deleted from all the tables in the join !
I think this has to do with the 'cascaded delete' option of the tables.
>
> this is _very_ sad, now I have a component making decisions for me...
> (I'm so stupid ?)
>
> and needless to say, ADOExpress come with very nice bugs for your
> pleasure...
:-) We'll move to interbase altogether. I haven't had problems with
that yet :)
Michael.
More information about the Lazarus
mailing list