Not show Nested Tables fields

[sinys]

ODAC 8.2.8

I'm do

Code: Select all

CREATE TYPE XX_TYPE_CHAIR IS TABLE OF VARCHAR2(100);
/
CREATE TABLE CHAIRS (ID NUMBER, CHAIR_NAME  XX_TYPE_CHAIR)
   NESTED TABLE CHAIR_NAME STORE AS NESTED_CHAIRS;

select * from chairs t;

"select" show only ID field, where "CHAIR_NAME" field?

[bork]

Hello

To show the CHAIR_NAME field in DBGrid, you should set TOraQuery.ObjectView = True. But if you want to see each element of the CHAIR_NAME field, then you should use the TOraNestedTable component and additional DBGrid that will be linked to TOraNestedTable.

[sinys]

But with TOraQuery.ObjectView = True
select MyType(field1, field2) from ...
show as 1 field,
How show MyType as many fields and show nested tables fields?

[sinys]

up

[bork]

As I wrote before, you should use TOraNestedTable and an additional DBGrid to get all values that are stored in the nested table fields. Independently on TOraQuery.ObjectView (True or False), it is unavailable to get all values for nested table fields in the same DBGrid. To help you resolve this issue we need more information: please describe what are you going to do with nested table fields?

[sinys]

I mean that if I set TOraQuery.ObjectView = True then "create type MyType ..."
"select MyType(field1, field2) from ..." return 1 field as TADTField
I want to see from "select CHAIR_NAME, MyType(ID, AA, BB) from ..."
CHAIR_NAME, MyType.ID, MyType.AA, MyType.BB
but I see only CHAIR_NAME and MyType (as TADTField)

[bork]

Now there is no possibility to set object view for one field, but not to set for another. We will investigate the possibility of adding this feature in one of the next builds/versions of ODAC. But now we recommend to use TOraNestedTable and separate DBGrid to show nested table fields.

[sinys]

Delphi XE2, ODAC 9.0.1,
Error: Access violation at address 61055D54 in module 'oracommon11.dll'. Write of address 10000000.
demo

Code: Select all

OraQuery1.Sql.Text := 'select * from chairs t'; // table have 2 records
OraQuery1.Open;
OraQuery1.Next; // - OK
OraQuery1.Close;
OraQuery1.FetchRows := 1000;
OraQuery1.Options.ScrollableCursor := True;
OraQuery1.Open; 
OraQuery1.Next; // - raise exception 

[AlexP]

Hello,

Thank you for the information, we have reproduced the problem and will try to fix it as soon as possible.