Subject Re: [IBO] TIBOQuery inserts a null record
Author mspencewasunavailable
And the winner (not who I expected at all) is:

"A call to Q.ClearFields made in the AfterInsert event handler."

If I had to guess, I say that the BDE didn't (or at some point
starting with Delphi 1.0, didn't) clear out the old data in the
field array, so when a new record was appended, this got called to
make sure everything was initialized. It also might well have been
superfluous code that just didn't interfere with things.

With IBObjects, it causes some stuff in the internal TIB_thing
(can't remember which one it is) to get reinitialized, which seems
to interfere with the connection to the TIBOQuery structures.

I hope that posting this will prevent anyone else from having a
similar problem if they're ever unfortunate enough to be in my
situation.


Michael D. Spence
Mockingbird Data Systems, Inc.