I just have a message which hurts me to the execution of an application addition:
INSERT INTO EBP (CODE WORDING, HT)
SELECT CODE WORDING, HT
FROM SAB
WHERE BRS.HT> 0;
And here is the message:
Microsoft Access has assigned the null value to 0 field (s) following a conversion error type 1996 record (s) were not added to the table following key violations, 0 record ( s) as a result of violation of lock and 0 record (s) as a result of violations of validation rules. When I run my application even when it works, but this message is not clean, then I had thought about putting something like:
INSERT INTO EBP (CODE WORDING, HT)
SELECT CODE WORDING, HT
FROM SAB
WHERE BRS.HT> 0 AND BRS.CODE <> EBP.CODE;
But a box opens up and so I can enter to EBP.CODE ????? Thank you for advance for your help.
Bookmarks