On Thu, Jul 24, 2008 at 01:49:56PM +0000, Matthew Wilson wrote: > So, if I wanted to make sure that some rows are always in the Sales > table, is there a recommended approach?
Depends on the applications and the DB. If you know the row is in the DB already just point to it using "...FOREIGN KEY REFERENCES...." (I mean SQL CREATE TABLE). If you aren't sure the row is there, I doubt there is a magical service in an SQL backend. You just have to check regularly if the row has been inserted. SQLObject can help a bit - Luke Opperman reminded how you can pass a callable as a default value - but that's all. Oleg. -- Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss