Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Array \ cursor
Message
From
23/11/2002 10:02:06
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/11/2002 05:43:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00724659
Message ID:
00726141
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform