fk约束错误的任何替代消息？ [英] any alternative message for fk constraint error ?

问题描述

Hii，



当我尝试删除已经参考的内容时出现错误..



DELETE语句与REFERENCE约束FK_Leaves_dfd冲突。冲突发生在数据库ffdfg，表fdf，列'ffd'中。该声明已被终止。





任何人都可以建议我显示任何替代消息，以便客户理解

Hii ,

I am getting error when i try to delete which is already in reference ..

the DELETE statement conflicted with the REFERENCE constraint "FK_Leaves_dfd". The conflict occurred in database "ffdfg", table "fdf", column 'ffd'. The statement has been terminated.


can any one suggest me any alternative message to display for client understanding

推荐答案

取决于。这里几个样本



您正在尝试删除与父交易相关的交易。



您正试图删除已购买材料的客户。



您正在尝试删除系统中有库存的物料。



就是这样。有人可以给你更好的消息。

It depends. Here few samples

You're trying to delete a transaction which is related to Parent transaction.

You're trying to delete a Customer who has purchased materials.

You're trying to delete a material which has stock in system.

That's it. Someone could give you more better messages.

这篇关于fk约束错误的任何替代消息？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！