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 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
