Redsusia Another way to query list elements (without altering the storage structure) by SQL is to write a sql query as %Query type instead of %SQLQuery.
This will generate three methods queryNameExecute() queryNameFetch() queryNameClose() which you can code. To help you in writing such a query, check-out http://personal.vsnl.com/sukesh_hoogan/ccos.html#Nbr04 Regards -- Sukesh Hoogan e-Linear Enterprise Solutions Bombay, India http//personal.vsnl.com/sukesh_hoogan (updated : June12 , 2004) Sukesh Hoogan <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Redsusia > > Check-out > > http://personal.vsnl.com/sukesh_hoogan/csql.html#Nbr02 > > > -- > Sukesh Hoogan > e-Linear Enterprise Solutions > Bombay, India > http//personal.vsnl.com/sukesh_hoogan (updated : June12 , 2004) > > > Redsusia <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > 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? > > > > > >
