I'm using the self servicing approach and was wondering how you could do the following:

SELECT DISTINCT CarID FROM CarView WHERE CarMake = 'Ford'

CarView is of course a view. I thought I could use the group by approach, however I was receiving a run time error on the selectQuery. Also, after I fill the typed view is it possible to generate an ArrayList of all car IDs in the result set (without iterating the result set)?

You can retrieve that using a dynamic list. See the dynamic list topic in the typedlist/view documentation

As the typed view is a datatable, there is no way to get a column full of data as an array list, you have to traverse the column.

It doesn't look like BuildRelationSet exists for typed views and I could not find documentation using a typed view rather than a typed list. Any ideas?

DotNetShannon wrote:

It doesn't look like BuildRelationSet exists for typed views and I could not find documentation using a typed view rather than a typed list. Any ideas?

You need the 1.0.2004.1 runtime documentation, if you're still using 1.0.2003.3 and its documentation you need to upgrade.