Hi All,

I am trying to increase the performance our programs. At the present we do all processing on the client side. I have heard that it is better to do this on the server side. This I assume means STORED PROCEDURES. Question, are they faster for SQL statements. The following works:

nconhandle = sqlexec(nhandle, mysqlstatement, 'mycursor')

From here I can use the cursor I retrieved. What I would like, is to have the statement on the server in a stored procedure. If that is the way to go for this kind of data retrieval. What I don’t know is how to call that procedure and return the cursor.

We are using VFP6 SP3 with a standard VFP database.

Any & all thoughts are welcome.
TIA
Mike