Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update form data
Message
 
 
To
06/05/1998 10:12:39
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00089086
Message ID:
00097533
Views:
51
>>>>1) Can I issue subsequent SELECT statements into the same cursor and display the results into the same grid?
>>>>
>>>>2) Am I missing something to make this work?
>>>>
>>>>3) If I have to use SET FILTER instead of SELECT, do they both use the same wildcards?
>>>>SET FILTER can display all data including those that are buffered while SELECT does not, because the latter takes only data that are physically stored on the table (same thing with UPDATE WHERE, DELETE FROM statements). To a certain degree, SET FILTER and SELECT provides the same output using identical filter conditions ofcourse, but that depends on the case as I mentioned
>>>>
>>>>The best solution to the above problem is by using Views so that you can requery and place it in a grid. Besides, using VIEWS takes advantage of the Client/Server capability of VFP. It is faster and easier to maintain. In fact, we rarely use Set Filter as of todate due to speed concerns.
>>>---
>>>Hi Jess
>>>Are you saying to use VIEWS when using the SELECT statement?
>---
>Hi Jess - you sent me a message, but there was nothing in it. please
>try again.. :)

Sorry, it might be a technical problem.

Well, what I am trying to emphasize is using VIEWS created with SQL VIEWS to utilized the WHERE clause which server as FILTER condition in order to get data.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform