Data Crid - set the dgNumberOfRecords

[JB]

Thanks again, Pete!

If there is a performance issue due to
a large number of records it can easily
be solved by making another database.

I won’t be using it.  You save me a lot of
time and that really is a big help!

John Balgenorth


On Apr 2, 2015, at 4:19 PM, Peter Haworth <pete at lcsql.com> wrote:

> Not sure about that since I've never used dgNumberOfRecords with a datagrid
> that had a checkbox.  But yes, unless there's a really good reason to use
> it, which is usually performance related, I wouldn't bother with it.
> 
> 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 Thu, Apr 2, 2015 at 3:58 PM, JB <sundown at pacifier.com> wrote:
> 
>> Hi Pete,
>> 
>> Thank you very much for the reply and
>> all of the info!
>> 
>> I relay appreciate the help.  It sounds like
>> that is not the way to go.  I assume it will
>> also disable any checkboxes that were
>> added to the data grid.
>> 
>> thanks again,
>> John Balgenorth
>> 
>> 
>> On Apr 2, 2015, at 9:22 AM, Peter Haworth <pete at lcsql.com> wrote:
>> 
>>> 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
>>>> 
>>> _______________________________________________
>>> 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
>>> 
>> 
>> 
>> _______________________________________________
>> 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
>> 
> _______________________________________________
> 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
>