I'm confused...is your back-end (server) database VFP?
Anyway, you call the stored proc by replacing "mysqlstatement" below with the stored proc name.
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05