Subject | Strange error |
---|---|
Author | Stephen Boyd |
Post date | 2005-10-19T14:23:33Z |
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?
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?