On Thursday 22 July 2004 05:18 pm, terry(at)ashtonwoodshomes(dot)com wrote:
> Alternatively, you can do:
> INSERT (accepting the default)
> then SELECT currval(the_sequence_object);
> then <extra inserts of related foreign key records>
did this. barf: foreign key not in original table
--
regards
kg
http://www.onlineindianhotels.net - hotel bookings reservations in over 4600
hotels in India
http://www.ootygolfclub.org