>I am converting apps from VFP tables to Sql Server. I am considering bringing over some of the look-up tables in a CursorAdaptor and then indexing them in the AfterCursorFill method so that I can SEEK('MCKEE','employee','last_name'). Is this an ok idea or will this cause performance problems. I want to do this so that I don't have to change so much existing code
>
>thanks
>
>bonnie

This is what I do.
Sample:

* "The BufferModeOverride property is only an instruction for CursorFill method, 
*  it doesn't change "Buffering" directly."
*  So can't use: THIS.BufferModeOverride = DB_BUFOPTRECORD  	
CURSORSETPROP( "Buffering", DB_BUFOPTRECORD )
* Use for timeClock.scx.
INDEX ON fieldName TAG tagName
CURSORSETPROP( "Buffering", DB_BUFOPTTABLE )

I am using the CA for VFP tables.
It has worked fine.