>Hi All,
>
>I have a primary key setup on a remote view from an ODBC connection. Im trying to use some sort of lookup that is fast like seek() is on VFP tables.
>
>Currently, Im using the e.g (LOCATE FOR mykey = '1234 '; OR LOCATE FOR '1234 ' $ mykey), but not sure if this is the best way or most efficient way to do this on a remote view.
>
>Am I on the right track, or is there a better way to access a specific record on a remote view.
>
>Thanks in advance, I appreciate any input on this.
Craig,
You can create an index on the key fileld after view is open and use SEEK() as you would on a table or cursor. Which way is better depends on the size of the view and how often you've to locate a record.
--sb--