Hi Trevor, I tried this approach in Livecode an it works great. I do have one strange thing going on which I hope you can help with. There are 12 lines in my datagird. I put a breakpoint in GetDataForLine and I see it being called 12 times followed by a slight pause, then it's called another 12 times. I've double checked my code and I'm certain I'm only setting dgNumber ofRecords once. Any ideas?
Pete On Wed, Mar 7, 2012 at 8:19 PM, Trevor DeVore <li...@mangomultimedia.com>wrote: > On Wed, Mar 7, 2012 at 11:37 AM, Pete <p...@mollysrevenge.com> wrote: > > > I emailed sqlitemanager support re the manage/sql tab performance > > difference. Mystery solved by the reply: > > > > "In the Manage panel when you see SELECT * FROM table the real query > > executed is SELECT rowid FROM table and then a SELECT * FROM table WHERE > > rowid=N is execute for each visible row of the listbox. In the SQL panel > > query executed is just what you type" > > > Thanks for following up on that Pete. > > Jérôme - you might try something like this in LiveCode. If you set up the > data grid like the example stack then you would call "SELECT rowid FROM > table" to get the number of records and a list of ids. Then in > GetDataForLine you would execute "SELECT * FROM table WHERE > rowid=N" to fill in the row data that is being displayed. > > -- > Trevor DeVore > Blue Mango Learning Systems > www.clarify-it.com - www.screensteps.com > _______________________________________________ > 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 > > -- Pete Molly's Revenge <http://www.mollysrevenge.com> _______________________________________________ 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
