On Thu, Oct 24, 2013, at 02:29 PM, Dave Crozier wrote: > > Personally I would make the underlying cursor a "SQL Expression" which > you can modify then requery in order to refresh the cursor but this means > that you are dealing wit disconnected data and so updates to the > displayed data need to be processed accordingly and are not automatic as > when using a table as a recordsource.
Hmmm. It's a list of customers and yearly turnover totals for current year, year minus one and so on. The turnover totals aren't stored so I am calculating them in the grid cursor SQL i.e. select accountcode, name, Thisform.GetBalance(accountcode, 1) as prev1 ... and so on. GetBalance() uses an optimised sum .. for expression. So it's the calculation of the balances for 10k records over a network that is taking 10 seconds which is on the slow side for this use case. Oh for built-in paging functionality :) _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1382621961.3221.37987305.34f3e...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.