On Saturday 17 November 2007 07:23:41 am Uwe Grauer wrote: > johnf wrote: > > On Friday 16 November 2007 02:44:30 am Uwe Grauer wrote: > >> I do not want to integrate too much to the database. > >> I still want to be able to switch if i need to. > >> > >> Uwe > > > > Uwe, > > I really don't understand your position. > > You want Dabo to handle the cascade delete instead of the database engine > > - why? The database engine can handle cascade deletes better and faster? > > For example: > > > > ALTER TABLE TEST_DETAILS > > > > ADD CONSTRAINT FK_TEST_DETAILS_1 > > > > FOREIGN KEY (FIRST_FIELD) REFERENCES TEST_HEADER (FIRST_FIELD) > > > > ON UPDATE CASCADE ON DELETE CASCADE > > Do all dabo supported databases handle "On DELETE CASCADE"? > > Uwe
Postgres, Firebird, MsSQL do. I would guess MySQL too. Know nothing about SQLite. -- John Fabiani _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
