Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Filter To vs Select-Into-Cursor(Pros and Cons)
Message
From
03/05/1998 22:00:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Set Filter To vs Select-Into-Cursor(Pros and Cons)
Miscellaneous
Thread ID:
00096638
Message ID:
00096638
Views:
80
Set Filter To can narrow the scope on Working area.
Even use the Delete command, only the selected scope got effect.

i.e.
Set Exact Off
Set Ansi On
Use ItemTable
* Filter ItemKey Start with 3 Only 
Set Filter To ItemKey = [3]
Delete For .T.
Set Filter To
Browse && find that only starting with 3 itemKey Record has marked!
So, which is better? Select-Into-Cursor or Even a true read/write Cursor cannot update the BaseTable directly. Need further control which taking Confirm Action. Such as 'Insert Into' when confirm add.

So, I would want to Discuss the Pros and Cons on using
SET FILTER TO or a R/W Cursor ?

Especially for the situations/cases to use the method can get better maintainbility! ^_^;
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Reply
Map
View

Click here to load this message in the networking platform