Some questions:
1. If the integer primary key (say, tbl_pers.pers_id) is the b-tree value for
the row, is it necessary to compose update triggers to handle a DELETE FROM tbl_pers WHERE pers_id=5; for all of the tables holding pers_id as a foreign key?
2. I want to update the values of a field based on another table. Can I express this in SQL, or do I need to write an explicit code loop?
UPDATE tlkp_a INNER JOIN tbl_b ON tlkp_a.event_type_id = tbl_b.event_type_id
SET tlkp_a.event_type_id = tbl_b.event_type_id;
The gist of this is that I want to write an Access=>ANSI SQL tool that dumps the Access database to a text SQL DDL file, but the AutoNumber=>INTEGER PRIMARY KEY is a little problematic. Might have to stoop to two files with a script in between to manage the procedural aspects. :(
Not the worst outcome, overall.
R,
Chris
_________________________________________________________________
Winterize your home with tips from MSN House & Home. http://special.msn.com/home/warmhome.armx
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
