Error: Wrong updating table - Table xx is unknown

[werkstattboss]

Hello,
I call an SP in Firebird 2.5 (through an IBCQuery, latest version) which has 4 nested procedures in it. These procedures fetch values from different tables, which are then written into output variables of the main procedure.
The procedure runs perfect outside Delphi (IBExpert).
But within Delphi(xe) I get the error message: Wrong updating table - Table xx is unknown
where xx is the name of the table that the main procedure fetches its records from.

As I understood from my searches about this error, something with the "updating table" parameter is wrong or at least not right. Still I miss the point, because the sp does not really update the table.

does Anyone have a suggestion what would help?

TIA
Rolf

[AndreyZ]

Hello,

To solve the problem, set the TIBCQuery.UpdatingTable property to the blank value.
TIBCQuery.UpdatingTable lets you choose a table to update if you have several tables in a query, and it must be set to one of the table names returned by the server. When using stored procedures in TIBCQuery, the server does not return correct name of the tables that are used in these stored procedures. So, if you use stored procedures in TIBCQuery, leave the TIBCQuery.UpdatingTable property blank. Also, if there is no need to update any table, leave the TIBCQuery.UpdatingTable property blank as well.

[werkstattboss]

Thank you again

Rolf

[AndreyZ]

If any other questions come up, please contact us.