Just for the hell of it, I made a custom property of a button with one billion chars, 100,000,000 lines of ten chars. If I ask it for line, say, 28455999, it gives it instantly.
Craig Newman -----Original Message----- From: Michael Doub <m...@doub.com> To: How to use LiveCode <use-livecode@lists.runrev.com> Sent: Thu, Dec 1, 2011 2:27 pm Subject: Re: Custom Property Data Limit? Bob, Using the GetDataForLine Callback is the technique that I was referring to that forces you to have a fixed row height. See: http://lessons.runrev.com/s/lessons/m/datagrid/l/7341-Displaying-Large-Amounts-of-Data -= Mike On 2011-12-01, at 6:45 PM, Bob Sneidar wrote: > I do not know what that means. At any rate, let me remind everyone that sqlYoga produces arrays that are compatible with datagrids, so that a simple query for all the records or even a subset of records, and then set the dgData of group "myDataGrid" to theDataA or something of the sort. > > for updates, you could do something like trap selectionChanged in the > datagrid script (and I think there is also a way to determine what the last selected row was) so that you can put together an update query whenever the selection changes. Just make sure your datagrid and sql columns match up. > > But even without sqlYoga a loop can be written to parse the cursor out to an array. That is what sqlYoga does internally anyway. But you would also have to get a list of the columns in the table so you could set the keys of the array properly. It's a bit more complicated that way. > > Bob > > > On Dec 1, 2011, at 1:26 PM, m...@doub.com wrote: > >> I found that when going to the database approach and directly feeding the database you are limited to a fixed row height datagrid. >> >> -= Mike > > > _______________________________________________ > use-livecode mailing list > use-livecode@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
