[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