Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 error with deleting records

Author  Topic 

asifbhura
Posting Yak Master

165 Posts

Posted - 2005-03-05 : 03:01:09
Hi evryone

i am developing s/w using VB. Wheh i try ot delete records it doesnt delete.
if i insert new records then it is deleted. but already existed records doesnt delete. it gives error as below.

"Delete statement conflicted with column reference constraint "FK_voucher_header_customers" the conflict occurred in database bayan,table voucher_header,column cust_no"

what is solution of this error?

Pls reply soon its urgent

Waiting for reply.

thanx in advance

Kristen
Test

22859 Posts

Posted - 2005-03-05 : 06:40:24
The record you are trying to delete, presumably from the "voucher_header" table, has an associated record in another table - looks like the "Customers" table.

You will have to delete the associated child record(s) before you can delete the parent record.

Kristen
Go to Top of Page
   

- Advertisement -