Devart Forums

We updated ODAC from 5.7 to 6.9

We have a TOraQuery that we just use to show records, no updating or inserting is performed.

Property UpdatingTable is blank.

This worked perfectly in 5.7, now when we set the SQL property for the select we get a 'Wrong UpdatingTable - table X is invalid'.

We get this error both at runtime and in the IDE when we set the Active property to true.

Please help.

Hello

To reproduce this issue we need more information. Please provide us the query that you are executing in your TOraQuery and the DDL script for creating the tables that are used in your query.

Some more information - we're using persistent fields, some of which are of type fkLookup that reference other tSmartQuery components.

I think the issue is related to this. Removing the persistent fields gets around the initial wrong updatingtable error.

Apologies - problem solved - one of the referred TOraQuerues in the fkLoopup fields was genuinely set to the wrong updating table.

It is good to see that this problem has been solved. If any other questions come up, please contact me.