如何捕捉数据(主键)重复录入的错误(或例外)?

Question

有两种方法：
1。把刚输入的字符串在库中查找，是否已经有了
2。要么通过try except来捕捉错误了

Answer 1

try except来捕捉错误信息是什么？

Answer 2

try
  ...  
except
  on e:exception do
  if pos('key violation',e.message)<>0 then dosomething;
end;

Answer 3

'key violation'这个异常好象不只是主键冲突才会出发吧？
请高手指教！
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪
倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪磊磊磊磊倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪磊磊磊倪
倪磊磊磊倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪磊磊磊倪
倪磊磊磊倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪磊磊磊倪
倪磊磊磊倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪磊磊磊倪
倪磊磊磊倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪磊磊磊倪
倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪磊磊磊磊磊磊磊磊倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪磊磊倪倪倪倪磊磊倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪磊磊倪倪倪倪磊磊倪倪倪倪倪磊磊磊倪倪倪
倪倪倪磊磊磊倪倪倪倪倪磊磊倪倪倪倪磊磊倪倪磊倪倪磊磊磊倪倪倪
倪倪磊磊磊倪倪倪倪倪倪磊磊磊磊磊磊磊磊倪倪磊磊倪磊磊磊倪倪倪
倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊磊磊倪倪倪
磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊磊倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪磊磊磊磊倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪磊磊磊倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪磊磊倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪倪
倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪倪
倪倪磊磊倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪磊磊倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
磊倪倪倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪倪倪倪
倪倪倪倪倪倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪倪倪倪倪倪倪倪倪倪倪倪倪倪磊磊磊倪倪倪倪倪倪倪倪倪倪倪倪倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊磊倪
倪倪倪倪倪倪倪