The result cursor of SQLExec() is limited to the same issue of any VFP cursors, in Client-Server is non recomended action to bring up all the table, just what is neeeded.

>I have a basic clarification question. I am using the following commands to view data in our SQL server:

lcsql="SELECT * FROM scEmailView"
lnresult=SQLEXEC(hconn,lcsql,"EmailData2")

>The scEmailView is a view created on the server. My question is what happens when the result of the view goes over 2gb in size (other than being really slow)? By using this method am I limiting myself in regards to amount of data displayed? If I wanted to view the tables directly (not the returned cursor) how would I accomplish that?

>Just some basic questions I have been asking myself. Thanks in advance for the help.