Subject Re: [IBO] TIB_Query->Insert throws on non-NULL fields - FIXED
Author Lester Caine
> qry->FieldByName("Notes")->AsString = "Uh-oh";

Yes that will switch to edit mode, and change the current

> qry->Insert(); // Pow!

So that is trying to add another line.

> Does the first line auto insert a row? Or should it throw an
> exception?

Editing an existing record is automatic.

> Anyhow, the correct sequence below works.
> qry->Insert();
> qry->FieldByName("Notes")->AsString = "Uh-oh";

Add the notes to a new line <g>

Lester Caine
L.S.Caine Electronic Services