should this produce any results? There are 4 records in db but I do not get anything back.

Dim alerts As New TypedListClasses.PublishedUserAlertsTypedList Dim da As New SQLSpecific.DataAccessAdapter da.FetchTypedList(alerts)

This should work. Do you have any errors? Also does the typed list contain any fields from other joined tables which may not contain related data? Can you enable tracing, help can be found under the Troubleshooting section of the manual, and see if that query returns data for you from the database?

Thanks, Brian

bclubb wrote:

This should work. Do you have any errors? Also does the typed list contain any fields from other joined tables which may not contain related data? Can you enable tracing, help can be found under the Troubleshooting section of the manual, and see if that query returns data for you from the database?

Thanks, Brian

Fixed, it was my problem. I set a join hint to inner and did not have any data in one of the tables. Thanks