Dennis We load data in the Temp table, then the user verifies it is correct, clicks a button and we Insert the data to the Regular table. So we want to make sure the data in the Temp table is correct.
Marc From: Dennis McGrath Sent: Tuesday, March 16, 2010 9:12 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Temp Tables Why would you need an FK on a temp table? FKs are for data integrity protection, to prevent the deletion of a PK where a matching FK exists. It is illogical to use PK/FK protection on temp tables as they are not permanent data. Dennis McGrath -------------------------------------------------------------------------------- From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Monday, March 15, 2010 4:31 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Temp Tables Hi Can you have a FK on a Temp Table? ALTER TABLE `tran_spd` ADD FOREIGN KEY ( `treat_dr` ) + REFERENCES `DRINFO` I keep getting an error "referenced table does not exists.." Thanks Marc
