>Jim,
>
>Ok, I found the Help on Create SQL View command. I'm not trying to create a remote view, currently I have a table, which is filtered. I want to use view instead of filtered table.
>This table is a free table or it could be a part of Database.
>So, is it possible to create updatable view and use it aliased by specific alias? Can I buffer view and use TableUpdate/TableRevert command? The application already exists and I don't want to modify it completely.
>
>What do you think?
>
>Thanks in advance.
>
Nadya,
A local view can use a free table as the data source. The name you give the view will be the alias. Views MUST be in a database but the tables they get their data from do not require a database.