Hi!

OOOPs, Sorry!

Sure, for remote views this approach will not work.

You can re-create the view on the fly using Create SQL View command in some database created locally on the local computer (private database needed to do not spoil work for other users that use the same view at the same time). Command like

create SQl VIEW Sample REMOTE CONNECTION Connect1 AS ;
Select * from MyTable Where &lcParam

will create the new view or re-create the existing. Then opening it will run different query.

If you can use SQL Pass-Through commands, better use them in such case, because they allow to run any commands in the string and get a result set. For example, they allow to run stored procedures on SQL Server.



>Hi, Vlad
>
>You can work well with LOCAL view, but does not work with REMOTE view.
>
>What i need is just remote view, do u have any idea about remote view ?
>
>Regards.
>
>max.