DataGrid and cursors

[Peter Haworth]

Hi Mats,
The best way to deal with this for good performance is by using the
datagrid dgNumberOfRecords property.  Take a look at the "Advanced Options"
section of the datagrid manual for more information and a link for a sample
stack to download.

I've used this technique a couple of times and it works well for large
amounts of data.  However, it's a bit tricky to implement since the
datagrid stops using it's internal storage areas and the usual methods for
getting data out of the datagrid (dgData,dgText) all return empty.  Plus
there are some not-so-obvious things you have to deal with yourself, for
example you have to write your own sort handlers.

Pete

Pete
lcSQL Software <http://www.lcsql.com>


On Wed, Nov 13, 2013 at 2:05 PM, Mats Åström <matsastrom at yahoo.se> wrote:

> I have a DataGrid I REALLY want to work with a 40-thousand-plus-records
> db-table. For the last couple of days I have tried various cursor recipies,
> no luck.
>
> I am helpless, does anyone have a workable solution to share?
>
> /Mats
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>