Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Temporarily Filter a CursorAdapter
Message
De
10/01/2018 10:03:41
 
 
À
10/01/2018 06:47:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01657053
Message ID:
01657071
Vues:
60
>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform