General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks again.
I will try it.
>Hi!
>
>There is also another solution, but is is not a good one for large number of filter conditions and not good for maintenance (changes). It is also limited in conditions used. You can create a view with query like following:
>
>SELECT * from MyTable
>WHERE (MyField1 = ?lcParam1 OR ?llParam1) AND (MyField2 = ?lcParam2 OR ?llParam2) ...
>Then before requery set up parameters - for filtering conditions that are not included set appropriate llParam* to .T. and lcParam* to empty value. For all other set the value for filtering and llParam* to .F.
>
>>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
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