You can only use function that are supported by backend database (SQL Server). They don't have to be supported by VFP but in such case View Designer may not be happy.

> I am using visual foxpro 8 to connect to sql server. I use remote view to connect to the sql server. I find out that there is certain function that i can not use by using view such as recno(), am i right?
>
> Is it when use view, there is certain function or command that can not be used? Can anyone help me on what commands cannot be used for view?
>
> Can you give me some advice on what i need to be careful or taken care when i use view?
>
>