Data Crid - set the dgNumberOfRecords

[Peter Haworth]

The datagrid calls GetDataForLine every time it needs a line of data to put
into the datagrid.  You will need to write a GetDataForLine handler in the
datagrid's script to handle the logic for doing this.

Get DataFor Line includes a parameter that specifies the line number of the
line needed.  If you are using a database cursor, use the line number to
get hold of the database data for that line (actually, it's the line number
- 1 since cursor record numbers are zero based), format it according to the
datagrid columns, and put into the pdata parameter of the handler.

Be aware that using this method to populate the datagrid means that things
like the dgText and dgData properties of the datagrid will return empty.
If I remember correctly, you will also have to handle your own sorting when
the user clicks on a column header.

It's not trivial and I would not recommend doing it unless you truly need
to display a very large number of records in the datagird and you are
experiencing performance issues.

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>

On Wed, Apr 1, 2015 at 8:16 PM, JB <sundown at pacifier.com> wrote:

> I am using a table form of data grid and trying
> to display the records using a cursor and then
> setting the dgNumberOfRecords.
>
> I am able to get the cursor and the record count
> of the cursor and I can get dgNumberOfRecords
> before I set dgNumberOfRecords.
>
> I want to set dgNumberOfRecords so the records
> are displayed dynamically like is done in the sample
> stack for displaying a large number of records.
>
> Am I supposed to set up the GetDataForLine or the
> dgNumberOfRecords in my data grid somehow?
>
> When I set dgNumberOfRecords nothing else happens
> and any script after that does not work either.
>
> Anyone have a clue why it stops or a different stack that
> shows how to use it properly?
>
> John Balgenorth
>
> _______________________________________________
> 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
>