General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Create a collection of objects from table rows?
Do you know of a technique that will create a collection of objects where each object in the collection represents a row from a cursor?
Basically, it would be like scattering a cursor to a collection of objects.
Example:
select * from ChildAlias;
where fkey=ParentAlias.pkey;
into cursor csrChildRecords
Then, (pseudo code):
scatter Cursor csrChildRecords to Collection collectionChildRecords
or a method call like CreateCollectionFromCursor('CursorName', 'CollectionName')
where the method would have a do/while loop that will create a collection, and then add an object to the collection for each row in the cursor.
Have you seen thee need or application of such an approach?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only