Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How many arrays can you stuff into a grid?
Message
From
05/03/2021 17:07:34
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
05/03/2021 16:20:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01678778
Message ID:
01678779
Views:
58
>Hi All,
>
>Is it possible to use an array as a recordsource in a grid?
>Recordsourcetype doesn't list it as an option, but in tinkering with it, I did get it to sorta work, but not very well. It's not a big array, maybe 2 x 10, at the most, but it has to be able to insert/delete rows.
>The contents is created from a string like this: "2222.33.44.55,CN,2222.33.44.66,TW,2222.33.44.77,BD" that's stored in a field of the form's table.
>Any ideas?
>Thanks.
>
>Luke

Why not creating a cursor on the fly and fill it with the array? And afterwards, SQL SELECT into array? It's three commands.

The fox is much better with cursor then array ...

Anyway, if you figure out how to run it, there are some limitations to the memory the fox may use. I have the commands not at hand (set 20 odd years ago and forgotten where) so just google for Foxpro VFP memory.
I fear it's less then the 2GiB + 2GiB memo a cursor may use.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform