Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ideas for passing records back to calling form
Message
De
22/09/2015 03:40:54
 
 
À
21/09/2015 03:53:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01624724
Message ID:
01624896
Vues:
113
>Hi Albert:
>
>If data to be passed is flat (records) and not complex (hierarchical records from different tables), and for fast performance, you can use simple arrays that can be created with Select-SQL, or even can passs arrays (one or more) attached to an object, so you can pass the object reference and from that you can show directly the array data or generate a cursor with INSERT FROM ARRAY syntax. This way you can avoid the complexity of collections and can debug directly too. Arrays are faster than collections.
>
>On the other side, collections of record objects have the adventage that you can reference the fields by their names, and not by their column numbers, like when using arrays, but for more than a few hundred of records arrays are faster.
>
>Best regards.-

100% agree - both arrays and collections have pros and cons
Experiencing both may help make one's own opinion
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/
Never explain, never complain (Queen Elizabeth II)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform