Key Violation Error

[ameen]

How to avoid seeing the EDBEngineError with message Key Violation.

Ameen

 

[WildWill]

Go to :

http://community.borland.com/article/0,1410,15809,00.html

This Is a short article on Handling EDBEngineError Exceptions with some good and simple examples.

I Hope this is of help

X-) Billy H

bhogar@acxiom.co.uk

 

[Guga]

procedure TForm1.Table1PostError(DataSet: TDataSet; E: EDatabaseError; var Action: TDataAction);
begin
if EDBEngineError(E).Errors[0].ErrorCode = 9729 then
ShowMessage('Record!');
Action:= daAbort;
end;

 

[svanels]

If your table has key field, and you try to post a duplicate, you will get a key violation error S. van Els
SAvanEls@cq-link.sr

 

[ameen]

Thanks for the responses.
Yes, the error was due to duplicate posting of data to the key field.

Ameen