DelphiFAQ Home Search:

Data Integrity Violation (BDE error message)

 

comments2 comments. Current rating: 5 stars (2 votes). Leave comments and/ or rate it.

Question:
What does BDE error 38 (0026 hex) aka 'Data Integrity Violation' mean?

Answer:
Here is a list of possible explanations for this situation:


9729 : $2601 : Key violation.
9730 : $2602 : Minimum validity check failed.
9731 : $2603 : Maximum validity check failed.
9732 : $2604 : Field value required.
9733 : $2605 : Master record missing.
9734 : $2606 : Master has detail records. Cannot delete or modify.
9735 : $2607 : Master table level is incorrect.
9736 : $2608 : Field value out of lookup table range.
9737 : $2609 : Lookup Table Open operation failed.
9738 : $260A : Detail Table Open operation failed.
9739 : $260B : Master Table Open operation failed.
9740 : $260C : Field is blank.
9741 : $260D : Link to master table already defined.
9742 : $260E : Master table is open.
9743 : $260F : Detail table(s) exist.
9744 : $2610 : Master has detail records. Cannot empty it.
9745 : $2611 : Self referencing referential integrity must be entered one at a time with no other changes to the table
9746 : $2612 : Detail table is open.
9747 : $2613 : Cannot make this master a detail of another table if its details are not empty.
9748 : $2614 : Referential integrity fields must be indexed.
9749 : $2615 : A table linked by referential integrity requires password to open.
9750 : $2616 : Field(s) linked to more than one master.
9751 : $2617 : Expression validity check failed.

Comments:

2006-01-09, 18:51:07
[hidden]  
rating
What does BDE error 'Le champ xx doit avoire une valeur' mean?
2006-01-10, 16:14:54
anonymous  
rating
tableName :XX
Champ: xx.NFis
Propriété required=true;
j'ai essayé avec ErrorCode=9732 pour controler l'éxception 'Le champ Nfis doit avoir une valeur' comme suit :

var
iDBIError: Integer;
begin
if (E is EDBEngineError) then
begin
iDBIError := (E as EDBEngineError).Errors[0].Errorcode;
if iDBIError =9732 then
begin
MessageDlg('Remplir le champ NFis' , mtWarning, [mbOK], 0);
Abort;
end;
End;
mais il semble que ErrorCode n'est pas une erreur EDBEngineError (9732).
Je ne trouve pas la solution (errorcode exacte).

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:
photo Add a picture:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.