Dear Sir.
I have some free table with about 200,000 record in all of that. at the moment i create a database for creating local view and use it, and all application saved in my 2012 R2 server. users have a map drive and then run the program in any client.
This is my question. when i want to extract for example 30 record from this free table , system must read and transfer all 200,000 record to client system and local view find 30 record on it. this is make a long time and more traffic on LAN . Is there any way that server find this 30 record and send it to client?
I know we have a remote view to connect remotely but I can not set it for connection problem. I think i need to ODBC driver for vfp to make data source. I can not find this driver anywhere. or any other way to make a remote view.
therefore if you know any document or driver place that can help me , I will be very happy.
with best regards
farzad
I have some free table with about 200,000 record in all of that. at the moment i create a database for creating local view and use it, and all application saved in my 2012 R2 server. users have a map drive and then run the program in any client.
This is my question. when i want to extract for example 30 record from this free table , system must read and transfer all 200,000 record to client system and local view find 30 record on it. this is make a long time and more traffic on LAN . Is there any way that server find this 30 record and send it to client?
I know we have a remote view to connect remotely but I can not set it for connection problem. I think i need to ODBC driver for vfp to make data source. I can not find this driver anywhere. or any other way to make a remote view.
therefore if you know any document or driver place that can help me , I will be very happy.
with best regards
farzad