Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temporarily Filter a CursorAdapter
Message
From
10/01/2018 10:03:41
 
 
To
10/01/2018 06:47:00
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01657053
Message ID:
01657071
Views:
61
>>This would query the base record source twice into 2 cursors, if I interpret you correctly (also changing alias of created cursor).
>
>1 CAD class (original),
>1 sub-class with a slightly different .selectCmd (can be set at design time or in .Init()) and a different .Alias

Yupp, as I thought. I still think querying the cursor given from original CAD to be better architecture and probably better performant if indexed binary, as it is a sub-set already clearly established - your worst case: large source table filtered to rights of user and/or area (or "Bag" multipurpose table sometimes used in the nineties to save file handles), where most of records have to be filtered out using dbf over LAN/WAN.

Drawback factor: time to index BINARY on client plus added minimal refresh/update time due to automatic re-indexing. Should not be a problem if cursor reccount is within 4 or 5 digits.
Previous
Reply
Map
View

Click here to load this message in the networking platform