The only way I've seen that successful is ZAP and APPEND FROM then move the record pointer back. Once back you refresh. This all needs to be between LockScreen toggle.
Why not just create a SYS(2015) CDX file you clean up when the cursor is closed? If you CREATE CURSOR from the start, you can create the INDEXes and VFP cleans up the CDX for you. Bill Anderson wrote: > On Mon, Mar 2, 2009 at 11:39 AM, Tracy Pearson <[email protected]>wrote: > >> What is the KEY() generated on the cursor the Grid has? >> Quick testing shows >> Index On (obj.controlsource) Tag Tmp >> creates the tool tip on SET ORDER TO >> tmp && (obj.controlsource) >> >> Tracy >> > > No index is being made. > > Clicking the header determines the Order By clause on the query. In essence, > the query for the control source is reissued when the header is clicked, but > into another cursor. > > The old process (which I'm trying to replace) SCANned the grid > RecordSource's cursor and replaced the first record with the temp cursor's > first record, second record with the temp cursor's second record, etc.., > (SCATTER, then GATHER) then TableUpdate() it. That works but by definition > is slow for larger cursors and for that matter, very xBasey. > > Now I'm trying to (in essence -- I'm using the VFE framework) is clear out > the grid RecordSource's cursor and APPEND from the temp cursor. This > "works", but doesn't display correctly when I'm in the BindEvent code. > > Being that it "works" the old way and not the new way is telling, though. > I'll continue to look there where those changes are made and see if I can > find something... > > Bill _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** 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.
