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,
>
>Research teh CREATE VIEW command in the help file. If it asks you for a disk that is because you haven't installed the MSDN CDs that came with VFP, or you didn't mark the VFP help to be installed on your hard disk.
>
>I don't understand why you are trying to create a remote view, is the data coming from outside of VFP?