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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 >>>> [email protected] >>>> Please visit this url to subscribe, unsubscribe and manage your >>>> subscription preferences: >>>> http://lists.runrev.com/mailman/listinfo/use-livecode >>>> >>> _______________________________________________ >>> use-livecode mailing list >>> [email protected] >>> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >>> http://lists.runrev.com/mailman/listinfo/use-livecode >>> >> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
