Upgraded ODAC from 5.7 to 6.9 - getting Wrong UpdatingTable

DublinMark · Post by **DublinMark** » Wed 14 Jul 2010 12:05

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.

bork · Post by **bork** » Wed 14 Jul 2010 14:57

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.

DublinMark · Post by **DublinMark** » Wed 14 Jul 2010 16:01

DublinMark · Post by **DublinMark** » Wed 14 Jul 2010 16:33

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.

DublinMark · Post by **DublinMark** » Wed 14 Jul 2010 16:47

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

bork · Post by **bork** » Thu 15 Jul 2010 11:50

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