I am using 4.5B and Delphi 5. I am getting an error which states:

Index RDB$PRIMARY36 cannot be used in the specified plan.

This is plain enough except I get this error when I commit the current
transaction. I have already used the query in question during the
current transaction to look up certain information. I only get the
error when I commit. If I close the query first I don't get the
error. If I take out the StartTransaction and Commit and rely on
automatic transaction processing I don't get the error either.

What on earth could be causing this?