Dennis Schafthuizen
Member²
When I select data from an object view in the SQL Window sometimes the SQL Window "hangs". When I want to close the Window I get the message that the query is still executing. I only have this with queries on object views which are more than 2 levels deep.
An other problem is the result of an collection within an object view. When you want to see the data of the collection, you always get the message : "Collection no longer availabe, Execute the SQL Script again to fetch the collection again".
If you query on an object views which does an select on other object view, the result gives most of the times an value error for the columns from the second object view. The value of the OID columns is sometimes correct but most of the times the value is: . All the other columns gives an , are empty or contain strange characters.
An other problem is the result of an collection within an object view. When you want to see the data of the collection, you always get the message : "Collection no longer availabe, Execute the SQL Script again to fetch the collection again".
If you query on an object views which does an select on other object view, the result gives most of the times an value error for the columns from the second object view. The value of the OID columns is sometimes correct but most of the times the value is: . All the other columns gives an , are empty or contain strange characters.
