Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Array \ cursor
Message
De
23/11/2002 10:02:06
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
20/11/2002 05:43:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00724659
Message ID:
00726141
Vues:
25
>some one can help me?
>I am new in FoxPro, I want to know why do I need the array if I have the cursor option?
>Thank You

Chaim,
An array is a variable like an object is.
A cursor is a table that Foxpro internally keeps housekeeping for you.
An array being a variable can pass barriers like datasessions where cursors can't.
An array column could hold different datatypes where a cursor column cannot.
Arrays could hold a complete cursor row in one single array element as an object (or any other object ref) where cursors cannot store objects.
Apart from swapping needs of OS itself arrays are always in memory where cursors are on disk (even the smallest possible cursor could fit to memory OS holds a file handle for it).
Arrays are faster in most cases than cursors.
< sigh > Arrays are limited to 65000 elements currently.
In some automation code (like Excel) arrays are the only way to pass some parameters.
Off the top of my head I think these are enough for a necessity to arrays even in Foxpro.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform