Subject Updates when part of key is NULL
Author kgdonn
Disclaimer: Yes, I know this table design is terribly whacked but
it's what I have to make work. IBO has so far been pretty amazing at
accommodating all the bizarre twists I've thrown it, and I've almost
got this bear ported. I can see the end...

Now, I've got a table that does not have a primary key, but it does
have a unique compound index, although some fields in the unique index
may be NULL. If none of the fields are NULL, TIBOTable has no problem
locating the record for update, but if any of the index fields are
NULL, it throws an exception saying it can't locate the record. Is
there a way to tell TIBOTable that these key fields may be NULL?

Thanks,
Kevin Donn