With our corporate FoxPro app, the DB resides on the server, and many PC's access the DB from our FoxPro app that is located on each PC.

When each PC does a query of the DB, the PC gets all the table data from the server DB, and the PC does all the processing needed itself, then displays the results... correct?

Is there a way to have the server side do the SQL processing? And then the server would send the results to the PC?

And if so, would it be quicker for us?

THX!