> 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
Ok, I've got the point. Since I need it for an updatable grid which can be filtered by user on fly it seems the CursorAdapter has some advantages with the dynamic "where" parameters. And of course - in a multiuser environment the CursorAdapter is more "temporary" and hidden (as it is an object) than view; although I know it could be done with views, too - using a kind of a user-id for the name of the view.
But it's nice to know that views are just at hand.
Thank's to both of you, Stefan and Barbara!
Stary