Subject Why do two queries work differently
Author stevewe2
I have two D6 DataModules that have the same sort of TIBOQuery
component accessing a table the same way. The SQL is the same for
both: SELECT Table1.* FROM Table1 WHERE (Table1.PKey = :aKeyCol) The
only difference is that one uses Table1 and the other Table2. All
other component properties are the same except that I have to set the
ColumnAttributes property to "PKEY=NOTREQUIRED" for Table1 otherwise
I get a Dataset error, PKey is required when I insert a new record.
Table2 works fine without that property. The Required property for
the PKay field is set to False in both.

Also, when the record is posted (having set properties to get past
the error noted above), Table1 resets the cursor to the BOF record,
while Table2 stays on the inserted record.

What am I doing wrong or where should I be looking to correct this
behavior, as I'd like to stay on the inserted record?

I'm using IB 7.0 and IBO 4.2.I

TIA, Steve