Subject Still little problems
Author Salvatore Besso
hello Helen,

ok, I have spent the last three days printing the whole GSG and
starting a very interesting off-line <g> reading. I think that now the
concept of transactions is a bit more clear.

As a result of this reading I have obtained a working form with a good
aspect as well but I still have some small problems (not with
transactions now <g>).

The form works with only one table (no joins) and all the fields are
required. This is enforced also in the database by means of the
respective domains (they are all defined as NOT NULL). The REQUIRED
check box in the TIB_Query.ColumnAttributes for all fields is grayed
so, AFAIK, IBO should ignore the Required management and let the
database throw an error if a null field is let in the row.

For this purpose I have written a simple TIB_Query.OnError handler
containing this code:

RaiseException := False;
MessageDlg('There is an error'....

but I have left for now TIB_Query.CheckRequired := True.

Well, this handler is never fired when I leave a NULL field and I try
to post, and another error message is shown (I suppose it is an IBO
standard error message showing because CheckRequired := True).

But now if I set CheckRequired := False, no errors pop up at all and
the NULL field is written in the row, even if the field has the "NOT
NULL" check in the domain.

What am I doing wrong (or forgetting) now? Shouldn't an EIB_Error pop
up in this case?