Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement