There are two conditions where this error occurs:

1. You have an identity field and a field that is NOT NULL (required) and you post a record.

With BDE versions prior 5. 0, all you can do is ignore the error and continue. The problem is resolved simply by getting BDE 5. 0.

2. You have an identity field which is the primary key and a key field, you have a text field, and you post a record.

With BDE versions prior 5. 0, all you can do is ignore the error and continue. If you have BDE 5. 0 and Delphi, you can turn on the AutoRefresh property of your DataSet to resolve the problem.

If you have BDE 5. 0 and development system other than Delphi 5, you can call DbiSetProp and set curAUTOREFETCH (which is equal to 0x000500 7) to true.

• C++ Builder Example:

#include "bde.hpp" #define curAUTOREFETCH 0x000500 7; Table ->Open(); DbiSetProp(Table ->Handle, curAUTOREFETCH, TRUE);

• Delphi version other than 5 example:

uses bde; const    curAUTOREFETCH = $000500 7; ... Table .Open; DbiSetProp(hDbiObj(Table .Handle), curAUTOREFETCH, Longint(TRUE))

/ 6/99