All,
I have a table that holds references. It has two fields, code and description. Both fields are set to not null. I have a Before Insert trigger that states if the code is null an auto-generated number is used instead. The user can either enter a code or have the system auto-generate one.

I have a delphi form with an IB_Query component on it. When I insert and post a record it stated that the code field is required. I change the column property in the IB_Query so that Not Null was false and blanks are NULL. Now when I add a record the code field is blank and nothing is auto-generated.

What have I done wrong?

Regards,
Marcus.

The information contained in this message or any of its attachments may be privileged and confidential, and is intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you are not the addressee, any disclosure, reproduction, distribution, dissemination or use of this communication is not authorised. If you have received this message in error, we apologise for the inconvenience and request that you advise the sender by using the reply facility in your e-mail software then delete the message and any attachments from your mail and 'deleted messages'. All messages sent and received by BOOT Computers Limited are monitored for virus, high risk file extensions, and inappropriate content and can not therefore be considered secure for confidential information.

[Non-text portions of this message have been removed]