>>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.
Thank you. In the future I need to phrase things better. I was looking for away to increase the speed of some SQL calls that could not be put into Stored Procedures. I did some speed tests and found that at remote sites if we used SQLPrepare() to precompile the SQL statements on the server and then executed them with SQLEXEC() we got much better performance. Micheal Levy pointed me to the sp_executesql Stored Procedure. We can pass a SQL statement(s) and have the SP execute the block.
Fred Lauckner
You know, it works on my computer. I don't know what your problem is.
.Net aint so bad.