Hi all,
I create an index of a table in SQL server.
can I call this index to use in my VFP program?
and can I use the "Seek" command to search records?
If so, how to do this when I CREATE SQL VIEW?
I have tried to index a remote view, but I found
all records will return from SQL server to
my workstation. This will increase the network
traffic that I don't want.
The property "Fetch" how many records at a time
is useful, but the view only allow me to
"Locate" a record. How to "Seek" a record ?
Becuase I found this is the fastest.