General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi,
Your opinion may be the best for my case.
Thank u very much !
We do want Fox team improve function of view cause it is very
important for c/s development, you may get them more suggestion
about this as i cann't express myself clearly.
max.
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only