Click to See Complete Forum and Search --> : Deleting a record from Parent table


deepak_r_patel
April 28th, 2001, 03:27 AM
I have a parent and a child table. When I am trying to delete the record from the parent table it is giving me an error 'Errors Occured'. The error number is -2147217887. I am using a third-party component VSFlexgrid for locating a record to be deleted. The same thing is working for other tables.

amulay
April 28th, 2001, 07:22 AM
U will need to first delete the concerned records from the clild table before removing the record from the Parent table. I believe that the primary key is in the Parent table and its foreign key in the clild .... so u will first need to delete record from the child and then the parent...

amulay