Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create a collection of objects from table rows?
Message
 
 
To
28/12/2008 16:27:07
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01369892
Message ID:
01369898
Views:
12
You can easily build such collection.
loRecordSet = CREATEOBJECT("Collection")
SELECT csrChildRecords
SCAN
	SCATTER NAME loRecord MEMO
	loRecordSet.Add(loRecord)
ENDSCAN
>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?
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform