> > Yes, you can build views against free tables. It's only the view itself that must be in a DBC, and you can build that on-the-fly.
>
> Oh, I didn't know that! I use views on SQL server only. I don't really know the reason, but I always preferred to use free tables against putting them to the DBC. So I automatically eliminated views since I thought they need a dbc.
>
> I don't have a lot of experience with views. Do you think they have any advantages than using the CursorAdapter class?

Stefan answered most of your question. One more thing about making a view, though. If you don't have a DBC for the view already, you need to make one with CREATE DATABASE MyViews. Then you can use the code Stefan posted to create a view inside of that DBC

-BP
www.peisch.com