[quote]Originally posted by Marco Kalter:
All that is required is that you know the query that returns the collection you want to view or edit.

I hope this helps.
[/quote]I have written in my post that asked for sample code
[quote]
I wish to note that nor the select statement nor types in collections are known in advance.
[/quote]So your sample is of no use for me, sorry.
I have absolutely no control over selects - I have do the following:

  • obtain select from outside
  • execute it
  • check if any collections are present
  • show collections from current records in data-aware controls


It quite possible that collections just can not be obtained with separate selects (they may be results of function calls in the select list and so on).

I have to mention that I have tried this with trial version of ODAC - it is piece of cake.