I typically use cascading deletes in a situation like this. Alternatively, you can order your deletes in such a way as to delete from the bottom up -- delete the details first, then the parents.

Louis Kleiman
SSTMS, inc.

-----Original Message-----
From: Myles Wakeham [mailto:myles@...]
Sent: Tue 2/22/2005 1:28 PM
To: firebird-support@yahoogroups.com
Cc:
Subject: [firebird-support] What's the best way to do this?


I have to copy a series of about 40 tables from an ODBC data source into a
Firebird SQL database everynight at 12 midnight. This is a 'Data Warehouse'
dump of information from a transactional system to Firebird. All data in
Firebird that was there before, can be completely deleted but I'd like to
keep the table structure intact.

I thought this would be a simple DELETE * from TABLE NAME for each table
that has to be transferred over, but there are primary/foreign key
relationships between the tables and therefore I can't delete out the tables
without upsetting the data integrity in the database.

What is the best practice in these situations?

Myles

===========================
Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
Web: www.techsol.org




_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]