Re: How can I access to Object in Collection Property in the SQL

[Bill McCormick]

List collections cannot be queried in that way. Array collections are 
projected as sub tables and can be queried explicitly. Just changing it 
now won't work well. You need to delete the storage, redefine the 
property and compile - this assumes that you have no data in the DB you 
need to retain. If that is the case you are stuck and will have to pull 
apart the list on the client.

Redsusia wrote:
I have a Class and it has a Collection property.
I want to access to first object in collection property in the SQL
statement.
for example,
SELECT CollectionProperty[0]
FROM MYCLASS
how can i do it?