>Are you sure that the SQL statement is passed to the server and the server processes the statement? Programmers here (maybe mistakenly) believe that SQL statements executed with SQLEXEC() are processed by the client PC's processor, not the server's processor.
This is the key difference between a serverdatabase and a file-based database like VFP. Server databases do the crunching themselves and pass only the results over the wire. VFP crunches locally.
Erik Moore
Clientelligence